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   The number of blocks that were sent by a particular instance but that never arrived in this instance
CR_2HOP NUMBER   The count of CR blocks which were received by this instance from a particular instance after a 2-way round-trip
CR_3HOP NUMBER   The count of CR blocks which were received by this instance from a particular instance after a 3-way round-trip
CURRENT_2HOP NUMBER   The count of current blocks which were received by this instance from a particular instance after a 2-way roundtrip
CURRENT_3HOP NUMBER   The count of current blocks which were received by this instance from a particular instance after a 3-way roundtrip
CR_BLOCK_TIME NUMBER   Total time waited for CR blocks from a particular instance (includes the other times)
CR_BUSY_TIME NUMBER   The time waited for CR blocks which were received by this instance from a particular instance and which were delayed by a log flushed on the sending instance
CR_CONGESTED_TIME NUMBER   The time waited for CR blocks which were received by this instance from a particular instance and which were delayed because LMS was busy
CURRENT_BLOCK_TIME NUMBER   Total time waited for CR blocks from a particular instance (includes the other times)
CURRENT_BUSY_TIME NUMBER   The time waited for current blocks which were received by this instance from a particular instance and which were delayed by a log flushed on the sending instance
CURRENT_CONGESTED_TIME NUMBER   The time waited for current blocks which were received by this instance from a particular instance and which were delayed because LMS was busy
LOST_TIME NUMBER   The time waited for blocks that were sent by a particular instance but that never arrived in this instance
CR_2HOP_TIME NUMBER   The time waited for CR blocks which were received by this instance from a particular instance after a 2-way round-trip
CR_3HOP_TIME NUMBER   The time waited for CR blocks which were received by this instance from a particular instance after a 3-way round-trip
CURRENT_2HOP_TIME NUMBER   The time waited for current blocks which were received by this instance from a particular instance after a 2-way roundtrip
CURRENT_3HOP_TIME NUMBER   The time waited for current blocks which were received by this instance from a particular instance after a 3-way roundtrip