Purpose
The GV$SQL_WORKAREA view displays the statistical information about the workareas for all operators that are subject to automatic SQL memory management.
Note
This view is introduced since OceanBase Database V2.2.77.
Columns
Column |
Type |
Nullable? |
Description |
|---|---|---|---|
| ADDRESS | RAW(8) | NO | The address of the handle corresponding to the SQL statement. At present, this column is not supported and is NULL by default. |
| HASH_VALUE | NUMBER | NO | The hash value of the SQL 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. |
| CHILD_NUMBER | NUMBER | NO | The number of the cursor. At present, this column is not supported and is NULL by default. |
| 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(40) | NO | The policy for the workarea. Valid values: |
| ESTIMATED_OPTIMAL_SIZE | NUMBER | NO | The estimated memory size in bytes required for executing the operator in the workarea in optimal mode. |
| ESTIMATED_ONEPASS_SIZE | NUMBER | NO | The estimated memory size in bytes required for executing the operator in one pass mode. |
| LAST_MEMORY_USED | NUMBER | NO | The size in bytes of the memory used by the cursor in the last execution. |
| LAST_EXECUTION | VARCHAR2(40) | NO | Indicates whether the workarea selects the optimal, one pass, or multipasses mode in the last execution of the cursor. |
| LAST_DEGREE | NUMBER | NO | The degree of parallelism in the last execution. |
| TOTAL_EXECUTIONS | NUMBER | NO | The total number of executions in the workarea. |
| OPTIMAL_EXECUTIONS | NUMBER | NO | The number of executions in optimal mode. |
| ONEPASS_EXECUTIONS | NUMBER | NO | The number of executions in one pass mode. |
| MULTIPASSES_EXECUTIONS | NUMBER | NO | The number of executions in multipasses mode. |
| ACTIVE_TIME | NUMBER | NO | The average active duration of the workarea in seconds. |
| MAX_TEMPSEG_SIZE | NUMBER | NO | The maximum size in bytes of the temporary disk space used by the workarea. The value of this column is NULL if no temporary space is used. |
| LAST_TEMPSEG_SIZE | NUMBER | NO | The size of the temporary disk space used by the workarea in the last execution. This column is NULL if the workarea did not use the temporary space. |
| CON_ID | NUMBER | NO | The ID of the tenant. |
| SVR_IP | VARCHAR2(46) | NO | The IP address of the server. |
| SVR_PORT | NUMBER(38) | NO | The port number of the server. |