Overview
GV$SQL_WORKAREA_ACTIVE displays the workarea information of active operators.
Field description
| Field name | 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 time when the SQL statement execution starts. At present, this field is not supported and is NULL by default. |
| SQL_EXEC_ID | NUMBER(38) | NO | The unique identifier of the 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, for example, 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 policy 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 in bytes of the workarea used by the operator. |
| EXPECT_SIZE | NUMBER(38) | NO | The expected size in bytes of the workarea. |
| ACTUAL_MEM_USED | NUMBER(38) | NO | The size in bytes of memory allocated to the workarea. |
| MAX_MEM_USED | NUMBER(38) | NO | The maximum size in bytes of memory used by the workarea. |
| NUMBER_PASSES | NUMBER(38) | NO | The operating mode of the workarea. Valid values: |
| TEMPSEG_SIZE | NUMBER(38) | 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(20) | NO | The table namespace for writing temporary files. The value NULL indicates that no temporary file is 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. The value NULL indicates that no temporary file is 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. The value NULL indicates that no temporary file is written. At present, this field is not supported and is NULL by default. |
| CON_ID | NUMBER(38) | NO | The ID of the tenant. |
