Use SQL Tuninng Advisor for Tuning SQL

Steps for Using SQL Tuning Advisor in OEM12c :

Login to Console and go to database Home page.

From Tabs select Performance --> SQL Monitoring and Copy SQL ID for the particular SQL for whome we are trying to do Tuning.

• We need to create a Tuning set for SQL Tuning Adviser to work on
• For that Select Performance --> SQL --> Sql Tuning Set
• Click create and create a Tuning Set Using SQL ID in search Criteria . After creating the tuning set please ensure that it has sql count =1 (in our case)
• Now go to Performance --> SQL Tuning Advisor and  select SQL Tuning Set created in above example.
• set scope to Comprehensive and Submit the job and wait .

 Now after completion of Job go to Performance --> Advisory Home and Select the SQL Tuning Advisory Result .

In that we can analyze the result and can take appropriate Actions.

Thanks,
Sachin Singh Bhadauria