Purpose
GV$SQL_WORKAREA_ACTIVE displays the workarea information about active operators.
Fields
| Field | Type | Nullable? | Description |
|---|---|---|---|
| SQL_HASH_VALUE | NUMBER | NO | The hash value of the executed statement. At present, this field 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 SQL execution. At present, this field is not supported and is NULL by default. |
| SQL_EXEC_ID | NUMBER(38) | NO | The unique identifier of SQL execution. |
| WORKAREA_ADDRESS | RAW(8) | NO | The address of the workarea. At present, this field is not supported and is NULL by default. |
| OPERATION_TYPE | VARCHAR2(40) | NO | The type of the operator using the workarea, such as Sort, Hash Join, or Group by. |
| OPERATION_ID | NUMBER(38) | NO | The unique identifier of the operator in the plan tree. |
| POLICY | VARCHAR2(6) | NO | The strategy for the workarea. Valid values: |
| SID | NUMBER(38) | NO | The unique identifier of the session. |
| QCINST_ID | NUMBER | NO | The instance ID of the query coordinator. At present, this field is not supported and is NULL by default. |
| QCSID | NUMBER | NO | The session ID of the query coordinator. At present, this field is not supported and is NULL by default. |
| ACTIVE_TIME | NUMBER(38) | NO | The average active duration 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(38) | NO | The expected size of the workarea, in bytes. |
| ACTUAL_MEM_USED | NUMBER(38) | NO | The size of memory allocated to the workarea, in bytes. |
| MAX_MEM_USED | NUMBER(38) | NO | The maximum size of memory used by the workarea, in bytes. |
| NUMBER_PASSES | NUMBER(38) | NO | The operating mode of the workarea. Valid values: |
| TEMPSEG_SIZE | NUMBER(38) | NO | The size of the temporary space used by the workarea, in bytes. If this field is NULL, it indicates that no temporary file was written. |
| TABLESPACE | VARCHAR2(20) | NO | The table namespace for writing temporary files. If this field is NULL, it indicates that no temporary file was written. At present, this field is not supported and is NULL by default. |
| SEGRFNO# | NUMBER | NO | The number of files related to temporary file writes. If this field is NULL, it indicates that no temporary file was written. At present, this field is not supported and is NULL by default. |
| SEGBLK# | NUMBER | NO | The number of blocks for creating temporary files in the workarea. If this field is NULL, it indicates that no temporary file was written. At present, this field is not supported and is NULL by default. |
| CON_ID | NUMBER(38) | NO | The ID of the tenant. |