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

FILE_PING

This Oracle Real Application Cluster view displays the number of blocks pinged per datafile. You can use this information to determine access usage of existing datafiles for better settings of GC_FILES_TO_LOCKS.

See Also:

"GC_FILES_TO_LOCKS" and Oracle9i Real Application Clusters Concepts

Column Datatype NULL Description

FILE_ID

NUMBER

NOT NULL

Datafile identifier number (to find the file name, query DBA_DATA_FILES or V$DBFILES)

FILE_NAME

NUMBER

The file name

TS_NAME

VARCHAR2(30)

NOT NULL

Datafile identifier number (to find file name, query DBA_DATA_FILES or V$DBFILES)

FREQUENCY

NUMBER

The ping count

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_WRITES

NUMBER

Number of forced writes that occur for blocks of the specified file due to Exclusive-to-Shared conversions

X_2_SSX

NUMBER

Number of lock conversions from Exclusive-to-Sub Shared Exclusive for all blocks in the file

X_2_SSX_FORCED_WRITES

NUMBER

Number of forced writes that occur for blocks of the specified file due to Exclusive-to-Sub Shared Exclusive 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

SS_2_NULL

NUMBER

Number of lock conversions from Sub Shared-to-NULL for all blocks in the file

WRB

NUMBER

Number of times the instance received a write single buffer cross instance call for this file

WRB_FORCED_WRITE

NUMBER

Number of blocks written due to write single buffer cross instance calls for this file

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 resuse block range cross instance calls for this file

RBR_FORCED_STALE

NUMBER

Number of times a block in this file was made STALE due to resuse block range cross instance calls

CBR

NUMBER

Number of times the instance received a checkpoint block range cross instance call for this file

CBR_FORCED_WRITE

NUMBER

Number of blocks in this file which were written due to checkpoint cross range cross instance calls

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

SSX_2_X

NUMBER

Number of lock conversions from Sub Shared Exclusive-to-Exclusive for all blocks of the specified file

N_2_S

NUMBER

Number of lock conversions from NULL-to-Shared for all blocks of the specified file

N_2_SS

NUMBER

Number of lock conversions from NULL-to-Sub Shared for all blocks of the specified file