Re: More Memory the better ...Why not

I seem to recall that allocating too much memory to the Shared Pool can actually lead to performance problems. The Shared Pool can create a very large cache for holding SQL statements. It can take a long time to check just to see if the SQL statement has been previously parsed. A smaller Shared Pool actually helped performance in that case (I don't remember which version of Oracle this was off the top of my head).

HTH,
Brian

Vincento Harris wrote:
>
> It is my understanding that there are limits as to how much memory
> different versions of an RDBMS can handle , that apart ,why would
> you not want to allocate as much memory
> as possible if available?
>
> Your expert responses are appreciated
> Vince

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"