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: Dilip Chavan <dilipc_at_gtllimited.com>
Date: Fri, 12 Mar 2004 17:38:16 +0530
Message-ID: <NHBBLLPKEJDEHLFEJLJPGEGFCCAA.dilipc@gtllimited.com>


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



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 - 06:10:21 CST

Original text of this message

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