GV$INSTANCE_CACHE_TRANSFER definition in Oracle Database 11.2
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'),
  lost,                                    -- LOST NUMBER
  lost_time,                               -- LOST_TIME NUMBER
  cr_2hop + cr_3hop,                       -- CR_BLOCK NUMBER
  cr_2hop_time + cr_3hop_time,             -- CR_BLOCK_TIME NUMBER
  cr_2hop,                                 -- CR_2HOP NUMBER
  cr_2hop_time,                            -- CR_2HOP_TIME NUMBER
  cr_3hop,                                 -- CR_3HOP NUMBER
  cr_3hop_time,                            -- CR_3HOP_TIME NUMBER
  cr_busy,                                 -- CR_BUSY NUMBER
  cr_busy_time,                            -- CR_BUSY_TIME NUMBER
  cr_congested,                            -- CR_CONGESTED NUMBER
  cr_congested_time,                       -- CR_CONGESTED_TIME NUMBER
  current_2hop + current_3hop,             -- CURRENT_BLOCK NUMBER
  current_2hop_time + current_3hop_time,   -- CURRENT_BLOCK_TIME NUMBER
  current_2hop,                            -- CURRENT_2HOP NUMBER
  current_2hop_time,                       -- CURRENT_2HOP_TIME NUMBER
  current_3hop,                            -- CURRENT_3HOP NUMBER
  current_3hop_time,                       -- CURRENT_3HOP_TIME NUMBER
  current_busy,                            -- CURRENT_BUSY NUMBER
  current_busy_time,                       -- CURRENT_BUSY_TIME NUMBER
  current_congested,                       -- CURRENT_CONGESTED NUMBER
  current_congested_time                   -- CURRENT_CONGESTED_TIME NUMBER
from
  x$instance_cache_transfer

home |  up