Re: Keep Pool Question

From: Brian <brian_at_databaseknowledge.com>
Date: 8 Mar 2005 09:42:42 -0800
Message-ID: <1110303762.950807.37630@o13g2000cwo.googlegroups.com>

Increasing the buffer cache by 600M to 3.3G made the db perform much better. The server has never swapped, there are no buffer free waits, checkpoints are smooth, the server load average is < 2-there no issues whatsoever.

It's impossible to make a blanket statement that the SGA should ALWAYS be 1/3 of the total memory. That may be a good starting point however each database is different.

Sure the application needs tuning. It will take years for the developers to remodel the data and rewrite millions of lines of code to use bind variables.

If the sever constantly has 2-3G of free memory, why not use some of it? Linux won't ever use it. Oracle is scalable and lots of databases have 4G+ SGAs. That's why it's possible to add more LRU queues and extra db writers. This DB can easily handle a 4G buffer cache. Received on Tue Mar 08 2005 - 11:42:42 CST