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