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,
http://www.jlcomp.demon.co.uk/faq/locked_rows.html

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....

--
regards
ujang
--
http://www.freelists.org/webpage/oracle-l

Follow-Ups:

RE: dml that made locking
From: Tony Aponte

RE: dml that made locking
From: M Rafiq

dml that made locking

Other related posts: