GV$SQL_WORKAREA_HISTOGRAM definition in Oracle Database 11.2
GV$SQL_WORKAREA_HISTOGRAM

select
  INST_ID,                                 -- INST_ID NUMBER
  LOWBND * 1024,                           -- LOW_OPTIMAL_SIZE NUMBER
  (HIBND * 1024)-1,                        -- HIGH_OPTIMAL_SIZE NUMBER
  OPTIMAL,                                 -- OPTIMAL_EXECUTIONS NUMBER
  ONEPASS,                                 -- ONEPASS_EXECUTIONS NUMBER
  MPASS,                                   -- MULTIPASSES_EXECUTIONS NUMBER
  MPASS+ONEPASS+OPTIMAL                    -- TOTAL_EXECUTIONS NUMBER
from
  X$QESMMIWH

home |  up