Re: unlocking tables

From: Paul Brewer <paul_at_paul.brewers.org.uk>
Date: Wed, 13 Feb 2002 21:32:19 -0000
Message-ID: <3c6aeded_1@mk-nntp-1.news.uk.worldonline.com>

Run catblock.sql, then look at dba_waiters and dba_blockers...

Most of the time you shouldn't need to worry about these issues, IMHO. If you do then either you're letting developers make DDL changes while DML is being run, or you've a poorly designed system.

Too simplistic, maybe. I expext to get flamed for this...

Paul

"Cameron Abbott" <cvabbott_at_altavista.com> wrote in message news:a4e0u7$jm9$1_at_bcarh8ab.ca.nortel.com...
> Hi,
>
> Does anyone know of an sql statement that will find a locked table and the
> sql statement causing the lock? Also, what is the command to unlock the
> table.
>
> Thanks
> Cameron
>
>
Received on Wed Feb 13 2002 - 15:32:19 CST