Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Keep pool

Re: Keep pool

From: Tim Johnston <tjohnston_at_quallaby.com>
Date: Fri, 12 Mar 2004 10:35:46 -0500
Message-ID: <4051D8D2.9030606@quallaby.com>


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_at_za.didata.com_
> 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_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
>
> ________________________________________________
>
> 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_at_za.didata.com
> 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_at_freelists.org
put 'unsubscribe' in the subject line.
--
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 Fri Mar 12 2004 - 09:32:36 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US