8.4. Understanding the Advisory Framework
The final component of the CMI is the advisory framework. If you're anything like me, when you hear the term "advisor," you may be picturing an animated paper clip popping up whenever you open SQL*Plus and dispensing wisdom such as, "It looks like you're connecting to a database." But don't worry, no irritating paper clips are going to appear (or dogs or guys named Bob).
Instead, the advisors are a collection of services that aid in the optimization of different aspects of the Oracle 10g database. Each advisor covers a specific subsystem within the database, and can analyze, diagnose, and provide recommendations to eliminate performance issues in the database.
This section takes a quick look at some ...