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, 82 of 179


V$LOCK_ELEMENT

This is an Oracle Parallel Server view. There is one entry in V$LOCK_ELEMENT for each PCM lock that is used by the buffer cache. The name of the PCM lock that corresponds to a lock element is {'BL', indx, class}.

See Also:

Oracle8i Parallel Server Concepts

Column  Datatype  Description 

LOCK_ELEMENT_ ADDR 

RAW(4) 

The address of the lock element that contains the PCM lock that is covering the buffer. If more than one buffer has the same address, then these buffers are covered by the same PCM lock.  

LOCK_ELEMENT_NAME 

NUMBER 

The name of the lock that contains the PCM lock that is covering the buffer. 

INDX 

NUMBER 

Platform specific lock manager identifier 

CLASS 

NUMBER 

Platform specific lock manager identifier 

MODE_HELD 

NUMBER 

Platform dependent value for lock mode held; often: 3 = share; 5 = exclusive 

BLOCK_COUNT 

NUMBER 

Number of blocks covered by PCM lock 

RELEASING 

NUMBER 

Non-zero if PCM lock is being downgraded 

ACQUIRING 

NUMBER 

Non-zero if PCM lock is being upgraded 

INVALID 

NUMBER 

Non-zero if PCM lock is invalid. (A lock may become invalid after a system failure.) 

FLAGS 

NUMBER 

Process level flags for the LE 


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