Databases Reference
In-Depth Information
you can always view and modify the PL/SQL that Enterprise Manager generates if you need to fine-tune
the code to meet your requirements.
In the next several paragraphs we demonstrate an example that generates indexing advice for the
SQL currently running in memory. First, log in to Enterprise Manager and navigate to the Advisor
Central page. Next, click the SQL Advisors link. Then click the SQL Access Advisor link. You should be
presented with a screen similar to the one shown in Figure 10-2. From this page you can verify the use of
existing objects or get advice on new objects. In this example, we want to get recommendations on new
indexes so the “Recommend new access structures” radio button is selected.
Figure 10-2. SQL Access Advisor initial options
Click the Continue button. You should see a screen similar to the shown in Figure 10-3. You have the
option of instructing SQL Access Advisor to analyze the SQL statements from one of the following
sources:
•
SQL in the buffer cache
•
A previously configured SQL tuning set (populated with SQL from memory or the
AWR)
•
A hypothetical workload
From this screen you can additionally choose to filter SQL by schema or by specific objects. For this
example, you want the SQL Access Advisor to analyze the SQL currently in memory with no filters.
