Home » RDBMS Server » Backup & Recovery » ORA-00054: resource busy and acquire with NOWAIT specified
ORA-00054: resource busy and acquire with NOWAIT specified [message #332466] Tue, 08 July 2008 11:01 Go to next message
prashanthgs
Messages: 89
Registered: May 2005
Location: chennai
Member
Hi,

We have a oracle 10g database accessed by many application.

because of error

ORA-00054: resource busy and acquire with NOWAIT specified

no one is able to login to the application.

while checking the lock history, it has more lock in all the table. we manually killed some of the session who locked on these tables.

But still as new session starts again its not going to be a solution.

What are the other ways that we can fix the solution for this error?

DB: ORACLE 10G
OS: Sunsolaris

Pls advice

Thanks and Regards,
Prashanth
Re: ORA-00054: resource busy and acquire with NOWAIT specified [message #332478 is a reply to message #332466] Tue, 08 July 2008 11:32 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
SELECT DECODE(request,0,'Holder: ','Waiter: ')||sid sess, 
id1, id2, lmode, request, type
FROM V$LOCK
WHERE (id1, id2, type) IN
(SELECT id1, id2, type FROM V$LOCK WHERE request>0)
ORDER BY id1, request
/


Does the SQL above return any rows?
Re: ORA-00054: resource busy and acquire with NOWAIT specified [message #332483 is a reply to message #332478] Tue, 08 July 2008 11:44 Go to previous messageGo to next message
prashanthgs
Messages: 89
Registered: May 2005
Location: chennai
Member
Waiter: 487|131105|39115|0|6|TX

Holder: 489|150409|0|6|0|TM

Waiter: 341|150409|0|0|6|TM

Waiter: 526|150409|0|0|6|TM

Holder: 533|151654|0|6|0|TM

Waiter: 426|151654|0|0|6|TM

Waiter: 424|151654|0|0|6|TM


Above are the results.
Re: ORA-00054: resource busy and acquire with NOWAIT specified [message #332487 is a reply to message #332466] Tue, 08 July 2008 11:50 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
You now know which session are the cause of the bottleneck (the holders) & know which objects are being contended for.

You need to decide what is best course of action to eliminate the logjam & execute appropriately.
Re: ORA-00054: resource busy and acquire with NOWAIT specified [message #332488 is a reply to message #332483] Tue, 08 July 2008 11:53 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

Hello prashanthgs,

This is NOT backup related question. You should be read

http://www.orafaq.com/forum/t/88153/0/

ORA-00054: resource busy and acquire with NOWAIT specified


As per Mr.Anacedent, Object busy with some other session. You can re-try your operation later or you can kill blocked session.

Babu


Re: ORA-00054: resource busy and acquire with NOWAIT specified [message #332490 is a reply to message #332487] Tue, 08 July 2008 11:59 Go to previous message
prashanthgs
Messages: 89
Registered: May 2005
Location: chennai
Member
I will kill session id 489, 533 in the db and let you know the updates.

Thanks

Prashanth
Previous Topic: Overriding an RMAn backup set/pieces
Next Topic: How to disable sbt_tape in recovery process
Goto Forum:
  


Current Time: Sat Dec 03 01:22:08 CST 2016

Total time taken to generate the page: 0.07078 seconds