select
  file#,                                   -- FILE# NUMBER
  block#,                                  -- BLOCK# NUMBER
  class#,                                  -- CLASS# NUMBER
  status,                                  -- STATUS VARCHAR2(10)
  xnc,                                     -- XNC NUMBER
  forced_reads,                            -- FORCED_READS NUMBER
  forced_writes,                           -- FORCED_WRITES NUMBER
  lock_element_addr,                       -- LOCK_ELEMENT_ADDR RAW(8)
  lock_element_name,                       -- LOCK_ELEMENT_NAME NUMBER
  lock_element_class,                      -- LOCK_ELEMENT_CLASS NUMBER
  dirty,                                   -- DIRTY VARCHAR2(1)
  temp,                                    -- TEMP VARCHAR2(1)
  ping,                                    -- PING VARCHAR2(1)
  stale,                                   -- STALE VARCHAR2(1)
  direct,                                  -- DIRECT VARCHAR2(1)
  new,                                     -- NEW CHAR(1)
  objd,                                    -- OBJD NUMBER
  ts#,                                     -- TS# NUMBER
  lobid,                                   -- LOBID NUMBER
  cachehint                                -- CACHEHINT NUMBER
from
  gv$bh
where
  inst_id = USERENV('Instance')