You can create additional pre-change or post-change SQL trials for a SQL
Performance Analyzer task to test if other system changes have resulted in changes to the
execution plans of SQL statements and have impacted SQL performance.
- Go to the SQL Performance Analyzer Task: <name of the task>
panel.
- In the Trials section, click Create
trial.
- In the Create trial panel:
- Review the SQL Performance Analyzer task details.
- Specify the following general options:
- Name: Enter a name for the
trial.
- Description: Optionally,
enter a description for the trial.
- Execution method: Select one
of the following options to determine how the SQL trials are
created and what content is generated:
- Execute SQL:
Generates both execution plans and statistics for each
SQL statement in the SQL tuning set by actually running
the SQL statements. On selecting this option, the
Per SQL time limit field is
displayed and you must select an option to specify the
time limit for SQL execution during the trial.
- Generate plans:
Invokes the optimizer to create execution plans only
without actually running the SQL statements.
- Select the check box in the Comparison section to
understand how the trial's performance compares with a reference trial.
On selecting the check box, the following fields are displayed:
- Reference trial: Select a
reference SQL trial for comparison and review the details of the
trial.
- Comparison metric: The
comparison metric selected for the reference trial is displayed
by default and you can change or add other metrics for the
analysis. If you chose to generate explain plans only in the SQL
trial, the Optimizer cost metric stored
in the SQL execution plans is selected by default.
- Validate SQL result sets:
Select to direct the SQL Performance Analyzer to detect if the
result-sets between the two trials being compared are different.
If differences are seen in the result-sets of any SQL statement
between the two trials being compared, the SQL Performance
Analyzer comparison report will indicate this for every such SQL
statement. This is On by default.
- Schedule: Select
Immediately to start the trial now or
Later to schedule the trial at a later
time.
- Click Create.
The SQL trials created for a SQL Performance Analyzer task are listed in the
Trials section in the
SQL Performance Analyzer Task:
<name of the task> panel.
In the
Trials section, you can:
- Monitor the SQL trials created for the SQL Performance Analyzer task.
- Click the Actions icon () for a trial and perform the following tasks:
- View execution parameters: Click to
view the execution parameters specified for the trial.
- Create like: Click to create a clone
of the trial.