What is SQL Tuning Advisor in Oracle?
Sapna Malik
SQL Tuning Advisor is Oracle's answer to all the pitfalls and challenges of manual SQL tuning. The SQL tuning advisor provides recommendations that improve the execution plan of the SQL statement. It ensures that the system has the required statistics for the objects referenced by the statement, and that these statistics are representative. SQL Tuning Advisor is primarily designed to replace the manual tuning of SQL statements or any third-party tools currently used by some DBAs. The SQL Tuning Advisor provides an easy, automatic, and efficient technique for optimizing SQL statements without modifying any statements. The advisor produces well-tuned plans for one or more SQL statements along with tuning advice.
SQL Tuning Advisor is Oracle's answer to all the pitfalls and challenges of manual SQL tuning. The SQL tuning advisor provides recommendations that improve the execution plan of the SQL statement. It ensures that the system has the required statistics for the objects referenced by the statement, and that these statistics are representative.
SQL Tuning Advisor is primarily designed to replace the manual tuning of SQL statements or any third-party tools currently used by some DBAs. The SQL Tuning Advisor provides an easy, automatic, and efficient technique for optimizing SQL statements without modifying any statements. The advisor produces well-tuned plans for one or more SQL statements along with tuning advice.