RE: Keep pool
- From: "Steve Adams" <steve.adams@xxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 15 Mar 2004 16:27:52 +1100
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Tim Johnston
Sent: Saturday, 13 March 2004 2:36 AM
To: oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx] *On Behalf Of *Dilip Chavan
> *Sent:* 12 March 2004 14:08 PM
> *To:* oracle-l@xxxxxxxxxxxxx
> *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@xxxxxxxxxxxxx
> [mailto:oracle-l-bounce@xxxxxxxxxxxxx]*On Behalf Of *George
> Leonard
> *Sent:* Friday, March 12, 2004 5:22 PM
> *To:* oracle-l@xxxxxxxxxxxxx
> *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
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
