RE: oracle 10g and db_keep_cache_size obsolete ?
- From: "Ric Van Dyke" <ric.van.dyke@xxxxxxxxxx>
- To: <Jon.Crisler@xxxxxxx>, "ORACLE-L" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 29 Jul 2009 12:09:40 -0500
* Would you consider db_keep_cache_size old-school and unneeded for 10g
if your doing auto memory management? *
Yes, however to say its obsolete is likely a stretch. The most common
problem I run into is folks really don't understand what is going on in
the KEEP pool. They load it up thinking that it will all "magically"
stay in cache. Putting too much in there (as it sounds like you have run
across) will make it act like the default pool, and likely worse since
as I recall there are fewer latches allocated to the KEEP pool. Used
very specifically it can be of some benefit. Same for the RECYCLE pool
as well.
Ric Van Dyke
Hotsos Enterprises, Ltd.
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Crisler, Jon
Sent: Wednesday, July 29, 2009 12:55 PM
To: ORACLE-L
Subject: oracle 10g and db_keep_cache_size obsolete ?
Looking for opinions- would you consider db_keep_cache_size old-school
and unneeded for 10g if your doing auto memory management ? We rarely
do this but ran across an app that has a lot of tables set to use the
KEEP pool, and I am having a difficult time finding enough memory to
satisfy the keep tables and a reasonable db_cache as well. My feeling
is to just get rid of it since I wind up starving the rest of the
database for tables with a DEFAULT pool.
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
