select
  id,                                      -- ID NUMBER
  name,                                    -- NAME VARCHAR2(20)
  block_size,                              -- BLOCK_SIZE NUMBER
  resize_state,                            -- RESIZE_STATE VARCHAR2(10)
  current_size,                            -- CURRENT_SIZE NUMBER
  buffers,                                 -- BUFFERS NUMBER
  target_size,                             -- TARGET_SIZE NUMBER
  target_buffers,                          -- TARGET_BUFFERS NUMBER
  prev_size,                               -- PREV_SIZE NUMBER
  prev_buffers,                            -- PREV_BUFFERS NUMBER
  lo_bnum,                                 -- LO_BNUM NUMBER
  hi_bnum,                                 -- HI_BNUM NUMBER
  lo_setid,                                -- LO_SETID NUMBER
  hi_setid,                                -- HI_SETID NUMBER
  set_count                                -- SET_COUNT NUMBER
from
  gv$buffer_pool
where
  inst_id = USERENV('Instance')