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