Oracle 19c SQL Tuning Advisor

Oracle 19c SQL Tuning Advisor. Analyze the SQL Tuning Set and generate recommendations

A complete script is provided: sta_cc.sql.
SQL Tuning Advisor (STA)The Script will:

• Generate a tuning task with the SQL Tuning Set 
• Run a tuning task where the SQL Tuning Advisor simulates the execution
• Generate a result report in TEXT format
• Generate statements to implement the findings

@/home/oracle/scripts/sta_cc.sql

Using Oracle 19c SQL Tuning Advisor, Fix everything

Execute all the recommendations from the Advisor:

Afterwards repeat the SQL Performance Analyzer runs from the previous exercise and verify the results:

@/home/oracle/scripts/spa_cpu.sql
@/home/oracle/scripts/spa_report_cpu.sql
@/home/oracle/scripts/spa_elapsed.sql
@/home/oracle/scripts/spa_report_elapsed.sql
exit

Compare the two resulting reports again – and compare them to the examples from the previous run.