V$OPEN_CURSOR

This view lists cursors that each user session currently has opened and parsed.

Column Datatype Description
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