Re: Memory Limit Imposed on Oracle by Windows?

On Apr 19, 3:07 pm, Mladen Gogala <mgogala.SPAM-ME...._at_verizon.net> wrote:
> On Wed, 18 Apr 2007 23:25:33 +0000, Dereck L. Dietz wrote:
> > Basically he was told that Windows 2003 places a maximum limit of memory
> > that Oracle can use. For example, if we have 8 GB of RAM the upper
> > limit could be 4GB or so. Is that true or is Oracle able to use as much
> > of the available memory on the server as it is set up to use?
>
> On the 64-bit windows, Oracle is able to use 64-bit address set.
> On 32-bit windows, it's 32 bit address set. Anyway, I don't see why would
> anyone need more then 640K of memory?
>
> --http://www.mladen-gogala.com

I have seen manu threads in this forum where people advise you not to use too much memory, but what is too much memory depends of appliation. I have worked on a project where db_bffer_cacahe started with 256M, then increase to 512M, then then to 1024M. However, DBA's relucant to increase more than 1GB. Our disk i/o was always above 80%.

Our UNIX server had lots of memory and thanks to Oracle 9i 64 bit Oracle, we are not limted to 2GB. address space. We increased db_buffer_cacahe to 8GB (yes 8GB) and it made all the difference. Our disk i/o readuced to less than 20% and preformance improved dramatically. Thank god for 64 bit Oracle.

One should, of course, use memory wisely, but making good use of large amount of memory can help the performance as well. Received on Thu Apr 19 2007 - 19:16:00 CDT