Re: "cursor: pin S" wait in Batch Run on NON-RAC Database

Yes, I would like to see the list of advisable patches

On Thu, Feb 21, 2008 at 1:04 PM, Roman Podshivalov < roman.podshivalov_at_gmail.com> wrote:

> Then during the run get p1 and p2 for this "cursor: pin S" wait event
> where p1 will have hash value of cursor and top 2 bytes of p2 contains SID
> holding mutex. That might help you to drill down and understand what is
> going on.
>
> --romas
>
>
> On 2/21/08, VIVEK_SHARMA <VIVEK_SHARMA_at_infosys.com> wrote:
> >
> >
> > Thanks Romas
> >
> > YES Patch 5907779 is applied
> >
> > $ opatch lsinventory showing this among Others too:-
> >
> > Patch 5907779 : applied on Tue Jan 01 09:43:05 GMT 2008
> > Created on 11 Apr 2007, 03:03:26 hrs PST8PDT
> > Bugs fixed:
> > 5907779
> >
> > Should anyone need the entire set of Advisable Patches on 10.2.0.3 for
> > RAC & NON-RAC, feel free to ask
> >
> > Cheers
> >
> > Vivek
> >
> > ________________________________
> > From: Roman Podshivalov [roman.podshivalov_at_gmail.com]
> > Sent: Thursday, February 21, 2008 11:43 PM
> > To: VIVEK_SHARMA
> > Cc: oracle-l_at_freelists.org
> > Subject: Re: "cursor: pin S" wait in Batch Run on NON-RAC Database
> >
> > Do you have patch 5907779 installed ?
> >
> > --romas
> >
> >
> > On 2/21/08, VIVEK_SHARMA <VIVEK_SHARMA_at_infosys.com<mailto:
> > VIVEK_SHARMA_at_infosys.com>> wrote:
> >
> > Folks
> >
> > In a Benchmark running 512 concurrent Batch processes High "cursor: pin
> > S" wait is occuring.
> >
> > How is this wait to be approached?
> >
> > Oracle 10.2.0.3<http://10.2.0.3>
> > Solaris 10
> >
> > Cheers & Thanks
> >
> > Vivek
> >
> > P.S.
> >
> > Top 5 Timed
> > Events Avg %Total
> > ~~~~~~~~~~~~~~~~~~
> > wait Call
> > Event Waits Time (s)
> > (ms) Time
> > ----------------------------------------- ------------ -----------
> > ------ ------
> > cursor: pin S 44,042,470
> > 165,067 4 45.5
> > CPU time
> > 159,990 44.1
> > latch: cache buffers
> > chains 170,810 17,573 103 4.8
> > db file parallel write 264,545 15,486
> > 59 4.3
> > cursor: pin S wait on X 25,731 1,293
> > 50 .4
> > -------------------------------------------------------------
> > ^LHost CPU (CPUs: 120)
> > ~~~~~~~~ Load Average
> > Begin End User System Idle WIO
> > WCPU
> > ------- ------- ------- ------- ------- -------
> > --------
> > 2.20 684.53
> > 84.44 14.83 0.73 0.00 286.32
> >
> > **************** CAUTION - Disclaimer *****************
> > This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended
> > solely for the use of the addressee(s). If you are not the intended
> > recipient, please notify the sender by e-mail and delete the original
> > message. Further, you are not to copy, disclose, or distribute this e-mail
> > or its contents to any other person and any such actions are unlawful. This
> > e-mail may contain viruses. Infosys has taken every reasonable precaution to
> > minimize this risk, but is not liable for any damage you may sustain as a
> > result of any virus in this e-mail. You should carry out your own virus
> > checks before opening the e-mail or attachment. Infosys reserves the right
> > to monitor and review the content of all messages sent to or from this
> > e-mail address. Messages sent to or from this e-mail address may be stored
> > on the Infosys e-mail system.
> > ***INFOSYS******** End of Disclaimer ********INFOSYS***
> >
>
>

-- 
Andrew W. Kerber

'If at first you dont succeed, dont take up skydiving.'

--
http://www.freelists.org/webpage/oracle-l