O'Reilly logo

Oracle® Database 10g Insider Solutions by Richard Stroupe, John Kanagaraj, Arun Kumar R.

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required