Oracle's Suite of Other Advisors

Oracle Database 10g has a suite of advisors that provide feedback about resource utilization and performance. You have already reviewed the ADDM and SQL Advisors. The other important advisors are SGA Advisor (tuning SGA), PGA Advisor (tuning PGA), Buffer Cache Advisor (buffer cache), Library Cache Advisor (different library cache sizes), Segment Advisor (object space issues and growth trends), and Undo Advisor (flashback support).

All these database advisors have some common attributes. For example, each advisor can be launched in one of two modes—limited mode or comprehensive mode—depending on the time available for completing the advisory task. When an advisor is launched to investigate a problem, it performs an in-depth analysis of the statistics to generate the advice. In limited mode, the advisor does a relatively shallow (quick) analysis, while in comprehensive mode, the advisor does an in-depth analysis, taking a much longer time.