SQL Access Advisor
Bitmap indexes are used to create indexes
on fields like the
The SQL Access Advisor can be run from OEM
using the SQL Access Advisor Wizard or by invoking the
dbms_advisor package. Using the SQL Access Advisor,
the DBA can tune
SQL
statements, manage workloads, recommend materialized views and
indexes, mark, update and remove recommendations, and manage
materialized views.
SQL Tuning with SQL Access Advisor
To use the SQL Access Advisor for tuning,
perform the following four steps:
-
Create a task.
-
Define the workload.
-
Generate the recommendations.
-
Implement the
recommendations.
Task Operations
A task has all the information relating to
the recommendation process and its results. To automatically
create a task, use the wizard in OEM or
dbms_advisor.quick_tune. After
creating a task, the DBA has to execute the task in preparation
for the tuning process:
