4.325 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	NOT NULL	Unique snapshot ID
DBID	NUMBER	NOT NULL	Database ID for the snapshot
INSTANCE_NUMBER	NUMBER	NOT NULL	Instance number for the snapshot
INSTANCE	NUMBER	NOT NULL	Instance from which the blocks are transferred
CLASS	VARCHAR2(18)	NOT NULL	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 round-trip
CURRENT_3HOP	NUMBER		The count of current blocks which were received by this instance from a particular instance after a 3-way round-trip
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 round-trip
CURRENT_3HOP_TIME	NUMBER		The time waited for current blocks which were received by this instance from a particular instance after a 3-way round-trip
CON_DBID	NUMBER		The database ID of the PDB for the sampled session
CON_ID	NUMBER		The ID of the container that CON_DBID identifies. Possible values include: 0: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs. 1: This value is used for rows containing data that pertain to only the root n: Where n is the applicable container ID for the rows containing data

See Also:

"V$INSTANCE_CACHE_TRANSFER"