Oracle Cloud Infrastructure Documentation

Create a Comparison

You can create additional comparisons for a SQL Performance Analyzer task to compare the performance data collected in a pre-change SQL trial to the post-change SQL trial.

To create a comparison:

  1. Go to the SQL Performance Analyzer Task: <name of the task> panel.
  2. In the Comparisons section, click Create comparison.
  3. In the Create comparison panel:
    1. Review the SQL Performance Analyzer task details.
    2. Select a reference SQL trial (pre-change) for comparison from the Reference trial drop-down list.
    3. Select a changed SQL trial (post-change) for comparison from the Changed trial drop-down list.
    4. Select the comparison metric in the Trial comparison field, based on which the pre-change and post-change trials will be compared.
    5. Select Immediately to start the comparison now or Later to schedule the comparison at a later time.
  4. Click Create.
The comparisons created for a SQL Performance Analyzer task are listed in the Comparisons section in the SQL Performance Analyzer Task: <name of the task> panel.

In the Comparisons section, you can:

  • Monitor the comparisons created for a particular trial. You can expand the row to view metric comparison details and click Comparison Report to view the SQL Performance Analyzer comparison report.
  • Click Create like to create a clone of the comparison.