Re: FW: Massive Wait Events "Cursor: pin S wait on X" with PL/SQL in 11.1.0.7
- From: Martin Klier <usn@xxxxxxxxx>
- To: "Powell, Mark" <mark.powell2@xxxxxx>
- Date: Fri, 07 May 2010 14:36:44 +0200
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
