Locks

From: Ravindra Basavaraja <ravindra_at_sentica.com>
Date: Thu, 21 Jun 2001 13:40:14 -0700
Message-ID: <F001.00332B2A.20010621133600@fatcity.com>

Does anyone have any script that will help me find out the locks that are held in the database.

We are facing a problem related to lock.One of the transaction is holding a lock on a table and
there is another transaction wanting a lock on that table but waits for long time .Is there
any lock timeout parameter that can be set on the database.

Thanks
Ravindra

--

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

Author: Ravindra Basavaraja
  INET: ravindra_at_sentica.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Jun 21 2001 - 15:40:14 CDT