GV$INSTANCE_CACHE_TRANSFER
select inst_id, -- INST_ID NUMBER instance, -- INSTANCE NUMBER decode -- CLASS VARCHAR2(18) (class, 1, 'data block', 2, 'sort block', 3, 'save undo block', 4, 'segment header', 5, 'save undo header', 6, 'free list', 7, 'extent map', 8, '1st level bmb', 9, '2nd level bmb', 10, '3rd level bmb', 11, 'bitmap block', 12, 'bitmap index block', 13, 'file header block', 14, 'unused', 15, 'undo header', 16, 'undo block'), cr_block, -- CR_BLOCK NUMBER cr_busy, -- CR_BUSY NUMBER cr_congested, -- CR_CONGESTED NUMBER current_block, -- CURRENT_BLOCK NUMBER current_busy, -- CURRENT_BUSY NUMBER current_congested -- CURRENT_CONGESTED NUMBER from x$instance_cache_transfer

home |  up  |  mailbox