Re: deadlock problem

Him, you say 'instance hang' !
can you define 'instance hang' clearly for me? i review Metalink Note:285270.1 'The Performance Impact of Deadlock Detection' but i don`t understand it clearly. is it possible that my problem is 'Performance Impact' or it is 'Instance Hang'?

thank you.

bdbafh wrote:
> 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 Thu Nov 23 2006 - 01:22:21 CST