Overview
v$sql_workarea_active displays the workarea information of active operators.
Field description
| Field name | Type | Nullable | Description |
|---|---|---|---|
| sql_hash_value | BIGINT(0) | No | The hash value of the statement being executed. |
| sql_id | varchar(32) | No | The unique identifier of the SQL statement. |
| sql_exec_start | date | No | The time when the execution of the SQL statement started. |
| sql_exec_id | BIGINT(20) | No | The unique identifier of the SQL execution. |
| 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(6) | No | The policy for the workarea. Valid values: * MANUAL * AUTO |
| sid | BIGINT(20) | No | The unique identifier of the session. |
| qcinst_id | BIGINT(0) | No | The instance ID of the query coordinator. |
| qcsid | BIGINT(0) | No | The session ID of the query coordinator. |
| active_time | BIGINT(20) | No | The average active duration of the workarea in milliseconds. |
| work_area_size | BIGINT(20) | No | The maximum size in bytes of the workarea used by the operator. |
| expect_size | BIGINT(20) | No | The expected size in bytes of the workarea. |
| actual_mem_used | BIGINT(20) | No | The size in bytes of memory allocated to the workarea. |
| max_mem_used | BIGINT(20) | No | The maximum size in bytes of memory used by the workarea. |
| number_passes | BIGINT(20) | No | The operating mode of the workarea. Valid values: * 0: The optimal mode. * 1: The optimal mode. * ≥ 2: The multipasses mode. |
| tempseg_size | BIGINT(20) | No | The size in bytes of the temporary space used by the workarea. The value NULL indicates that no temporary file is written. |
| tablespace | varchar(20) | No | The table namespace for writing temporary files. The value NULL indicates that no temporary file is written. |
| segrfno# | BIGINT(0) | No | The number of files related to temporary file writes. The value NULL indicates that no temporary file is written. |
| segblk# | BIGINT(0) | No | The number of blocks for creating temporary files in the workarea. The value NULL indicates that no temporary file is written. |
| con_id | BIGINT(20) | No | The ID of the tenant. |