Oracle SQL tuning advisor

The #SQL #Tuning #Advisor analyzes high-volume SQL statements and offers tuning recommendations. It takes one or more SQL statements as an #input and invokes the Automatic Tuning #Optimizer to perform SQL tuning on the statements. It can run against any given SQL statement. The SQL Tuning Advisor provides advice in the form of precise SQL actions for tuning the SQL statements along with their expected performance benefits.
When we run SQL tuning advisor against a SQL statement or sql_id, it provides tuning recommendations that can be done that query to improve performance. It might give suggestion to create few indexes or accepting a SQL profile.

00:00 Automatic SQL Tuning in Oracle
04:26 Lab practice
05:21 Create tuning task
09:12 Execute tuning task
09:47 Status of tuning task
10:29 Display recommendation
17:28 Why some recommendations are wrong. Example?

Website: https://www.dbagenesis.com/
Facebook:   / dbagenesis  
Instagram:   / dbagenesis  
Twitter:   / dbagenesis