Re: Exclusive Table Locks

In article <44qr32$hac_at_news.uni-c.dk>, dbvision_at_inet.uni-c.dk wrote:

> > Eric Sundby <eric.sundby_at_medaphis.com> writes:
> > I have run into a situation where an application running on Oracle
> > 7.1.4.1 seems to like to do full table locks as opposed to row level
> > locking. Sometimes the locks do not get released correctly and I get
> > whole departments hanging on that one locked table.
> >
> > Does anyone have an efficient way of identifying locks that are causing
> > havoc on a system?
> >
> > Any help would be appreciated.
> >
> > -Eric Sundby-
> > eric.sundby_at_medaphis.com
> >
> >
> >>>>
>
> There's a tool from Bradmark ...

Or you could simply run the script calle $ORACLE_HOME/rdbms/admin/utllockt.sql from within SQL*DBA, while connected as internal. This script will build a lock tree of the processes holding locks and the processes that are waiting for those locks. The script itself has quite useful comments that explain the output.

• Kevin J

-- 
~~~~~~~~~~~~ emergent: delivering scalable solutions ~~~~~~~~~~~~~~~
kevin jernigan                                      415-567-8915 (p)
emergent corporation                                415-265-0785 (c)
kjerniga_at_emergent.com   http://www.emergent.com     415-367-6414 (f)