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