[Home] [Help] [Dependency Information]
Object Name: | V_$SQL_WORKAREA |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ADDRESS | RAW | (8) | ||
HASH_VALUE | NUMBER | |||
SQL_ID | VARCHAR2 | (13) | ||
CHILD_NUMBER | NUMBER | |||
WORKAREA_ADDRESS | RAW | (8) | ||
OPERATION_TYPE | VARCHAR2 | (40) | ||
OPERATION_ID | NUMBER | |||
POLICY | VARCHAR2 | (10) | ||
ESTIMATED_OPTIMAL_SIZE | NUMBER | |||
ESTIMATED_ONEPASS_SIZE | NUMBER | |||
LAST_MEMORY_USED | NUMBER | |||
LAST_EXECUTION | VARCHAR2 | (10) | ||
LAST_DEGREE | NUMBER | |||
TOTAL_EXECUTIONS | NUMBER | |||
OPTIMAL_EXECUTIONS | NUMBER | |||
ONEPASS_EXECUTIONS | NUMBER | |||
MULTIPASSES_EXECUTIONS | NUMBER | |||
ACTIVE_TIME | NUMBER | |||
MAX_TEMPSEG_SIZE | NUMBER | |||
LAST_TEMPSEG_SIZE | NUMBER | |||
CON_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT ADDRESS
, HASH_VALUE
, SQL_ID
, CHILD_NUMBER
, WORKAREA_ADDRESS
, OPERATION_TYPE
, OPERATION_ID
, POLICY
, ESTIMATED_OPTIMAL_SIZE
, ESTIMATED_ONEPASS_SIZE
, LAST_MEMORY_USED
, LAST_EXECUTION
, LAST_DEGREE
, TOTAL_EXECUTIONS
, OPTIMAL_EXECUTIONS
, ONEPASS_EXECUTIONS
, MULTIPASSES_EXECUTIONS
, ACTIVE_TIME
, MAX_TEMPSEG_SIZE
, LAST_TEMPSEG_SIZE
, CON_ID
FROM SYS.V_$SQL_WORKAREA;
|
|
|