Purpose
The V$OPEN_CURSOR view displays information about the open session cursors.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| SVR_IP | VARCHAR2(46) | NO | The IP address of the OBServer node. |
| SVR_PORT | NUMBER(38) | NO | The port number of the OBServer node. |
| SADDR | VARCHAR2(8) | NO | The address of the session in memory. |
| SID | NUMBER | NO | The ID of the session. |
| USER_NAME | VARCHAR2(30) | NO | The username. |
| ADDRESS | VARCHAR2(8) | NO | The SQL address. It identifies a unique SQL statement together with the hash value of the SQL statement. At present, this column is NULL. |
| HASH_VALUE | NUMBER | NO | The hash value of the SQL statement. At present, this column is NULL. |
| SQL_ID | VARCHAR2(32) | NO | The ID of the SQL statement. |
| SQL_TEXT | VARCHAR2(60) | NO | The first 60 characters in the text of the SQL statement. |
| LAST_SQL_ACTIVE_TIME | DATE | NO | The time when the SQL statement was last executed. |
| SQL_EXEC_ID | NUMBER | NO | At present, this column is NULL. |
| CURSOR_TYPE | VARCHAR2(30) | NO | The type of the cursor. Valid values:
|
| CHILD_ADDRESS | VARCHAR2(30) | NO | This column is not supported at present. |
| CON_ID | NUMBER | NO | The ID of the data container. At present, the column value is 0. |