Oracle9i Database Reference
Release 1 (9.0.1)

Part Number A90190-02
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback

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

Static Data Dictionary Views, 200 of 521


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

See Also: 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-2001, Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback