Dynamic Performance (V$) Views, 221 of 238

V$TEMP_CACHE_TRANSFER

V$TEMP_CACHE_TRANSFER displays the number of blocks pinged per datafile. This information in turn can be used to determine access patterns to existing datafiles and deciding new mappings from datafile blocks to PCM locks.

Column	Datatype	Description
`FILE_NUMBER`	`NUMBER`	Number of the datafile
`X_2_NULL`	`NUMBER`	Number of lock conversions from Exclusive-to-NULL for all blocks in the file
`X_2_NULL_FORCED_WRITE`	`NUMBER`	Number of forced writes that occur for blocks of the specified file due to Exclusive-to-NULL conversions
`X_2_NULL_FORCED_STALE`	`NUMBER`	Number of times a block in the file was made `STALE` due to Exclusive-to-NULL conversions
`X_2_S`	`NUMBER`	Number of lock conversions from Exclusive-to-Shared for all blocks in the file
`X_2_S_FORCED_WRITE`	`NUMBER`	Number of forced writes that occur for blocks of the specified file due to Exclusive-to-Shared conversions
`S_2_NULL`	`NUMBER`	Number of lock conversions from Shared-to-NULL for all blocks in the file
`S_2_NULL_FORCED_STALE`	`NUMBER`	Number of times a block in the file was made STALE due to Shared-to-NULL conversions
`RBR`	`NUMBER`	Number of times the instance received a reuse block range cross instance call for this file
`RBR_FORCED_WRITE`	`NUMBER`	Number of blocks written due to reuse block range cross instance calls for this file
`NULL_2_X`	`NUMBER`	Number of lock conversions from NULL-to-Exclusive for all blocks of the specified file
`S_2_X`	`NUMBER`	Number of lock conversions from Shared-to-Exclusive for all blocks of the specified file
`NULL_2_S`	`NUMBER`	Number of lock conversions from NULL-to-Shared for all blocks of the specified file