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> 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
> 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***
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

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