Oracle8i Reference
Release 2 (8.1.6)

A76961-01

Library

Product

Contents

Index

Prev Up Next

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 


Prev Up Next
Oracle
Copyright © 1999 Oracle Corporation.

All Rights Reserved.

Library

Product

Contents

Index