V$SQL_WORKAREA_HISTOGRAM definition in Oracle Database 11.2
V$SQL_WORKAREA_HISTOGRAM

select
  LOW_OPTIMAL_SIZE,                        -- LOW_OPTIMAL_SIZE NUMBER
  HIGH_OPTIMAL_SIZE,                       -- HIGH_OPTIMAL_SIZE NUMBER
  OPTIMAL_EXECUTIONS,                      -- OPTIMAL_EXECUTIONS NUMBER
  ONEPASS_EXECUTIONS,                      -- ONEPASS_EXECUTIONS NUMBER
  MULTIPASSES_EXECUTIONS,                  -- MULTIPASSES_EXECUTIONS NUMBER
  TOTAL_EXECUTIONS                         -- TOTAL_EXECUTIONS NUMBER
from
  GV$SQL_WORKAREA_HISTOGRAM
where
  INST_ID = USERENV('Instance')

home |  up