Sorry, i think i must correct my previous message.
I review metalink note : 285270.1 "The Performance Impact of Deadlock
Detection". i don`t understand it clearly. is it possible that my
problem is 'Performance Impact' or it is 'Instance Hang'? can you
please explain me what is "Instance Hang"?
Thank bdbafh.
h.jalalipoor_at_gmail.com wrote:
> 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 Sat Nov 25 2006 - 03:58:26 CST
