SADDR |
RAW(4 | 8) |
Session address |
SID |
NUMBER |
Session identifier |
USER_NAME |
VARCHAR2(30) |
User that is logged in to the session |
ADDRESS |
RAW(4 | 8) |
Used with HASH_VALUE to uniquely identify the SQL statement being executed in the session |
HASH_VALUE |
NUMBER |
Used with ADDRESS to uniquely identify the SQL statement being executed in the session |
SQL_ID |
VARCHAR2(13) |
SQL identifier of 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 |
LAST_SQL_ACTIVE_TIME |
DATE |
Time when this cursor was last executed |
SQL_EXEC_ID |
NUMBER |
If the open cursor is executing, then the SQL execution identifier for that execution (see V$SQL_MONITOR) |
CURSOR_TYPE |
VARCHAR2(64) |
Type of cursor:
-
OPEN PL/SQL - Open PL/SQL cursors
-
OPEN - Other open cursors
-
SESSION CURSOR CACHED - Cursors cached in the generic session cursor cache
-
OPEN RECURSIVE - Open recursive cursors
-
DICTIONARY LOOKUP CURSOR CACHED - Cursors cached in the dictionary lookup cursor cache
-
BUNDLE DICTIONARY LOOKUP CACHED - Cursors cached in the bundled dictionary lookup cursor cache
-
JAVA NAME TRANSLATION CURSOR CACHED - Cursors cached in the Java name translation cursor cache
-
REPLICATION TRIGGER CURSOR CACHED - Cursors cached in the replication trigger cursor cache
-
CONSTRAINTS CURSOR CACHED - Cursors cached in the constraints cursor cache
-
PL/SQL CURSOR CACHED - Cursors cached in the PL/SQL cursor cache
|
CHILD_ADDRESS |
RAW(4 | 8) |
Address of the child cursor |
CON_ID |
NUMBER |
The ID of the container to which the data pertains. Possible values include:
-
0: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs.
-
1: This value is used for rows containing data that pertain to only the root
-
n: Where n is the applicable container ID for the rows containing data
|
