Database Reference
In-Depth Information
Moreover, you can use the following data dictionary views to
view the ADDM recommendation.
DBA_ADVISOR_FINDINGS: Describes the findings identified
by ADDM analysis.
DBA_ADVISOR_OBJECTS: Describes the objects referenced
in the ADDM analysis.
DBA_ADVISOR_RECOMMENDATIONS:
Contains
the
recommendations based on ADDM findings.
DBA_ADVISOR_RATIONALE: Describes the rationale behind
each finding.
Advisor Central
Oracle EM Database Control provides the Advisor Central
section as shown in Figure 11-3. You can access it through
Home page under the Related Links area. As the names states, it
contains the following advisors each relates to the specific
functionality/area of Oracle performance and tuning. These
advisors extracts the data from dynamic performance view and
other area of AWR and then generates their recommendations
for better performance of Oracle Database Server overall. These
advisors can help you examine several database problems along
with suggestions to fix them.
SQL Tuning Advisor
SQL Access Advisor
Memory Advisor
Mean Time to Recover Advisor
Segment Advisor
Undo Management Advisor
Let's have a look on each of these one by one. Going into the
details is beyond the scope of this topic. You can easily get the
details from Oracle provided documentation or doing the Google
Search WWH ::
Custom Search