Re: deadlock problem

h.jalalipoor_at_gmail.com wrote:
> I have oracle 9.2.0.3 on HP9000 PA-RISC 64Bit (12GB RAM and 6 CPU).
> database size is about 100GB and active users is about 200 user.
> when a deadlock detected, my database hang for a few minutes, no body
> can`t do any thing even dba. I want to connect as sysdba from SQL*Plus
> but i can`t and SQL*Plus wait until deadlock detection resolved by
> oracle.
> my question is what happen on database when a deadlock detected? is it
> a bug or it is normal?
>
> best regards.

That does not sound like a "deadlock".
That sounds like an instance hang.
Any reason that you are running a base release of the database server software and not a recent patchset along with a one-off patch including the latest quarterly critical patch update (security fixes)?

Search for Stephan Haisley's paper on "Help - I think my database is hung" that shows how to use hang analyze and produce system state dumps.

You can find it here, I believe:
http://www.rmoug.org/TD2005_Pres_Sum.htm#Haisley

Or open a service request with Oracle Support. I'm guessing that they are going to ask you why you are running a base release of the database server software and not a recent patchset along with a one-off patch including the latest quarterly critical patch update.

-bdbafh Received on Wed Nov 22 2006 - 12:31:49 CST