Automatic SQL Tuning using SQL Tuning Advisor : "SQL
tuning is one of the challenging tasks faced by Database
Administrators. It is an interesting and creative, but at the
same time, daunting task. Manual tuning of SQL statements
requires through knowledge of how the statements are executed in
the background and experience to understand suitable access
paths to yield better response times. Moreover, in a typical
application, there are just too many SQL statements to tune and
advise the developers. Oracle Database 10g introduces many
useful and easy-to-use tuning tools and methodologies. In this
article, we will examine one of these new and improved features
- SQL Tuning Advisor." A good concise guide to this new
Oracle 10g feature.