Using SQL Access Advisor
through OEM
-
Select the Advisor to run in
Comprehensive or Limited mode.
Figure 7.11 SQLAccess Advisor
-
Click on Show Advanced Options to show the
following screen:
Figure 7.12 – SQL Access Advisor
-
Schedule and submit the job.
Figure 7.13 – SQL Access Advisor
Figure 7.14 – SQL Access Advisor
-
Results are available through the Advisor
Central Page. Implement recommendations by clicking Schedule
Implementation.
Figure 7.15 –
SQL Access Advisor
This
completesd
the
review of SQL Advisors. Another important feature
of Oracle Database 10g is the improvised flash back feature.
Flash Back Corrections
Flashback Query was introduced in Oracle
9i. In Oracle Database 10g, this functionality has been expanded
from the AS OF clause in 9i. The DBA can use the VERSIONS
BETWEEN clause to retrieve all versions of the rows that existed
between the two time points.
