Re: Table In Memory
From: Mark Johnson <mwc.mjohnson_at_capital.ge.com>
Date: 1996/08/30
Message-ID: <32275B45.689B_at_capital.ge.com>#1/1
Date: 1996/08/30
Message-ID: <32275B45.689B_at_capital.ge.com>#1/1
> The CACHE parameter does not actually PIN the table into the Database
> Buffer Cache. It places it's blocks at the MRU end of the list. Be very
> careful that you don't flush the cache. You may want to limit the number
> of blocks to cache. Set this with the parameter cache_size_threshold.The default for cache_size_threshold is 10% of total db_block_buffers,
so if you just alter the table and turn the cache parameter on, by default you will only
use 10% of your db_block_buffers for storing the table's blocks, which might not be
enough.
>
>
Received on Fri Aug 30 1996 - 00:00:00 CEST