Re: FW: Massive Wait Events "Cursor: pin S wait on X" with PL/SQL in

From: Martin Klier <>
Date: Fri, 07 May 2010 14:36:44 +0200
Message-ID: <>

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

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
>> =()),(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

Received on Fri May 07 2010 - 07:36:44 CDT

Original text of this message