select
  FREE_SPACE,                              -- FREE_SPACE NUMBER
  AVG_FREE_SIZE,                           -- AVG_FREE_SIZE NUMBER
  FREE_COUNT,                              -- FREE_COUNT NUMBER
  MAX_FREE_SIZE,                           -- MAX_FREE_SIZE NUMBER
  USED_SPACE,                              -- USED_SPACE NUMBER
  AVG_USED_SIZE,                           -- AVG_USED_SIZE NUMBER
  USED_COUNT,                              -- USED_COUNT NUMBER
  MAX_USED_SIZE,                           -- MAX_USED_SIZE NUMBER
  REQUESTS,                                -- REQUESTS NUMBER
  REQUEST_MISSES,                          -- REQUEST_MISSES NUMBER
  LAST_MISS_SIZE,                          -- LAST_MISS_SIZE NUMBER
  MAX_MISS_SIZE,                           -- MAX_MISS_SIZE NUMBER
  REQUEST_FAILURES,                        -- REQUEST_FAILURES NUMBER
  LAST_FAILURE_SIZE,                       -- LAST_FAILURE_SIZE NUMBER
  ABORTED_REQUEST_THRESHOLD,               -- ABORTED_REQUEST_THRESHOLD NUMBER
  ABORTED_REQUESTS,                        -- ABORTED_REQUESTS NUMBER
  LAST_ABORTED_SIZE                        -- LAST_ABORTED_SIZE NUMBER
from
  GV$SHARED_POOL_RESERVED
where
  inst_id = USERENV('Instance')