Re: "cursor: pin S" wait in Batch Run on NON-RAC Database
- From: "Roman Podshivalov" <roman.podshivalov@xxxxxxxxx>
- To: VIVEK_SHARMA <VIVEK_SHARMA@xxxxxxxxxxx>
- Date: Thu, 21 Feb 2008 14:04:15 -0500
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@xxxxxxxxxxx> 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@xxxxxxxxx]
> Sent: Thursday, February 21, 2008 11:43 PM
> To: VIVEK_SHARMA
> Cc: oracle-l@xxxxxxxxxxxxx
> 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@xxxxxxxxxxx<mailto:
> VIVEK_SHARMA@xxxxxxxxxxx>> 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***
>
Other related posts:
