Dynamic Performance (V$) Views, 100 of 179
This view lists cursors that each user session currently has opened and parsed.
SADDR
RAW
Session address
SID
NUMBER
Session identifier
USER_NAME
VARCHAR2(30)
User that is logged in to the session
ADDRESS
Used with HASH_VALUE to identify uniquely the SQL statement being executed in the session
HASH_VALUE
Used with ADDRESS to identify uniquely the SQL statement being executed in the session
SQL_TEXT
VARCHAR2(60)
First 60 characters of the SQL statement that is parsed into the open cursor