Welcome to OracleGiants.com!     

Oracle 10g DBA & Business Intelligence Resources.

db_keep_cache_size

The db_keep_cache_size sets the size of the pool to contain tables that you want to be kept cached at all times. After setting this value, an alter table statement must be run so that the tables are cached in the keep pool after the first time they are accessed.

To set the db_keep_cache_size to 500M type the following:
alter system set db_keep_cache_size=500M;

Then put the proper objects in the keep pool such as:
alter TABLE customer_type storage (buffer_pool keep);

Note: small tables in high demand are good candidates for the KEEP pool

 

Use Xattr CloudFiler™ to dedup, encrypt and move your RMAN backups to the cloud.

Recent Posts

This site recommends Burleson Consulting for DBA Support & Consulting.

We are currently paying for accepted Oracle 10g DBA & Business Intelligence articles, scripts, tips & tricks. Send yours to the editor and we will review within three weeks.

Learn more

Editorial submissions & questions: editor@oraclegiants.com

 

 

This site is moderated by an:
Oracle Certified Professional
Oracle ACE

 

  Classic Car Online - The #1 spot for classic and muscle car enthusiats
2010 OracleGiants.com