| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: ORA-00054
Claudia,
run this query .. the output will tell you who is locking and what type that statement is.. if that transaction which has locked this table is no longer useful, then kill that session. however, the rollback will still take place in case a lot of rows were affected and you will have to wait till oracle completes the cleanup
hth
deepAk
set linesize 200
set pagesize 40
col object_name format a25 col object_id format 999999 heading 'OBJ|ID' col locked_mode format 999 heading 'OBJ|LCK'col lmode format 999 heading 'SES|LCK'
decode(c.lmode,0,'None',1,'Null',2,'Row-S',3,'Row-X',4,'Share',5,'S/Row-X',6 ,'Exclusive') Descrip,
d.sid,d.serial#,d.status, c.ctime,decode(c.block,0,'No',1,'Yes')
Blk,c.type
from v$locked_object a, dba_objects b, v$lock c, v$session d
where a.object_id=b.object_id and c.sid=a.session_id and c.sid=d.sid
-----Original Message-----
From: Rivera, Claudia [mailto:crivera_at_utep.edu]
Sent: Tuesday, August 01, 2000 1:54 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: ORA-00054
but no-one is using it?
I have even checked in the server processes and I see no one using it.
-----Original Message-----
Sent: Tuesday, August 01, 2000 12:36 PM
To: Multiple recipients of list ORACLE-L
It means that someone else is accessing the table and the table and you will
have to try again when noone is using it. Ruth
----- Original Message -----
To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
Sent: Tuesday, August 01, 2000 11:05 AM
> I need to erase some rows from a table. But when I try to do it, nothing
> happens.
> The system just hangs in there until I press Ctrl C to stop it.
>
> Now, I tried to drop the table, and it gave me the following error:
>
> ORA -00054 Resource busy and acquire with NOWAIT specified.
>
> What does this mean??
>
> This is the only table with this type of problem.
>
> Everything else works fine.
>
> TIA
>
> --------------Claudia Rivera-----------------
> The University of Texas at El Paso
> Tech. Media Coordinator
> crivera_at_utep.edu
> http://dmc.utep.edu
>
>
> --
> Author: Rivera, Claudia
> INET: crivera_at_utep.edu
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
-- Author: Ruth Gramolini INET: rgramolini_at_tax.state.vt.us Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Author: Rivera, Claudia INET: crivera_at_utep.edu Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You mayReceived on Tue Aug 01 2000 - 15:48:02 CDT
 |
 |