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