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