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  |  mailbox