New Features of the SQL Advisors

While there are many important enhancements in Oracle10g, the most important one is the integration and the at-your-fingertips access to all components of the task response time.  The most important new features of the Oracle10g Enterprise Manager include:

§         Server Metrics: This exciting feature is the ability of Oracle to step-out of the database areas and sample the server resources associated with every database operations. 

§         Integration: The Oracle10g Enterprise Manager allows the DBA to easily see all aspects of performance to relieve the tedium of running scripts and executing specialized routines.

The server metrics are especially important for SQL tuning because the server resources associated with every step within the execution plan for every SQL statement is shown in Figure 19.66.

For any SQL statements, the components are displayed with hyperlinks for easy access. 

By clicking on a table name in the execution plan in Figure 19.66, a detailed column representation of any table in the SQL query is easily viewed as shown in Figure 19.67.

This information includes the table description, the schema, and the tablespace and table organization method. 

Now that the more important new features of the SQL Advisors have been revealed, the following section shows how the SQL Access Advisor allows the DBA to make global changes that affect SQL execution.

SEE CODE DEPOT FOR FULL SCRIPTS