Note
This view is available starting with V3.1.2.
Overview
Displays information about the currently open session cursor.
Applicability
This view is applicable only to the Oracle-compatible mode of OceanBase Database.
Columns
Field Name |
Type |
Whether can be NULL |
Description |
|---|---|---|---|
| SVR_IP | VARCHAR2(46) | NO | Server IP Address |
| SVR_PORT | NUMBER(38) | NO | Server Port Number |
| SADDR | VARCHAR2(8) | NO | Session Memory Address |
| SID | NUMBER | NO | Session ID |
| USER_NAME | VARCHAR2(30) | NO | Username |
| ADDRESS | VARCHAR2(8) | NO | SQL address, which uniquely identifies an SQL statement together with the SQL hash. Currently, this field is NULL. |
| HASH_VALUE | NUMBER | NO | SQL Hash. Currently, this field is NULL. |
| SQL_ID | VARCHAR2(32) | NO | SQL ID |
| SQL_TEXT | VARCHAR2(60) | NO | The first 60 string characters of the SQL text |
| LAST_SQL_ACTIVE_TIME | DATE | NO | Last Execution Time |
| SQL_EXEC_ID | NUMBER | NO | This field is currently null. |
| CURSOR_TYPE | VARCHAR2(30) | NO | Cursor type, which currently includes two states:
|
| CHILD_ADDRESS | VARCHAR2(30) | NO | This field is not supported. |
| CON_ID | NUMBER | NO | The ID of the container to which the data belongs. The current value is1 |
Sample query
View information about open session cursors on the current node.
obclient[SYS]> SELECT * FROM SYS.V$OPEN_CURSOR;
The query result is as follows:
+----------------+----------+----------+------------+-----------+---------+------------+----------------------------------+--------------------------------------------+----------------------+-------------+-------------+---------------+--------+
| SVR_IP | SVR_PORT | SADDR | SID | USER_NAME | ADDRESS | HASH_VALUE | SQL_ID | SQL_TEXT | LAST_SQL_ACTIVE_TIME | SQL_EXEC_ID | CURSOR_TYPE | CHILD_ADDRESS | CON_ID |
+----------------+----------+----------+------------+-----------+---------+------------+----------------------------------+--------------------------------------------+----------------------+-------------+-------------+---------------+--------+
| 172.xx.xxx.xxx | 2882 | dab241f0 | 3221681162 | SYS | NULL | NULL | 9B8880F5228B9CE6E9282AB83F35E34A | SELECT * FROM SYS.V$OPEN_CURSOR | 07-MAY-25 | NULL | OPEN | NULL | 1 |
| 172.xx.xxx.xxx | 2882 | dab40b70 | 3221724339 | SYS | NULL | NULL | NULL | ALTER SYSTEM SET arbitration_timeout='30s' | 07-MAY-25 | NULL | OPEN | NULL | 1 |
| 172.xx.xxx.xxx | 2882 | 2a852b70 | 3221557889 | SYS | NULL | NULL | NULL | select * from GV$OB_GLOBAL_TRANSACTION | 07-MAY-25 | NULL | OPEN | NULL | 1 |
+----------------+----------+----------+------------+-----------+---------+------------+----------------------------------+--------------------------------------------+----------------------+-------------+-------------+---------------+--------+
3 rows in set