RE: oracle 10g and db_keep_cache_size obsolete ?
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.
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Crisler, Jon Sent: Wednesday, July 29, 2009 12:55 PM
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.
http://www.freelists.org/webpage/oracle-l Received on Wed Jul 29 2009 - 12:09:40 CDT