Home » SQL & PL/SQL » SQL & PL/SQL » ORA-00054: resource busy and acquire with NOWAIT specified indexe creation (Solaris 5.8 oracle 10.2.0.2)
ORA-00054: resource busy and acquire with NOWAIT specified indexe creation [message #334682] Thu, 17 July 2008 12:11 Go to next message
evoradba
Messages: 104
Registered: April 2005
Location: Canada
Senior Member


Hello

Sometimes while creating a index we get ORA-00054: resource busy and acquire with NOWAIT specified, but no one is logged into the database at all i did some search on oracle metalink and i only found issues with the ora-00054 for update statistics,
How can i create indexes without having this error message?

any help would be appreciated
Thank you
Maria
Re: ORA-00054: resource busy and acquire with NOWAIT specified indexe creation [message #334683 is a reply to message #334682] Thu, 17 July 2008 12:19 Go to previous messageGo to next message
BlackSwan
Messages: 25039
Registered: January 2009
Location: SoCal
Senior Member
evoradba wrote on Thu, 17 July 2008 10:11


Hello

Sometimes while creating a index we get ORA-00054: resource busy and acquire with NOWAIT specified, but no one is logged into the database at all i did some search on oracle metalink and i only found issues with the ora-00054 for update statistics,
How can i create indexes without having this error message?

any help would be appreciated
Thank you
Maria


I believe that Oracle accurately reports reality.
Some session is accessing some object!
Re: ORA-00054: resource busy and acquire with NOWAIT specified indexe creation [message #334684 is a reply to message #334682] Thu, 17 July 2008 12:28 Go to previous messageGo to next message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Maybe Oracle itself is accessing the table as it gathers statistics.
Just retry the creation.

Regards
Michel
Re: ORA-00054: resource busy and acquire with NOWAIT specified indexe creation [message #334695 is a reply to message #334682] Thu, 17 July 2008 13:15 Go to previous messageGo to next message
joy_division
Messages: 4640
Registered: February 2005
Location: East Coast USA
Senior Member
Did you check v$session?
Re: ORA-00054: resource busy and acquire with NOWAIT specified indexe creation [message #334697 is a reply to message #334682] Thu, 17 July 2008 13:22 Go to previous messageGo to next message
evoradba
Messages: 104
Registered: April 2005
Location: Canada
Senior Member
yes i did check v$session, no one is logged in, its a very large table about 35GB in size and the index creation does not abort all the time maybe once per month or longer
Re: ORA-00054: resource busy and acquire with NOWAIT specified indexe creation [message #334713 is a reply to message #334697] Thu, 17 July 2008 14:01 Go to previous message
Michel Cadot
Messages: 64111
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Why do you create an index more than once?

Regards
Michel
Previous Topic: PLSQL procedure to split Partition table
Next Topic: Procedure not compiled successfully. But shows no error
Goto Forum:
  


Current Time: Mon Dec 05 15:21:54 CST 2016

Total time taken to generate the page: 0.09873 seconds