dml that made locking

From: Ujang Jaenudin <ujang.jaenudin_at_gmail.com>
Date: Fri, 30 Mar 2007 11:09:36 +0700
Message-ID: <3edcb66e0703292109y56a0c8cbvaefbd05749e19c00@mail.gmail.com>

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 Received on Thu Mar 29 2007 - 23:09:36 CDT