Oracle s Suite of Other Advisors


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 modeslimited mode or comprehensive modedepending 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.



    Oracle Database 10g Insider Solutions
    SUSE LINUX Enterprise Server 9 Administrators Handbook
    ISBN: 672327910
    EAN: 2147483647
    Year: 2006
    Pages: 214

    flylib.com © 2008-2017.
    If you may any questions please contact us: flylib@qtcs.net