RE: Keep pool

  • From: "Dilip Chavan" <dilipc@xxxxxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 12 Mar 2004 17:38:16 +0530

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

Other related posts: