Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: locks?
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