Dynamic Performance (V$) Views, 100 of 179

V$OPEN_CURSOR

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

Column	Datatype	Description
`SADDR`	`RAW`	Session address
`SID`	`NUMBER`	Session identifier
`USER_NAME`	`VARCHAR2(30)`	User that is logged in to the session
`ADDRESS`	`RAW`	Used with HASH_VALUE to identify uniquely the SQL statement being executed in the session
`HASH_VALUE`	`NUMBER`	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