Running the SQL Tuning Advisor
Use the SQL Tuning Advisor for tuning SQL statements. Typically, you run this
advisor in response to an ADDM performance finding that recommends its use. You
can also start the SQL Tuning Advisor manually. One reason is to tune statements that
the Automatic SQL Tuning Advisor has not considered for tuning.
As described in "About the SQL Tuning Advisor" on page 10-19, the SQL Tuning
Advisor can select SQL statements to tune from several sources. The following
scenario assumes that you want to tune the SQL statements with the most activity:
To run the SQL Tuning Advisor:
1. In EM Express, from the Performance menu, choose Performance Hub.
The Performance Hub page appears.
2. In the Select Time Period field, select the desired time period.
In this example, Historical - All has been selected in the Select Time Period field.
3. Select Activity.
The Activity tab appears.
4. In the table at the bottom of the Activity tab, select the row that includes the SQL
statement that you want to tune, and then click the Tune SQL button.
In this example, the SQL statement in the sixth row of the table is selected.
... zobacz całą notatkę