COLUMN

DESCRIPTION

OBJECT_TYPE	Object type -SYSTEM, SERVICE, EVENT_CLASS, TABLESPACE, FILE
OBJECT_NAME	Object's name for which the threshold is set
STATUS	Status of threshold on a valid object (VALID or INVALID)

Table 4.5 – dba_thresholds

Server-generated alerts will greatly help in automating the DBA tasks.  The next topic to review is the advisory framework in Oracle10g.

Advisory Framework

Oracle Database 10g has server components called advisors to provide feedback about resource utilization and performance. The important advisors are listed below:

• Automatic Database Diagnostic Monitor (ADDM) - ADDM does a top-down analysis of the database, identifies problems and potential issues, and gives recommendations for fixing these problems. ADDM can invoke other advisors.
   

• SQL Tuning Advisor -  provides tuning advice for SQL statements.
   

• SQL Access Advisor -  provides advice on database schema issues and determines optimal data access paths.