Overview
v$sql_workarea displays the workarea statistics of all operators previously subject to automatic SQL memory management.
Field description
| Field name | Type | Nullable | Description |
|---|---|---|---|
| address | VARBINARY(8) | No | The address of the handle corresponding to the SQL statement. No value is specified for this field. |
| 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, for example, 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: * MANUAL * AUTO |
| 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. |
| 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. This column is NULL if the workarea has not used the temporary space. |
| last_tempseg_size | BIGINT(20) | 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 | BIGINT(20) | No | The ID of the tenant. |