RE: Keep pool
- From: "George Leonard" <leonarge@xxxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 12 Mar 2004 14:19:08 +0200
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 "
Other related posts:
