dml that made locking

  • From: "Ujang Jaenudin" <ujang.jaenudin@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Fri, 30 Mar 2007 11:09:36 +0700

dear all,

i have read jk still article about locking,

and now i tried to develop a script to auto kill which lock that have
been retained in system for 15 mins, but i need the information about
who is locking (sid,serial) and dml syntax that made locking.

i tried use prev_has_value in v$session and find the sql_text in the
v$sql, but i think the lock holder might query another.....

pls help....


Other related posts: