Note
This view is introduced since OceanBase Database V2.2.77.
Purpose
The V$SQL_WORKAREA_ACTIVE view displays the workarea information about active operators.
Columns
Column |
Type |
Nullable? |
Description |
|---|---|---|---|
| SQL_HASH_VALUE | bigint(0) | NO | The hash value of the executed statement. The current value is NULL. |
| SQL_ID | varchar(32) | NO | The unique identifier of the SQL statement. |
| SQL_EXEC_START | date | NO | The time when the SQL statement execution starts. |
| SQL_EXEC_ID | bigint(20) | NO | The unique identifier of the SQL execution. |
| WORKAREA_ADDRESS | varbinary(8) | NO | The address of the workarea. |
| OPERATION_TYPE | varchar(40) | NO | The type of the operator using the workarea, such as Sort, Hash Join, or Group by. |
| OPERATION_ID | bigint(20) | NO | The unique identifier of the operator in the plan tree. |
| POLICY | varchar(6) | NO | The policy for the workarea. Valid values: |
| SID | bigint(20) | NO | The unique identifier of the session. |
| QCINST_ID | bigint(0) | NO | The instance ID of the query coordinator. |
| QCSID | bigint(0) | NO | The session ID of the query coordinator. |
| ACTIVE_TIME | bigint(20) | NO | The average active duration of the workarea, in milliseconds. |
| WORK_AREA_SIZE | bigint(20) | NO | The maximum size in bytes of the workarea used by the operator. |
| EXPECT_SIZE | bigint(20) | NO | The expected size in bytes of the workarea. |
| ACTUAL_MEM_USED | bigint(20) | NO | The size in bytes of memory allocated to the workarea. |
| MAX_MEM_USED | bigint(20) | NO | The maximum size in bytes of memory used by the workarea. |
| NUMBER_PASSES | bigint(20) | NO | The operating mode of the workarea. Valid values: 0: The optimal mode.1: The one pass mode. |
| TEMPSEG_SIZE | bigint(20) | NO | The size in bytes of the temporary space used by the workarea. The value NULL indicates that no temporary file is written. |
| TABLESPACE | varchar(20) | NO | The table namespace for writing temporary files. The value NULL indicates that no temporary file is written. |
| SEGRFNO# | bigint(0) | NO | The number of files related to temporary file writes. The value NULL indicates that no temporary file is written. |
| SEGBLK# | bigint(0) | NO | The number of blocks for creating temporary files in the workarea. The value NULL indicates that no temporary file is written. |
| CON_ID | bigint(20) | NO | The ID of the tenant. |
| SVR_IP | varchar(46) | NO | The IP address of the OBServer node. |
| SVR_PORT | bigint(20) | NO | The port number of the OBServer node. |