V$OPEN_CURSOR

V$OPEN_CURSOR displays information about cursors opened by all sessions on the current node. 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 the PG_CATALOG and SYS schemas. For details about the columns, see Table 1.

**Table 1** V$OPEN_CURSOR columns
Name	Type	Description
saddr	raw	Not supported. The value is NULL.
sid	numeric	Session ID.
user_name	character varying(128)	Username.
address	raw	Not supported. The value is NULL.
hash_value	numeric	Not supported. The value is NULL.
sql_id	character varying(13)	ID of a query statement.
sql_text	character varying(60)	First 60 bytes of the SQL text of a cursor.
last_sql_active_time	date	Not supported. The value is NULL.
sql_exec_id	numeric	Not supported. The 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. The value is NULL.
con_id	numeric	Not supported. The value is NULL.