V$GLOBAL_OPEN_CURSOR

V$GLOBAL_OPEN_CURSOR displays information about all opened cursors on all current nodes. For details about the columns, see Table 1.

**Table 1** V$GLOBAL_OPEN_CURSOR columns
Name	Type	Description
node_name	name	Node name.
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.
dbid	oid	ID of the database to which the cursor belongs.