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


V$GLOBAL_BLOCKED_LOCKS

This view displays global blocked locks.

Column  Datatype  Description 

ADDR 

RAW(4) 

Address of lock state object (raw) 

KADDR 

RAW(4) 

Address of lock (raw) 

SID 

NUMBER 

Identifier of session holding the lock (number) 

TYPE 

VARCHAR2(2) 

Resource type (char) 

ID1 

NUMBER 

Resource identifier #1 (number) 

ID2 

NUMBER 

Resource identifier #2 (number) 

LMODE 

NUMBER 

Lock mode held (number) 

REQUEST 

NUMBER 

Lock mode requested (number) 

CTIME 

NUMBER 

Time since current mode was granted 


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