One of our applications always go down on Thursday night. I checked
the locks on the database side and got a lock in a key table by using
following sql. What really does locked_mode 2 do? Is it possible to
trace the statement that locks the table?
Thanks a lot.
SQL> select v.object_id, t.object_name,
2 v.session_id, v.oracle_username,
3 v.os_user_name, v.locked_mode
4 from v$locked_object v, dba_objects T
5 where v.object_id = t.object_id;
OBJECT_ID OBJECT_NAME SESSION_ID ORACLE_USERNAME LOCKED_MODE
193935 F91300 37 JDE 2
Received on Fri Nov 14 2003 - 10:34:38 CST
