DBA_HIST_INST_CACHE_TRANSFER

DBA_HIST_INST_CACHE_TRANSFER displays the historical statistics on the cache blocks transferred among instances. This view contains snapshots of V$INSTANCE_CACHE_TRANSFER.

Column Datatype NULL Description
SNAP_ID NUMBER   Unique snapshot ID
DBID NUMBER   Database ID for the snapshot
INSTANCE_NUMBER NUMBER   Instance number for the snapshot
INSTANCE NUMBER   Instance from which the blocks are transferred
CLASS VARCHAR2(18)   Class of the cache block
CR_BLOCK NUMBER   CR block transfers not affected by remote processing delays
CR_BUSY NUMBER   Current block transfers affected by remote contention
CR_CONGESTED NUMBER   CR block transfers affected by remote system load
CURRENT_BLOCK NUMBER   Current block transfers not affected by remote processing delays
CURRENT_BUSY NUMBER   Current block transfers affected by remote contention
CURRENT_CONGESTED NUMBER   Current block transfers affected by remote system load
LOST NUMBER   ???
CR_2HOP NUMBER   ???
CR_3HOP NUMBER   ???
CURRENT_2HOP NUMBER   ???
CURRENT_3HOP NUMBER   ???
CR_BLOCK_TIME NUMBER   ???
CR_BUSY_TIME NUMBER   ???
CR_CONGESTED_TIME NUMBER   ???
CURRENT_BLOCK_TIME NUMBER   ???
CURRENT_BUSY_TIME NUMBER   ???
CURRENT_CONGESTED_TIME NUMBER   ???
LOST_TIME NUMBER   ???
CR_2HOP_TIME NUMBER   ???
CR_3HOP_TIME NUMBER   ???
CURRENT_2HOP_TIME NUMBER   ???
CURRENT_SHOP_TIME NUMBER   ???