Updated on 2025-05-29 GMT+08:00

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.