Re: More Memory the better ...Why not

From: Tanel Poder <change_to_my_first_name_at_integrid.info>
Date: Fri, 22 Aug 2003 17:19:44 +0300
Message-ID: <3f462681$1_1@news.estpak.ee>

Hi!

More memory means more CPU resources for managing this memory. Also, if you meant that if your server does have 4GB of mem, why not make a SGA 4GB in size, the reason is that there is operating system stuff which requires memory, oracle processes and if you are running on standard cooked file systems then OS tends to keep certain amount of memory for file system caching, even if you have only RDBMS running there. The OS doesn't know that caching is already done in application (in this case Oracle Server) level.

Even if money isn't a constraint, at certain point you will benefit 0% in performance when adding 100% of memory.

Tanel.

"Vincento Harris" <wumutek_at_yahoo.com> wrote in message news:2fa13ee7.0308220441.1f113634_at_posting.google.com...
> 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
Received on Fri Aug 22 2003 - 09:19:44 CDT