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')