8.101 V$OPEN_CURSOR

V$OPEN_CURSOR lists cursors that each user session currently has opened and parsed, or cached.

Column	Datatype	Description
SADDR	RAW(4 | 8)	Session address
SID	NUMBER	Session identifier
USER_NAME	VARCHAR2(128)	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