RE: Keep pool
- From: "George Leonard" <leonarge@xxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 12 Mar 2004 14:08:11 +0200
hi there
firstly the database was created as a 8k block size, I have always found
this a very good block size to use.
but I do have some very wide tables and I mean very wide that just ended
up better on a 16K block. so I am using /oracle9 feature of mutiple
block sizes depended on data requirements.
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 Lex de Haan
Sent: 12 March 2004 14:04 PM
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: Keep pool
Hi George,
as far as I know, this is impossible. may I ask why you have two
different block sizes in a single database?
kind regards,
Lex.
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of George Leonard
Sent: vrijdag 12 maart 2004 12:52
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 "
Other related posts:
