V$SQL_WORKAREA definition in Oracle Database 11.2
V$SQL_WORKAREA
select
ADDRESS, -- ADDRESS RAW(8)
HASH_VALUE, -- HASH_VALUE NUMBER
SQL_ID, -- SQL_ID VARCHAR2(13)
CHILD_NUMBER, -- CHILD_NUMBER NUMBER
WORKAREA_ADDRESS, -- WORKAREA_ADDRESS RAW(8)
OPERATION_TYPE, -- OPERATION_TYPE VARCHAR2(20)
OPERATION_ID, -- OPERATION_ID NUMBER
POLICY, -- POLICY VARCHAR2(10)
ESTIMATED_OPTIMAL_SIZE, -- ESTIMATED_OPTIMAL_SIZE NUMBER
ESTIMATED_ONEPASS_SIZE, -- ESTIMATED_ONEPASS_SIZE NUMBER
LAST_MEMORY_USED, -- LAST_MEMORY_USED NUMBER
LAST_EXECUTION, -- LAST_EXECUTION VARCHAR2(10)
LAST_DEGREE, -- LAST_DEGREE NUMBER
TOTAL_EXECUTIONS, -- TOTAL_EXECUTIONS NUMBER
OPTIMAL_EXECUTIONS, -- OPTIMAL_EXECUTIONS NUMBER
ONEPASS_EXECUTIONS, -- ONEPASS_EXECUTIONS NUMBER
MULTIPASSES_EXECUTIONS, -- MULTIPASSES_EXECUTIONS NUMBER
ACTIVE_TIME, -- ACTIVE_TIME NUMBER
MAX_TEMPSEG_SIZE, -- MAX_TEMPSEG_SIZE NUMBER
LAST_TEMPSEG_SIZE -- LAST_TEMPSEG_SIZE NUMBER
from
GV$SQL_WORKAREA
where
inst_id = USERENV('Instance')