| ORA-00054: resource busy and acquire with NOWAIT specified [message #332466] |
Tue, 08 July 2008 11:01  |
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  |
 |
BlackSwan
Messages: 26766
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?
|
|
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
