table locked from n minutes

From: Kommareddy, Srinivas (MED, Wissen Infotech) <Srinivas.Kommareddy_at_med.ge.com>
Date: Thu, 1 Apr 2004 22:40:29 -0600
Message-ID: <1C9727B12F498543A43CBB988F30515C02F3AFDC@uswaumsx14medge.med.ge.com>

Hi All,  

Is there a way to know that a table has been locked for n minutes ?  

( Because a session may lock it and release it several times (depending up on the code). )  

We have a requirement to kill a session if it locks a table for n minutes.  

Can somebody through somelight on this ?  

Thanks and Regards,
Srinivas

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--

Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html

---

Received on Thu Apr 01 2004 - 22:37:02 CST