Re: Effect of lack of memory

From: Rick Denoire <100.17706_at_germanynet.de>
Date: Sat, 11 Jan 2003 01:30:21 +0100
Message-ID: <orou1v4v27oe6h14v6107tvifdlq0gl01n@4ax.com>

Sybrand Bakker <gooiditweg_at_nospam.demon.nl> wrote:

>
>You shouldn't have tuned the ;production database to the amount of
>available RAM in the first place, the Oracle guidelines are quite
>clear about that.

Sorry, I did not express myself correctly. The DB is only using 53% of the available physical RAM and so it is really tuned. I did not mean that it actually consumes all available RAM. There are other applications running on this host.

But 2x53%>100%. What I did was to accomodate the init parameters of the test DB not to cause serious problems. When starting it, I got a warning anyway. As long as the production DB idles, the test DB gets the memory it needs by swapping it out.

Bye
Rick Denoire Received on Fri Jan 10 2003 - 18:30:21 CST