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