Skip to content

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.

    Also See:

    Analyzing SQL with SQL Tuning Advisor

    Oracle ORAchk