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