René Nyffenegger's collection of things on the web
René Nyffenegger on Oracle - Most wanted - Feedback -
 

Advisors in Oracle 10g

Yet to be finished ....
There are a few advisors:
  • SQL tuning advisor
    See also dbms_sqltune
  • SQL access advisor
  • Memory advisors
  • Segment advisor
    hanling space-related questions (predictions of table/index sizes, analzying growth trends)
  • Undo advisor
    Helping to estimate the size for undo.

The advisors' recommondations

The advisors' recommondations can be found with dba_advisor_tasks, dba_advisor_findings, dba_advisor_recommendations and dba_advisor_rationale.