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

    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:


    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