RE: Weird database hanging

I believe there is a patch for the cursor: pin S wait on X bug (5907779)

Brgds

jack

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Greg Rahn Sent: Thursday, 25 October 2007 11:17 AM To: ag_at_oracloid.com
Cc: don_at_seiler.us; oracle-l_at_freelists.org 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 <ag_at_oracloid.com> 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
--
http://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
______________________________________________________________
--
http://www.freelists.org/webpage/oracle-l