Re: sga
- From: John Kanagaraj <john.kanagaraj@xxxxxxxxx>
- To: kjped1313@xxxxxxxxx
- Date: Fri, 12 Jun 2009 09:54:15 -0700
> cursor_sharing=similar. If this application functions anything like Oracle
> Financials or others that require cursor_sharing to be set to "force" it
Hi Kellyn,
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 **
--
//www.freelists.org/webpage/oracle-l
Other related posts:
