<<Previous Next>>
Oracle - Explain how
to view existing locks on the database - April 10, 2009
at 11:00 AM by Amit Satpute
Explain how to view existing locks on the
database.
A number of data locks need to be monitored, in order to maintain
a good performance level for all sessions, along with the time for
which they last.
The current existing data locks are maintained in a Dynamic
Performance View called V$LOCK and the information stored is:
SID
Session ID to identify the session that owns this
lock
TYPE
The type of the lock. E.g.: TM (DML enqueue) and TX (Transaction
enqueue)
LMODE The lock mode
in which the session holds the lock
REQUEST The lock mode
in which the session requests the
lock
CTIME The
time since current lock mode was
granted
BLOCK A value
(0 or 1), whether the lock is the blocker or not
| 
