select
  SQL_HASH_VALUE,                          -- SQL_HASH_VALUE NUMBER
  SQL_ID,                                  -- SQL_ID VARCHAR2(13)
  SQL_EXEC_START,                          -- SQL_EXEC_START DATE
  SQL_EXEC_ID,                             -- SQL_EXEC_ID NUMBER
  WORKAREA_ADDRESS,                        -- WORKAREA_ADDRESS RAW(8)
  OPERATION_TYPE,                          -- OPERATION_TYPE VARCHAR2(20)
  OPERATION_ID,                            -- OPERATION_ID NUMBER
  POLICY,                                  -- POLICY VARCHAR2(6)
  SID,                                     -- SID NUMBER
  QCINST_ID,                               -- QCINST_ID NUMBER
  QCSID,                                   -- QCSID NUMBER
  ACTIVE_TIME,                             -- ACTIVE_TIME NUMBER
  WORK_AREA_SIZE,                          -- WORK_AREA_SIZE NUMBER
  EXPECTED_SIZE,                           -- EXPECTED_SIZE NUMBER
  ACTUAL_MEM_USED,                         -- ACTUAL_MEM_USED NUMBER
  MAX_MEM_USED,                            -- MAX_MEM_USED NUMBER
  NUMBER_PASSES,                           -- NUMBER_PASSES NUMBER
  TEMPSEG_SIZE,                            -- TEMPSEG_SIZE NUMBER
  TABLESPACE,                              -- TABLESPACE VARCHAR2(30)
  SEGRFNO#,                                -- SEGRFNO# NUMBER
  SEGBLK#                                  -- SEGBLK# NUMBER
from
  GV$SQL_WORKAREA_ACTIVE
where
  INST_ID = USERENV('Instance')