Purpose
GV$SQL_WORKAREA displays the workarea statistics of all operators previously subject to automatic SQL memory management.
Fields
| Field | Type | Nullable? | Description |
|---|---|---|---|
| ADDRESS | RAW(8) | NO | The address of the handle corresponding to the SQL statement. At present, this field is not supported and is NULL by default. |
| HASH_VALUE | NUMBER | NO | The hash value of the SQL 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. |
| CHILD_NUMBER | NUMBER | NO | The number of the cursor. At present, this field is not supported and is NULL by default. |
| 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(10) | NO | The strategy for the workarea. Valid values: |
| ESTIMATED_OPTIMAL_SIZE | NUMBER(38) | NO | The estimated memory size required for executing the operator in the workarea in optimal mode, in bytes. |
| ESTIMATED_ONEPASS_SIZE | NUMBER(38) | NO | The estimated memory size required for executing the operator in one-pass mode, in bytes. |
| LAST_MEMORY_USED | NUMBER(38) | NO | The size of the memory used by the cursor during the last execution, in bytes. |
| LAST_EXECUTION | VARCHAR2(10) | NO | Indicates whether the optimal, one-pass, or multi-pass mode is selected for the workarea during the last execution of the cursor. |
| LAST_DEGREE | NUMBER(38) | NO | The degree of parallelism during the last execution. |
| TOTAL_EXECUTIONS | NUMBER(38) | NO | The total number of executions in the workarea. |
| OPTIMAL_EXECUTIONS | NUMBER(38) | NO | The number of executions in optimal mode. |
| ONEPASS_EXECUTIONS | NUMBER(38) | NO | The number of executions in one-pass mode. |
| MULTIPASSES_EXECUTIONS | NUMBER(38) | NO | The number of executions in multi-pass mode. |
| ACTIVE_TIME | NUMBER(38) | NO | The average active duration of the workarea, in seconds. |
| MAX_TEMPSEG_SIZE | NUMBER(38) | NO | The maximum size of the temporary disk space used by the workarea, in bytes. If this field is NULL, it indicates that the temporary space was not used. |
| LAST_TEMPSEG_SIZE | NUMBER(38) | NO | The size of the temporary disk space used by the workarea during the last execution. If this field is NULL, it indicates that the temporary space was not used. |
| CON_ID | NUMBER(38) | NO | The ID of the tenant. |