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 schemas. In the multi-tenancy scenario, global information is returned if this view is accessed in a non-PDB, and information about a PDB is returned if this view is accessed in the PDB.
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) |
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. The value is NULL. |
sql_exec_id |
numeric |
Not supported. The value is NULL. |
cursor_type |
character varying(64) |
Cursor type.
|
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. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot