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@xxxxxxxxxxxxx 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 "