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')

home |  up