Oracle Consulting Oracle Training Oracle Support Development
Oracle Books
SQL Server Books
IT Books
Job Interview Books
Rampant Horse Books
911 Series
Pedagogue Books

Oracle Software
Write for Rampant
Publish with Rampant
Rampant News
Rampant Authors
Rampant Staff
Oracle News
Oracle Forum
Oracle Tips
Articles by our Authors
Press Releases
SQL Server Books

Oracle 11g Books

Oracle tuning

Oracle training

Oracle support

Remote Oracle


Privacy Policy



Oracle Tips by Burleson

Oracle 10g Advisory Framework -

So far we have examined the details of the workload repository. Now let us focus on the advisory framework Oracle 10g introduces.

Advisors are the server components that provide you with useful feedback about resource utilization and performance. The most important of all advisors is the Automatic Database Diagnostic Monitor (ADDM). ADDM does analysis of the system, identifies problems and their potential causes, and comes up with recommendations for fixing the problems. It can call all other advisors also.

The main features of the ADDM are as follows:

  • ADDM runs automatically in the background process MMON whenever a snapshot of in-memory statistics is taken. ADDM does analysis of the statistics collected between two snapshots.

  • ADDM analysis results are written back to the workload repository for further use.

  • ADDM uses the new wait and time statistics model, where activities with high time consumption are analyzed on a priority basis. This is where the big impact lies.

  • ADDM can also be invoked manually.

The results of the proactive analysis performed by the ADDM module are posted to the workload repository and then they are available to users through the OEM console or by other SQL query means.  ADDM analysis is also the driving point for Server Alerts whenever the threshold is exceeded for the specified metrics. The new OEM or Grid Control has many web pages devoted to displaying ADDM findings.

Other advisors include:

  • SQL Tuning Advisor:  This advisor is responsible for providing tuning advice for a SQL statement. We have covered this topic in detail in Chapter 2, Database Tuning and Performance Improvements.

  • SQL Access Advisor: This provides expert advice on materialized views, indexes, and materialized view logs. A full detailed account of its utility and usage is covered in Chapter 16, Business Intelligence.

  • Segment Advisor: This advisor is responsible for space issues involving a database object. It analyzes the growth trends. It can also extend advice on the shrink possibility for the segments.

  • Undo Advisor: This advisor suggests parameter values, and how much additional space would be needed to support flashback for a specified time. However, most of the undo tuning (like undo retention) is automatic in Oracle Database 10g.

Oracle 10g Advisory Framework - ADDM

  • Redo Logfile Size Advisor: This determines the optimal smallest online redo log file size, based on the current fast_start_mttr_target setting and MTTR statistics.

Linux Oracle commands syntax poster

ION Oracle tuning software

Oracle data dictionary reference poster

Oracle Forum

BC Oracle consulting support training

BC remote Oracle DBA   



 Copyright © 1996 -2017 by Burleson. All rights reserved.

Oracle® is the registered trademark of Oracle Corporation. SQL Server® is the registered trademark of Microsoft Corporation. 
Many of the designations used by computer vendors to distinguish their products are claimed as Trademarks