RE: Weird database hanging

  • From: Asif Momen <asif_oracle@xxxxxxxxx>
  • To: Jacob.van.Zanen@xxxxxxxxxxxx, greg@xxxxxxxxxxxxxxxxxx, ag@xxxxxxxxxxxx
  • Date: Thu, 25 Oct 2007 12:12:56 -0700 (PDT)

Have a look at 

http://momendba.blogspot.com/2007/06/cursor-pin-s-wait-on-x-wait-event-in.html
and
http://jonathanlewis.wordpress.com/2007/08/20/intelligent-stats/

for the wait event.

"Zanen van, J (Jacob)" <Jacob.van.Zanen@xxxxxxxxxxxx> wrote: I believe there is 
a patch for the cursor: pin S wait on X bug (5907779)


Brgds


jack

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Greg Rahn
Sent: Thursday, 25 October 2007 11:17 AM
To: ag@xxxxxxxxxxxx
Cc: don@xxxxxxxxx; oracle-l@xxxxxxxxxxxxx
Subject: Re: Weird database hanging

I do believe that there have been reports of hangs on "cursor: pin S
wait on X" with 10.2.0.2.  The best way to proceed would be to get a
system state dump and upload it to a SR.  It should be able to be
identified by the trace.  I believe they may be a patch/ARU for it.

On 10/24/07, Alex Gorbachev  wrote:
> Your data from ASH doesn't have anything between 10:44 and 10:53 - it 
> was probably stuck as well.
>
> "os thread startup" is rather strange - problems starting new
processes?
>
> And this is interesting - "cursor: pin S wait on X". Alex Fatkulin is 
> hinting next to me that it *might* be new "cool" mutex that is enabled

> by default in 10.2.0.2. Disable - _kks_use_mutex_pin=false.
>
> There was a discussion on Oracle-L about it.

--
Regards,

Greg Rahn
http://structureddata.org
--
//www.freelists.org/webpage/oracle-l


______________________________________________________________

This email, including any attachments, may be confidential or privileged, and 
is sent for the personal attention of the intended recipient.  If you have 
received this email in error, please delete it immediately.  The views 
expressed are not necessarily those of the Rabobank Group.  The Group is not 
liable for the effects of any virus which may be contained in this email.

If this email contains marketing material and you do not wish to receive such 
material by email in future, please reply to this email and place the words 
"Remove My Details - Electronic Messages" in the Subject Header.

The Rabobank Group

Australia: 1800 025 484
New Zealand: 0800 500 933
______________________________________________________________
--
//www.freelists.org/webpage/oracle-l




 __________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

Other related posts: