Date: Fri, 12 Jun 2009 13:59:43 -0700 (PDT)
John- Thank you for correcting my typo! I meant to say cursor_sharing must be set to EXACT not similar or force for Oracle E-business Suite/Oracle Financials. Yes, you are correct...
- On Fri, 6/12/09, John Kanagaraj <john.kanagaraj_at_gmail.com> wrote:
From: John Kanagaraj <john.kanagaraj_at_gmail.com>
Subject: Re: sga
Cc: "Andrew Kerber" <andrew.kerber_at_gmail.com>, "Mathias Magnusson" <mathias.magnusson_at_gmail.com>, Brian.Zelli_at_roswellpark.org, "oracle-l_at_freelists.org" <oracle-l_at_freelists.org> Date: Friday, June 12, 2009, 10:54 AM
> cursor_sharing=similar. If this application functions anything like Oracle
> Financials or others that require cursor_sharing to be set to "force" it
If by "Oracle Financials", you mean Oracle E-Business Suite, then there are a strict set of parameters that cannot be changed, and CURSOR_SHARING should be set to EXACT in EBS. Is this 11i or R12? I believe even for the older versions (10.7 and below) CS needed to be set to EXACT.
Brian et al,
There was a very interesting paper on Shared pool internals written by Russell Green and others for OOW 2005 that answers these questoins. I don't have it currently but am sure google will find that for you.
In this particular case, the best thing to do is to pin what you can and let the other crap cycle in and out of the shared pool.
-- John Kanagaraj <>< http://www.linkedin.com/in/johnkanagaraj http://jkanagaraj.wordpress.com (Sorry - not an Oracle blog!) ** The opinions and facts contained in this message are entirely mine and do not reflect those of my employer or customers ** -- http://www.freelists.org/webpage/oracle-lReceived on Fri Jun 12 2009 - 15:59:43 CDT