Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: resource busy question
Iancrozier <iancrozier_at_aol.com> wrote in message
news:19991123113529.08842.00001490_at_ng-xa1.aol.com...
> I'm trying to alter a table. I get the following message:
> ORA-0054: resource busy and acquire with NOWAIT specified.
>
> How can I find out who or which process is accessing this table so I can free
> it up?
Query the V$LOCK (or V$LOCKED_OBJECT) and DBA/ALL_OBJECTS views. Received on Thu Nov 25 1999 - 09:48:09 CST