Re: Using multiple buffer pools

From: Winner Manurung <manruw_at_uninet.net.id>
Date: Sat, 28 Jul 2001 11:15:52 +0700
Message-ID: <hvD87.1212$96.8292@news>

Hi Chuck,
That is a good configuration.
In addition, if you have enough memory, you can put not only small objects in the KEEP pool, but also big frequently accessed objecs. And you should make use of RECYCLE pool for big rarely accessed objects, so it won't take the DEFAULT pool.

Winner.

Chuck Hamilton <chuck_hamilton_at_yahoo.com> wrote in message news:gi73mt419822ur4jh2jla9qa65quj07ogj_at_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 - 23:15:52 CDT