Help Center/ GaussDB/ Developer Guide(Distributed_8.x)/ System Catalogs and System Views/ System Views/ Other System Views/ V$GLOBAL_OPEN_CURSOR
Updated on 2024-06-03 GMT+08:00
View PDF
Share

V$GLOBAL_OPEN_CURSOR

V$GLOBAL_OPEN_CURSOR displays information about all opened cursors on all current nodes.

Table 1 V$GLOBAL_OPEN_CURSOR columns

Name

Type

Description

node_name

name

Node name.

saddr

raw

Not supported. Set it to NULL.

sid

numeric

Session ID.

user_name

varchar2(128)

Username.

address

raw

Not supported. Set it to NULL.

hash_value

numeric

Not supported. Set it to NULL.

sql_id

varchar2(13)

Query statement ID.

sql_text

varchar2(60)

First 60 bytes of the SQL text of a cursor.

last_sql_active_time

date

Not supported. Set it to NULL.

sql_exec_id

numeric

Not supported. Set it to NULL.

cursor_type

varchar2(64)

Cursor type.

  • OPEN-PL/SQL: opened PL/SQL cursor.
  • OPEN: other open cursors.

child_address

raw

Not supported. Set it to NULL.

con_id

numeric

Not supported. Set it to NULL.
Parent topic: Other System Views