select
  inst_id,                                 -- INST_ID NUMBER
  PHADD_QESRS,                             -- ADDRESS RAW(8)
  HASHV_QESRS,                             -- HASH_VALUE NUMBER
  SQLID_QESRS,                             -- SQL_ID VARCHAR2(13)
  PLHASH_QESRS,                            -- PLAN_HASH_VALUE NUMBER
  HADDR_QESRS,                             -- CHILD_ADDRESS RAW(8)
  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