V$GC_ELEMENT definition in Oracle Database 11.2
V$GC_ELEMENT

select
  gc_element_addr,                         -- GC_ELEMENT_ADDR RAW(8)
  indx,                                    -- INDX NUMBER
  class,                                   -- CLASS NUMBER
  gc_element_name,                         -- GC_ELEMENT_NAME NUMBER
  mode_held,                               -- MODE_HELD NUMBER
  block_count,                             -- BLOCK_COUNT NUMBER
  releasing,                               -- RELEASING NUMBER
  acquiring,                               -- ACQUIRING NUMBER
  writing,                                 -- WRITING NUMBER
  recovering,                              -- RECOVERING NUMBER
  local,                                   -- LOCAL NUMBER
  flags                                    -- FLAGS NUMBER
from
  gv$gc_element
where
  inst_id = USERENV('Instance')

home |  up