Purpose
v$sql_workarea_active displays the information about the workarea of the current active operator.
Fields
| Field | Type | Nullable? | Description |
|---|---|---|---|
| sql_hash_value | bigint(0) | NO | The Hash value of the statement to be executed. The current value is NULL. |
| 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, 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(6) | NO | The strategy for the workarea. Valid values: |
| 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: |
| 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. |