Automatic SQL Tuning Using SQL Tuning Advisor
June 17, 2005
Mark Rittman

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.