| Oracle8i Reference Release 2 (8.1.6) Part Number A76961-01  | 
  | 
Static Data Dictionary Views, 172 of 452
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 holding or acquiring the lock  | 
| 
 
  | 
 
  | 
 
  | 
 Lock type. For a listing of lock types, see Appendix B, "Oracle Enqueue Names".  | 
| 
 
  | 
 
  | 
 
  | 
 Lock mode  | 
| 
 
  | 
 
  | 
 
  | 
 Lock mode requested  | 
| 
 
  | 
 
  | 
 
  | 
 Type-specific lock identifier, part 1  | 
| 
 
  | 
 
  | 
 
  | 
 Type-specific lock identifier, part 2  | 
| 
 
  | 
 
  | 
 
  | 
 The last convert  | 
| 
 
  | 
 
  | 
 
  | 
 Whether the lock is currently blocking others  | 
| 
 | 
![]() Copyright © 1996-2000, Oracle Corporation. All Rights Reserved.  | 
 
  |