Forum Stats

  • 3,769,562 Users
  • 2,252,976 Discussions
  • 7,875,087 Comments

Discussions

ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired

User_KWXZ9
User_KWXZ9 Member Posts: 232 Blue Ribbon
edited Jun 20, 2013 9:14AM in General Database Discussions

Hi All ,

I am using oracle 11.2.0.3 with 3 node rac with ODI .

I have the below table which i am not able to drop  and giving the error .

SQL> drop table I$_CDS_FAULT_DEV1;

drop table I$_CDS_FAULT_DEV1

           *

ERROR at line 1:

ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired

SQL> show parameter ddl_lock

NAME                                 TYPE        VALUE

------------------------------------ ----------- ------------------------------

ddl_lock_timeout                     integer     300

i changed to 100 but still the same error also i have checked and there are no locks . Can you please provide me a way to resolve this issue .

Regards ,

DBApps

User_KWXZ9

Best Answer

  • Unknown
    Accepted Answer

    For sure there are locks, as the table is in use.

    Drop table wants an exclusive lock on the corresponding dictionary record(s).

    Whenever the table is in use there will be a row-share lock on that record in the dictionary.

    Did you consult gv$access ?

    Please do so now.

    -------------

    Sybrand Bakker

    Senior Oracle DBA

    User_KWXZ9

Answers

This discussion has been closed.