Hi, Oracle can detect deadlock, sure there is a way. I only can share with you like this you try look in these views v$locked_object v$lock v$session v$sqlarea these are dynamic, they come and go, you can write trigger store the = info once the lock occur, this trigger take note if locking occur and check 10 minutes later = (assume you don't want people lock your table more than 10 mins), for = this technique sysdate is very helpful. Sinardy -----Original Message----- From: Kommareddy, Srinivas (MED, Wissen Infotech) [mailto:Srinivas.Kommareddy@xxxxxxxxxx] Sent: 02 April 2004 12:40 To: ORACLE-L@xxxxxxxxxxxxx Subject: table locked from n minutes Hi All, =20 Is there a way to know that a table has been locked for n minutes ? =20 ( Because a session may lock it and release it several times (depending up on the code). ) =20 We have a requirement to kill a session if it locks a table for n minutes. =20 Can somebody through somelight on this ? =20 Thanks and Regards, Srinivas ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------