ADDRESS |
RAW(4) |
Address of the parent cursor handle |
HASH_VALUE |
NUMBER |
The hash value of the parent statement in the library cache. Two columns (PARENT_HANDLE, HASH_VALUE ) can be used to join with V$SQLAREA to locate the parent cursor. |
CHILD_NUMBER |
NUMBER |
Child cursor number using this work area. The columns (PARENT_HANDLE, HASH_VALUE, CHILD_NUMBER ) can be used to join with V$SQL to locate the child cursor using this area. |
WORKAREA_ADDRESS |
RAW(4) |
Address of the workarea handle. This is the "primary key" for the view. |
OPERATION_TYPE |
VARCHAR2(20) |
Type of operation using the work area (for example, SORT, HASH JOIN, GROUP BY, BUFFERING, BITMAP MERGE, BITMAP CREATE ) |
OPERATION_ID |
NUMBER |
A unique number used to identify the operation in the execution plan. This identifier can be joined to V$SQL_PLAN to locate the operation that uses this work area. |
POLICY |
VARCHAR2(10) |
Sizing policy for this work area (MANUAL or AUTO ) |
ESTIMATED_OPTIMAL_SIZE |
NUMBER |
Estimated size (in KB) required by this work area to execute the operation completely in memory (optimal execution). Derived from either optimizer statistics or previous executions. |
ESTIMATED_ONEPASS_SIZE |
NUMBER |
Estimated size (in KB) required by this work area to execute the operation in a single pass. Derived from either optimizer statistics or previous executions. |
LAST_MEMORY_USED |
NUMBER |
The memory (in KB) used by this work area during the last execution of the cursor |
LAST_EXECUTION |
VARCHAR2(10) |
Indicates whether this work area runs using OPTIMAL, ONE PASS , or ONE PASS memory requirement (or MULTI-PASS ), during the last execution of the cursor |
TOTAL_EXECUTIONS |
NUMBER |
Number of times this work area was active |
OPTIMAL_EXECUTIONS |
NUMBER |
Number of times this work area ran in optimal mode |
ONEPASS_EXECUTIONS |
NUMBER |
Number of times this work area ran in one-pass mode |
MULTIPASSES_EXECUTIONS |
NUMBER |
Number of times this work area ran below the one-pass memory requirement |
ACTIVE_TIME |
NUMBER |
Average time this work area is active (in centi-seconds) |