GV$SQL_PLAN_STATISTICS

select
inst_id,                 -- INST_ID NUMBER
PHADD_QESRS,             -- ADDRESS RAW(4)
HASHV_QESRS,             -- HASH_VALUE NUMBER
CHILDNO_QESRS,           -- CHILD_NUMBER NUMBER
OPERID_QESRS,            -- OPERATION_ID NUMBER
EXECS_QESRS,             -- EXECUTIONS NUMBER
LSTARTS_QESRS,           -- LAST_STARTS NUMBER
STARTS_QESRS,            -- STARTS NUMBER
LOUTROWS_QESRS,          -- LAST_OUTPUT_ROWS NUMBER
OUTROWS_QESRS,           -- OUTPUT_ROWS NUMBER
LCRGETS_QESRS,           -- LAST_CR_BUFFER_GETS NUMBER
CRGETS_QESRS,            -- CR_BUFFER_GETS NUMBER
LCUGETS_QESRS,           -- LAST_CU_BUFFER_GETS NUMBER
CUGETS_QESRS,            -- CU_BUFFER_GETS NUMBER
LDREADS_QESRS,           -- LAST_DISK_READS NUMBER
DREADS_QESRS,            -- DISK_READS NUMBER
LDWRITES_QESRS,          -- LAST_DISK_WRITES NUMBER
DWRITES_QESRS,           -- DISK_WRITES NUMBER
LELAPTIME_QESRS,         -- LAST_ELAPSED_TIME NUMBER
ELAPTIME_QESRS           -- ELAPSED_TIME NUMBER
from
X$QESRSTAT
home |  up  |  mailbox