Re: Weird database hanging

  • From: "Don Seiler" <don@xxxxxxxxx>
  • To: "Asif Momen" <asif_oracle@xxxxxxxxx>
  • Date: Thu, 25 Oct 2007 15:09:40 -0500

A lot of the bugs on metalink are regarding an issue that they say
wasn't introduced until 10.2.0.3, which we haven't had the pleasure of
upgrading to yet.

However one of the commenters in Lewis' blog pointed me to
Bug:5653007; 5485914: SELF DEADLOCK PROCESS WAITS ON ''Cursor: Pin S
Wait On X''.  I'll need to look at our dump/trace to see if we match
what they list in the bug.

We've been on 10.2.0.2 for a while (over a year), but this problem
didn't show up until ~10 days after we migrated to a 64-bit box (via
datapump exp/imp).  Thoughts?

Thanks everyone for your help so far!

Don.

On 10/25/07, Asif Momen <asif_oracle@xxxxxxxxx> wrote:
> 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


-- 
Don Seiler
oracle: http://ora.seiler.us
ultimate: http://www.mufc.us
--
//www.freelists.org/webpage/oracle-l


Other related posts: