Note
This view is available starting with V2.2.77.
Purpose
This view displays the workarea information of the current active operator on the current node.
Columns
| Column | Type | Nullable | Description |
|---|---|---|---|
| SQL_HASH_VALUE | NUMBER | NO | The hash value of the executed statement. 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 start time of the SQL execution. 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. This column is not supported and is NULL by default. |
| OPERATION_TYPE | VARCHAR2(160) | NO | The type of the workarea operator, such as Sort, Hash Join, and Group by. |
| OPERATION_ID | NUMBER | NO | The unique identifier of the operator in the plan tree. |
| POLICY | VARCHAR2(24) | NO | The strategy of the workarea:
|
| SID | NUMBER | NO | The unique identifier of the session. |
| QCINST_ID | NUMBER | NO | The instance ID of the query coordinator. This column is not supported and is NULL by default. |
| QCSID | NUMBER | NO | The session identifier of the query coordinator. This column is not supported and is NULL by default. |
| ACTIVE_TIME | NUMBER | NO | The average active time of the workarea, in milliseconds. |
| WORK_AREA_SIZE | NUMBER | NO | The maximum size of the workarea used by the operator, in bytes. |
| EXPECT_SIZE | NUMBER | NO | The expected size of the workarea, in bytes. |
| ACTUAL_MEM_USED | NUMBER | NO | The size of the workarea requested, in bytes. |
| MAX_MEM_USED | NUMBER | NO | The maximum memory usage of the workarea, in bytes. |
| NUMBER_PASSES | NUMBER | NO | The mode in which the workarea runs:
|
| TEMPSEG_SIZE | NUMBER | NO | The size of the temporary space used by the workarea, in bytes. If this column is NULL, no temporary file was written. |
| TABLESPACE | VARCHAR2(128) | NO | The tablespace of the temporary file. If this column is NULL, no temporary file was written. This column is not supported and is NULL by default. |
| SEGRFNO# | NUMBER | NO | The number of files related to the temporary file. If this column is NULL, no temporary file was written. This column is not supported and is NULL by default. |
| SEGBLK# | NUMBER | NO | The number of blocks used to create the temporary file by the workarea. If this column is NULL, no temporary file was written. This column is not supported and is NULL by default. |
| CON_ID | NUMBER | NO | The tenant ID. |
| SVR_IP | VARCHAR2(46) | NO | The IP address of the server. |
| SVR_PORT | NUMBER(38) | NO | The port number of the server. |