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

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)



-----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  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
> 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 Disable - _kks_use_mutex_pin=false.
> There was a discussion on Oracle-L about it.


Greg Rahn


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

Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 

Other related posts: