Re: Oracle 8i eats memory !!!

Brian Jay Gould (bgould_at_home.com) wrote:
: This discussion is going on in 1999 isn't it? Even my laptop computer runs 192MB of memory. Memory
: is practically free these days.

No, memory isn't free. When performance matters your memory parameters are tuned to be optimal for your system. If you have 1Gb of RAM then you tune to that value. My development machine has 5 databases, and the RAM usage is tuned so that an extra 100Mb taken out of shared memory due to this new java pool will start forcing my machine to swap unacceptably, and so slow down the system.

One of my production machines (1Gb RAM, quad CPU, 30Gb disk) has a large shared pool setting so that the commonly accessed tables and procedures can be cached/pinned. The system reports total memory usage (excluding IO cache) is close to the 900Mb mark.

Thomas Kyte's note about the java_pool_size is a warning to all of us to look carefully into what new versions of the database may be doing, and to retune our systems accordingly after any upgrade of this type.

I know I'm a little negligent in this matter, due to time constraints. I think it's time I went on the performance tuning course :-)

rgds
Stephen Received on Sun May 23 1999 - 16:10:09 CDT