Re: Oracle Keep Pool
Date: Wed, 25 Nov 2009 00:22:39 -0800 (PST)
On Nov 25, 8:51 am, Mike <m..._at_adlineservices.com> wrote:
> We're on 10g. We're playing with the Keep Pool. If the Keep Pool is
> meant to keep frequently used blocks/tables in cache, well, if they we
> frequently used, wouldn't they be in the cache anyhow??
> So, what is the purpose of the Keep Pool??
If blocks are used frequently. They should be in memory. In the KEEP pool, the goal is to keep blocks cached for as long as possible.
read http://www.remote-dba.net/oracle_10g_tuning/t_oracle_keep_pool.htm Received on Wed Nov 25 2009 - 02:22:39 CST