Re: FW: Massive Wait Events "Cursor: pin S wait on X" with PL/SQL in 11.1.0.7
From: Martin Klier <usn_at_usn-it.de>
Date: Fri, 07 May 2010 14:36:44 +0200
Message-ID: <4BE4095C.6010308_at_usn-it.de>
Hi Mark,
>> Do you use automatic memory management? If so, here is one possibility:
>>
>> High waits for 'Cursor: Pin S Wait On X' & 'Library Cache Load Locks'
>> with auto memory mgmt #731233.1
>>
>> https://support.oracle.com/CSP/ui/flash.html#tab=KBHome(page=KBHome&id
>> =()),(page=KBNavigator&id=(bmDocType=PROBLEM&bmDocID=402027.1&viewingM
>> ode=1143&from=BOOKMARK&bmDocTitle=Bug:5653007;%205485914:%20%20SELF%20
>> DEADLOCK%20PROCESS%20WAITS%20ON%20''Cursor:%20Pin%20S%20Wait%20On%20X'
>> '&bmDocDsrc=KB))
Date: Fri, 07 May 2010 14:36:44 +0200
Message-ID: <4BE4095C.6010308_at_usn-it.de>
Hi Mark,
my memory parameters are set that way:
NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ lock_sga boolean TRUE pre_page_sga boolean TRUE sga_max_size big integer 1200M sga_target big integer 1200M memory_max_target big integer 0 memory_target big integer 0 pga_aggregate_target big integer 300M
Any suggestions? Maybe setting memory*target and skip fixing SGA/PGA? With a delay of some hours, I am free to change them within the physical limits.
Thank you
Martin
Powell, Mark schrieb:
> > That sounds like this issue. The key being what kind of memory management you are using. There were several other similar reports that might also be worth reviewing. >
>> Do you use automatic memory management? If so, here is one possibility:
>>
>> High waits for 'Cursor: Pin S Wait On X' & 'Library Cache Load Locks'
>> with auto memory mgmt #731233.1
>>
>> https://support.oracle.com/CSP/ui/flash.html#tab=KBHome(page=KBHome&id
>> =()),(page=KBNavigator&id=(bmDocType=PROBLEM&bmDocID=402027.1&viewingM
>> ode=1143&from=BOOKMARK&bmDocTitle=Bug:5653007;%205485914:%20%20SELF%20
>> DEADLOCK%20PROCESS%20WAITS%20ON%20''Cursor:%20Pin%20S%20Wait%20On%20X'
>> '&bmDocDsrc=KB))
-- Usn's IT Blog for Linux, Oracle, Asterisk http://www.usn-it.de -- http://www.freelists.org/webpage/oracle-lReceived on Fri May 07 2010 - 07:36:44 CDT