Global SQL Optimization

Oracle professionals must always undertake to perform holistic tuning before delving into the tuning of specific SQL statements, an approach that has been the bread and butter of successful corporate DBA's since the earliest days of Oracle6.

In Oracle 11g, we see this holistic approach codified in the SQL Performance Analyzer (SPA), a new tool to simplify the setting of optimizer statistics and initialization parameters. In SPA, the DBA chooses a representative workload and runs it, comparing the overall SQL execution plans with different sets of CBO statistics and settings for the silver bullet initialization parameters.

Click below to read more about Global SQL Optimization:


http://www.dba-oracle.com/t_global_sql_optimization.htm
 

*****************************************

Need a Health Check?

Oracle is the world's most complex and robust database and there are hundreds of sub-optimal setting that can cripple your database performance.

Burleson Consulting has a great Oracle health check where we identify all database bottlenecks to ensure that your mission-critical system is running at optimal speeds.

Just call 800-766-1884 to schedule your health check.

*****************************************

Need Oracle Training?

The very best Oracle training comes from Burleson Consulting, where you get an on-site visit by an experienced Oracle expert and author.  Whether it's one-on-one mentoring or getting a customized on-site Oracle training class, there is no substitute for BC Oracle training.  Just call 800-766-1884 for details, and check-out our on-site Oracle training catalog at the following link:

http://www.dba-oracle.com/bc-catalog.pdf