Overview
v$sql_workarea_histogram displays the cumulative execution statistics of all workareas, for example, the total number of fully in-memory executions consumed 1 MB to 2 MB of memory and the number of executions in one pass mode.
Field description
| Field name | 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 between 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 between 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 between 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. |