Welcome to OracleGiants.com!     

Oracle 10g DBA & Business Intelligence Resources.

db_cache_size

If you have sga_target set on your instance it can also be a good idea to set db_cache_size. This can especially be true when your top events are CPU and file IO. When an instance has insufficient memory, Oracle will often spend significant CPU time managing memory by moving it among various pools. Setting the db_cache_size will set the minimum size of the db_cache. Oracle can increase the size if necessary.

Recommendation:
To set the db_cache_size to 500 MB you would use the following command:
alter system set db_cache_size=500M;

 

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