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

Static Data Dictionary Views, 172 of 452


DBA_LOCKS

DBA_LOCKS lists all locks or latches held in the database, and all outstanding requests for a lock or latch.

Column  Datatype  NULL  Description 

SESSION_ID 

NUMBER 

 

Session holding or acquiring the lock 

LOCK_TYPE 

VARCHAR2(26) 

 

Lock type. For a listing of lock types, see Appendix B, "Oracle Enqueue Names"

MODE HELD 

VARCHAR2(40) 

 

Lock mode 

MODE REQUESTED 

VARCHAR2(40) 

 

Lock mode requested 

LOCK_ID1 

VARCHAR2(40) 

 

Type-specific lock identifier, part 1 

LOCK_ID2 

VARCHAR2(40) 

 

Type-specific lock identifier, part 2 

LAST_CONVERT 

NUMBER 

 

The last convert 

BLOCKING_OTHERS 

VARCHAR2(40) 

 

Whether the lock is currently blocking others 


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