RE: Keep pool

From: George Leonard <leonarge_at_vodacom.co.za>
Date: Fri, 12 Mar 2004 14:19:08 +0200
Message-ID: <99CEA8FB33554B4BAC372CE602F9B7ED0370D7D3@zamdh02001.vodacom.corp>

 

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 "

---

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:15:39 CST