V$OPEN_CURSOR
V$OPEN_CURSOR displays information about cursors opened by all sessions on the current node. By default, only users with the SYSADMIN permission 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.
| 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.
|
| 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. |
What is your overall rating for this page?
Thank 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
