Yes, I would like to see the list of advisable patches On Thu, Feb 21, 2008 at 1:04 PM, Roman Podshivalov < roman.podshivalov@xxxxxxxxx> 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@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*** > > > > -- Andrew W. Kerber 'If at first you dont succeed, dont take up skydiving.'