Re: Keep pool

  • From: Tim Johnston <tjohnston@xxxxxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Fri, 12 Mar 2004 10:35:46 -0500

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

________________________________________________

George Leonard
Oracle Database Administrator
Dimension Data (Pty) Ltd
(Reg. No. 1987/006597/07)
Tel: (+27 11) 575 0573
Fax: (+27 11) 576 0573
E-mail:_george.leonard@xxxxxxxxxxxxxx
Web: http://www.didata.co.za <http://www.didata.co.za/>

You Have The Obligation to Inform One Honestly of the risk, And As a Person
You Are Committed to Educate Yourself to the Total Risk In Any Activity!
Once Informed & Totally Aware of the Risk,
Every Fool Has the Right to Kill or Injure Themselves as They See Fit!


    -----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

________________________________________________

        George Leonard
        Oracle Database Administrator
        Dimension Data (Pty) Ltd
        (Reg. No. 1987/006597/07)
        Tel: (+27 11) 575 0573
        Fax: (+27 11) 576 0573
        E-mail:george.leonard@xxxxxxxxxxxxx
        Web: http://www.didata.co.za

You Have The Obligation to Inform One Honestly of the risk,
And As a
Person
You Are Committed to Educate Yourself to the Total Risk In Any
Activity!
Once Informed & Totally Aware of the Risk,
Every Fool Has the Right to Kill or Injure Themselves as They
See Fit!
“This e-mail is sent on the Terms and Conditions that can be
accessed by Clicking on this link
http://www.vodacom.net/legal/email.asp "


“This e-mail is sent on the Terms and Conditions that can be accessed by Clicking on this link http://www.vodacom.net/legal/email.asp "


--
Regards,
Tim Johnston
Tel: 978-322-4226
Fax: 978-322-4100


---------------------------------------------------------------- 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: