Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
|
|
View PDF |
This view lists the locks currently held by the Oracle Database and outstanding requests for a lock or latch.
Column | Datatype | Description |
---|---|---|
ADDR |
RAW(4 | 8) |
Address of lock state object |
KADDR |
RAW(4 | 8) |
Address of lock |
SID |
NUMBER |
Identifier for session holding or acquiring the lock |
TYPE |
VARCHAR2(2) |
Type of user or system lock
The locks on the user types are obtained by user applications. Any process that is blocking others is likely to be holding one of these locks. The user type locks are:
The locks on the system types are held for extremely short periods of time. The system type locks are listed in Table 6-1. |
ID1 |
NUMBER |
Lock identifier #1 (depends on type) |
ID2 |
NUMBER |
Lock identifier #2 (depends on type) |
LMODE |
NUMBER |
Lock mode in which the session holds the lock:
|
REQUEST |
NUMBER |
Lock mode in which the process requests the lock:
|
CTIME |
NUMBER |
Time since current mode was granted |
BLOCK |
NUMBER |
A value of either 0 or 1, depending on whether or not the lock in question is the blocker. |
Table 6-1 Values for the TYPE Column: System Types
System Type | Description | System Type | Description |
---|---|---|---|
|
Buffer hash table instance |
|
Library cache pin instance ( |
|
Control file schema global enqueue |
|
Password File |
|
Cross-instance function invocation instance |
|
Parallel operation |
|
Cursor bind |
|
Process startup |
|
datafile instance |
|
Row cache instance ( |
|
Direct loader parallel index create |
|
Redo thread global enqueue |
|
Mount/startup db primary/secondary instance |
|
System change number instance |
|
Distributed recovery process |
|
SMON |
|
Distributed transaction entry |
|
Sequence number instance |
|
File set |
|
Sequence number enqueue |
|
Space management operations on a specific segment |
|
Sort segment |
|
Instance number |
|
Space transaction enqueue |
|
Instance recovery serialization global enqueue |
|
Sequence number value |
|
Instance state |
|
Generic enqueue |
|
Library cache invalidation instance |
|
Temporary segment enqueue (ID2=0) |
|
Job queue |
|
New block allocation enqueue (ID2=1) |
|
Thread kick |
|
Temporary table enqueue |
|
Library cache lock instance lock (A..P = namespace) |
|
User name |
|
Mount definition global enqueue |
|
Undo segment DDL |
|
Media recovery |
|
Being-written redo log instance |