| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Keep pool
Hi Tim and list,
That is what I said in the presentation, but it was not right. When I got back to Sydney today, there were some helpful emails waiting for me from Stephan Haisley. He has discovered that my test case was faulty in that I had created the test table in the SYS schema. The KEEP buffer pool functionality works just fine for user tables.
Another correction: I said that the alternative block size caches do not have a hot region. Stephan has also demonstrated that this is only true if you make the working sets ridiculously small.
For those to whom it applies, I'll update my presentation and ask Hotsos to post a new version of it on their web site early next week.
@ Regards, @ Steve Adams @ http://www.ixora.com.au/ - For DBAs @ http://www.christianity.net.au/ - For all
-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
On Behalf Of Tim Johnston
Sent: Saturday, 13 March 2004 2:36 AM
To: oracle-l_at_freelists.org
Subject: Re: Keep pool
FYI... During the Hotsos Symposium, Steve Adams mentioned that the keep pool appears to be broken in 9.2 and above... He didn't go into details but it's worth looking into if you're considering using it... I'll try and do some investigation and see if I can provide you a test case...
Tim
George Leonard wrote:
> def a future required enhancement then for Oracle to look at.
> anyhow not that big a issue, it is mostly the smaller tables I want to
> alter to the keep pool anyhow, it is only the very large tables
> (multigig) that is on the 16K table space anyhow.
> thanks
>
> George
>
>
> -----Original Message-----
> *From:* oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org] *On Behalf Of *Dilip Chavan
> *Sent:* 12 March 2004 14:08 PM
> *To:* oracle-l_at_freelists.org
> *Subject:* RE: Keep pool
>
> Hi George,
> The keep and recycle pools can be configured only for base block
> size ( configured with DB_BLOCK_SIZE which is used for system
> tablespace).
> You can't set keep and recycle pools for other non-system multiple
> block sizes.
> These sizes can have only DEFAULT pool.
> Regards,
> ~Dilip
>
> -----Original Message-----
> *From:* oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org]*On Behalf Of *George
> Leonard
> *Sent:* Friday, March 12, 2004 5:22 PM
> *To:* oracle-l_at_freelists.org
> *Subject:* Keep pool
>
> Hi all
>
> I have a mix of 8K and 16K tablespaces.
>
> As such I have configured a 8K and 16K cache pool
> via:db_cache_size and
> db_16k_cache_size.
> I have thus far configured a kep pool via db_keep_cache_size,
> but I am
> guessing this will only be used for the default block size
> being 8K.
>
> How do I configure (what si the parameter name) for a 16K keep
> pool ?
>
> thanks
>
> George
-- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------Received on Sun Mar 14 2004 - 23:24:35 CST
 |
 |