Call (800) 766-1884 for Oracle support & training
Free Oracle Tips

Oracle Consulting Support
Oracle Upgrades
Use New Oracle Features
Oracle Replication Support
Oracle Training
Remote Oracle DBA
System Documentation
Oracle Tips
Oracle Performance

Free Oracle Tips



BC Oracle tuning

Oracle training

Oracle support

Remote Oracle


Donald K. Burleson

Oracle Tips


Oracle Parameter Tuning

Oracle10g has more than 250 initialization parameters, and these parameters govern the overall behavior of the Oracle instance.  When set to suboptimal values, Oracle parameters can cause serious performance problems.  This is especially true for the parameters that govern the SQL optimizer.


The following is a list of some of the most important parameters for Oracle10g SQL tuning:

§       optimizer_mode

§       optimizer_index_cost_adj

§       optimizer_index_caching

§       optimizer_percent_parallel

There are parameters that control the sizes of the SGA regions and the proper configuration and settings for these parameters can have a profound impact on database performance. These parameters include:

§       db_cache_size

§       db_keep_cache_size

§       shared_pool_size

§       pga_aggregate_target

§       log_buffer

§       query_rewrite_enabled

§       cursor_sharing

§       db_file_multiblock_read_count

§       hash_multiblock_io_count

If the Oracle Automatic Memory Management (AMM) is utilized, Oracle will automatically change the relative sizes of the SGA regions, such as db_cache_size, pga_aggregate_target and shared_pool_size, based on current demands; however, the overall parameters for the instance must be set.


This is an excerpt from my latest book "Oracle Tuning: The Definitive Reference". 

You can buy it direct from the publisher for 50%-off and get instant access to the code depot of Oracle tuning scripts:




Oracle performance tuning software 

Oracle performance tuning book


Oracle performance Tuning 10g reference poster
Oracle training in Linux commands
Oracle training Excel
Oracle training & performance tuning books

Copyright © 1996 -  2014 by Burleson. All rights reserved.

Oracle® is the registered trademark of Oracle Corporation.