Oracle8i Reference
Release 2 (8.1.6)

Part Number A76961-01

Library

Product

Contents

Index

Go to previous page Go to beginning of chapter Go to next page

Dynamic Performance (V$) Views, 170 of 179


V$TEMP_PING

The view V$TEMP_PING 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 

FREQUENCY 

NUMBER 

The frequency 

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 

X_2_SSX 

NUMBER 

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

X_2_SSX_FORCED _WRITE 

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 reuse 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 reuse 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 

NULL_2_S 

NUMBER 

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

NULL_2_SS 

NUMBER 

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

OP_2_SS 

NUMBER 

Number of pcm locks ss locks opened. 0 in Oracle 8.1 


Go to previous page Go to beginning of chapter Go to next page
Oracle
Copyright © 1996-2000, Oracle Corporation.

All Rights Reserved.

Library

Product

Contents

Index