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

From: VIVEK_SHARMA <VIVEK_SHARMA_at_infosys.com>
Date: Fri, 22 Feb 2008 00:10:14 +0530
Message-ID: <69E1360E54B50C4A828A136C158E4742036A7077AF@BLRKECMBX02.ad.infosys.com>

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***
--

http://www.freelists.org/webpage/oracle-l Received on Thu Feb 21 2008 - 12:40:14 CST