dml that made locking

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


Other related posts: