Using multiple buffer pools

From: Chuck Hamilton <chuck_hamilton_at_yahoo.com>
Date: Fri, 27 Jul 2001 13:06:24 -0400
Message-ID: <gi73mt419822ur4jh2jla9qa65quj07ogj@4ax.com>

What is the best way to use multiple buffer pools? Should most segments still be assigned to this pool? Or should most be assinged to either KEEP or RECYCLE depending on object usage?

I currently have everything in the DEFAULT pool with about a dozen segments assigned to KEEP. The KEEP pool size is slighly larger than the sum of the blocks used by those objects. Those objects are tables that are scanned very frequently but are small in size. Is this a good usage of multiple buffer pools?

--
Chuck Hamilton
chuck_hamilton_at_yahoo.com

"Do not be deceived, God is not mocked; 
for whatever a man sows, this he will also
reap." (Gal 6:7 NASB)

Received on Fri Jul 27 2001 - 12:06:24 CDT