Skip Headers

Oracle9i Database Reference
Release 2 (9.2)

Part Number A96536-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page Go to next page
View PDF

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