-
deadlock dectected
Hi Friends,
I found this error in our database alert logs:
deadlock detected, reached max # (20) of servers
found dead shared server 'S009', pid = (27, 238)
how do I resolve this pls, do I need to encrease a deadlock parameter on
the init.ora?
Thanks a lot
Behind The Success And Failure Of A Man Is A Woman
-
No, you don't.
Look at the trace file, most likely caused by poorly designed / poorly coded application.
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
-
Look for in your trace file. Usually appears in child table when updating parent table due to a non indexes fk.
-
Thanks a lot huns....it's really hard to tune this apps becoz its a 3rd party and everytime we call their support we have to pay by the hour minimum of 2 hrs including travel time
Behind The Success And Failure Of A Man Is A Woman
-
Can you post init.ora parameters?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|