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 ...
Get Oracle® Database 10g Insider Solutions now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
