Purpose
The GV$SQL_WORKAREA_HISTOGRAM view displays the cumulative execution statistics of all workareas, such as the total number of fully in-memory executions that consumed 1 MB to 2 MB of memory and the number of executions in one pass mode.
Note
This view is introduced since OceanBase Database V2.2.77.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| LOW_OPTIMAL_SIZE | bigint(20) | NO | The minimum memory for the workarea in optimal mode. |
| HIGH_OPTIMAL_SIZE | bigint(20) | NO | The maximum memory for the workarea in optimal mode. |
| OPTIMAL_EXECUTIONS | bigint(20) | NO | The number of executions in optimal mode in the workarea with a memory size between values of LOW_OPTIMAL_SIZE and HIGH_OPTIMAL_SIZE. |
| ONEPASS_EXECUTIONS | bigint(20) | NO | The number of executions in one pass mode in the workarea with a memory size between values of LOW_OPTIMAL_SIZE and HIGH_OPTIMAL_SIZE. |
| MULTIPASSES_EXECUTIONS | bigint(20) | NO | The number of executions in multipasses mode in the workarea with a memory size between values of LOW_OPTIMAL_SIZE and HIGH_OPTIMAL_SIZE. |
| TOTAL_EXECUTIONS | bigint(20) | NO | The total number of executions in the workarea. |
| 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. |
