Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: locks?

Re: locks?

From: Ron Rogers <RROGERS_at_galottery.org>
Date: Thu, 03 Aug 2000 10:32:39 -0400
Message-Id: <10578.113727@fatcity.com>


swapna,
Oracle has a query available called ORACLE_HOME/rdbms/admin/utllockt.sql = that will assist you in determining what and who are holding locks and = what and who are waiting for them to release. Be sure to rof the catblock.s= ql script first if you have not done so in the past. Ron Rogers
DBA OCP
Atl.GA

>>> Swapna_P_at_satyam.com 08/03/00 09:18AM >>>
how can i find out the locks existing on a table and by whom? rgds
swapna Received on Thu Aug 03 2000 - 09:32:39 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US