Purpose
The GV$SQL_WORKAREA view displays the workarea statistics of all operators previously subject to automatic SQL memory management.
Note
This view is introduced since OceanBase Database V2.2.77.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| ADDRESS | VARBINARY(8) | NO | The address of the handle corresponding to the SQL statement. No value is specified for this column. |
| HASH_VALUE | bigint(0) | NO | The hash value of the SQL statement. |
| SQL_ID | varchar(32) | NO | The unique identifier of the SQL statement. |
| CHILD_NUMBER | bigint(0) | NO | The number of the cursor. |
| WORKAREA_ADDRESS | VARBINARY(8) | NO | The address of the workarea. |
| OPERATION_TYPE | varchar(40) | NO | The type of the operator using the workarea, such as Sort, Hash Join, or Group by. |
| OPERATION_ID | bigint(20) | NO | The unique identifier of the operator in the plan tree. |
| POLICY | varchar(10) | NO | The policy for the workarea. Valid values: |
| ESTIMATED_OPTIMAL_SIZE | bigint(20) | NO | The estimated memory size in bytes required for executing the operator in the workarea in optimal mode. |
| ESTIMATED_ONEPASS_SIZE | bigint(20) | NO | The estimated memory size in bytes required for executing the operator in one pass mode. |
| LAST_MEMORY_USED | bigint(20) | NO | The size in bytes of the memory used by the cursor in the last execution. |
| LAST_EXECUTION | varchar(10) | NO | Indicates whether the workarea selects the optimal, one pass, or multipasses mode in the last execution of the cursor. |
| LAST_DEGREE | bigint(20) | NO | The degree of parallelism in the last execution. |
| TOTAL_EXECUTIONS | bigint(20) | NO | The total number of executions in the workarea. |
| OPTIMAL_EXECUTIONS | bigint(20) | NO | The number of executions in optimal mode. |
| ONEPASS_EXECUTIONS | bigint(20) | NO | The number of executions in one pass mode. |
| MULTIPASSES_EXECUTIONS | bigint(20) | NO | The number of executions in multipasses mode. |
| ACTIVE_TIME | bigint(20) | NO | The average active duration of the workarea in seconds. |
| MAX_TEMPSEG_SIZE | bigint(20) | 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 | bigint(20) | NO | The size of the temporary disk space used by the workarea in the last execution. The value of this column is NULL if no temporary space is used. |
| CON_ID | bigint(20) | NO | The ID of the tenant. |
| SVR_IP | varchar(46) | NO | The IP address of the server. |
| SVR_PORT | bigint(20) | NO | The port number of the server. |