V$OPEN_CURSOR

V$OPEN_CURSOR displays information about cursors opened by all current sessions. By default, only the system administrator can access the system view. Common users must be authorized to access the system view. This view exists in both PG_CATALOG and SYS schema.

**Table 1** V$OPEN_CURSOR columns
Name	Type	Description
saddr	raw	Not supported. Its value is NULL.
sid	numeric	Session ID.
user_name	character varying(128)	Username.
address	raw	Not supported. Its value is NULL.
hash_value	numeric	Not supported. Its value is NULL.
sql_id	character varying(13)	Query statement ID.
sql_text	character varying(60)	First 60 bytes of the SQL text of a cursor.
last_sql_active_time	timestamp(0) without time zone	Not supported. Its value is NULL.
sql_exec_id	numeric	Not supported. Its value is NULL.
cursor_type	character varying(64)	Cursor type. OPEN-PL/SQL: opened PL/SQL cursor. OPEN: other open cursors.
child_address	raw	Not supported. Its value is NULL.
con_id	numeric	Not supported. Its value is NULL.