V$INSTANCE_CACHE_TRANSFER definition in Oracle Database 11.2
V$INSTANCE_CACHE_TRANSFER

select
  instance,                                -- INSTANCE NUMBER
  class,                                   -- CLASS VARCHAR2(18)
  lost,                                    -- LOST NUMBER
  lost_time,                               -- LOST_TIME NUMBER
  cr_block,                                -- CR_BLOCK NUMBER
  cr_block_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_block,                           -- CURRENT_BLOCK NUMBER
  current_block_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
  gv$instance_cache_transfer
where
  inst_id = USERENV('Instance')

home |  up