Starting with 10g, Oracle introduced Advisors, which are part of the ADDM (Automatic Database Diagnostic Monitor) and run in the background. This article discusses some of the more common ADDM utilities used and how they can help troubleshoot and tune the database.

This story continues at
http://www.dbasupport.com/oracle/ora...tilities.shtml