Kbase P76939: How do I monitor Oracle locks in Oracle 8i and Oracle 9i?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
23/11/2004 |
|
Status: Verified
GOAL:
How do I monitor Oracle locks in Oracle 8i and Oracle 9i?
GOAL:
What Oracle views can be queried to obtain lock information?
FACT(s) (Environment):
Oracle 8.x
Oracle 9i
FIX:
Oracle's V$locked_object view can be queried to obtain lock information. Following query will return locked object name, user name, and lock mode
select a.object_name, b.oracle_username, b.locked_mode
from
dba_objects a, v$locked_object b where b.object_id=a.object_id
following is information of v$locked_object
Column Datatype Description
XIDUSN NUMBER Undo segment number
XIDSLOT NUMBER Slot number
XIDSQN NUMBER Sequence number
OBJECT_ID NUMBER Object ID being locked
SESSION_ID NUMBER Session ID
ORACLE_USERNAME VARCHAR2(30) Oracle user name
OS_USER_NAME VARCHAR2(15) OS user name
PROCESS VARCHAR2(9) OS process ID
LOCKED_MODE NUMBER lock mode