Topics not read with Links

Cost Control: Inside the Oracle Optimizer (Informati​ve********​)

Link: http://www.dba-oracle.com/art_otn_cbo_p1.htm

This article has the following sections:

Part 1 - Using SQL CBO Parameters

Part 2 - Using CBO statistics

Part 3 - Proper SQL development environment

Part 4 - Using histograms to tune SQL

Part 5 - Clustering and SQL tuning

Part 6 - External costs and SQL execution

Part 7 - Using hints to tune SQL

Part 8 - Locating sub-optimal SQL

What can I do to fix Oracle10g upgrade & migration performanc​e tuning problems?

Link: http://www.dba-oracle.com/t_slow_performance_after_upgrade.htm

oracle 11g : performanc​e tuning topics

db11gpt-exam-study-guide-320816.pdf

Hints can be used to alter optimizer execution plans.  Remember, an optimizer hint is a directive that is placed inside comments inside the SQL statement and used in those rare cases where the optimizer makes an incorrect decision about the execution plan. Since hints are inside comments, it is important to ensure that the hint name is spelled correctly and that the hint is appropriate to the query.

See the link for more details and examples:

http://www.remote-dba.net/oracle_10g_tuning/t_sql_hints.htm

SQL Hints

Administrators embed hints in a SQL statement to influence the optimizer to choose a particular access path. By using hints, you are telling Oracle that your access path is better than the one the optimizer is choosing. It’s a safe assumption that most of us aren’t as smart as the optimizer. Let it make the choice, unless you are certain the optimizer is choosing the incorrect access path. http://www.rampant-books.com/art_oracle_10g_sql_tuning_hints.htm

Oracle Cost-Based Optimizer

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

A strategic plan for Oracle SQL tuning

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

What's New in Oracle Performance?

http://download.oracle.com/docs/cd/B19306_01/server.102/b14211/whatsnew.htm#i974246