Oracle SQL Tuning Diagnostics and Tuning Schema 

...erview
This course is the first in a two-part series on
SQL Statement Tuning. This course will help experienced application developers to learn a tuning methodology they can use to maximize database performance with minimal effort. Participants will gain experience creating optimal access paths, such as partitioned views,
B-tree indexes, bitmapped indexes, index clusters, and hash clusters.
more...
Oracle SQL Tuning Tuning SQL and the Optimizer 

...rview
This course is the second in a two-part series on
SQL Statement Tuning. This course will help application developers to design
SQL statements that can reuse parsing and influence the optimizer to improve performance.
L earn To:
Identify the factors that affect network traffic.
Identify the factors that affect parsing.
Identify the guidelines for the reuse of parsed
more...