What's New in Oracle Performance?

This section describes new performance features of Oracle Database 11g Release 1 (11.1) and provides pointers to additional information. The features and enhancements described in this section comprise the overall effort to optimize database performance.

For a summary of all new features for Oracle Database 11g Release 1 (11.1), see Oracle Database New Features Guide.

The new and updated performance features in Oracle Database 11g Release 1 (11.1) include:

• Automatic Database Diagnostic Monitor (ADDM) enhancements

  ADDM has been enhanced to perform global analysis on all instances of an Oracle Real Application Clusters (Oracle RAC) cluster.

  For more information, see "ADDM for Oracle Real Application Clusters".

• Wait activity details

  You can view wait activity details for services, modules, and actions from the Top Activity page.

  For more information, see "Monitoring User Activity".

• Improved Automatic Workload Repository (AWR) baselines

  You can create a single, fixed-time AWR baseline or a repeating baseline. Additionally, improved manageability of AWR baselines is now available, including the ability to compute threshold statistics.

  For more information, see "Managing Baselines".

• Improved manageability of SQL Advisor, SQL Access Advisor, and SQL Tuning Sets

  Significant improvements were made to managing SQL Tuning Advisor, SQL Access Advisor, and SQL Tuning Sets.

  For more information, see Chapter 10, "Tuning SQL Statements" and Chapter 11, "Optimizing Data Access Paths".

• SQL Performance Analyzer

  SQL Performance Analyzer enables you to measure the impact of system changes on SQL performance by testing these changes using a SQL workload on a test system.

  For more information, see Chapter 12, "Analyzing SQL Performance Impact".

• Active Session History (ASH) enhancements

  The ASH report has been enhanced to include row-level tracking of top SQL statements, top PL/SQL procedures, top Java workload, top phases of execution, and other session-related information.

  For more information, see Chapter 7, "Resolving Transient Performance Problems".

• Automated Maintenance Tasks

  Key maintenance tasks such as optimizer statistics collection, Automatic SQL Tuning, and Segment Advisor are now managed through the Automatic Maintenance Task framework. This framework enables you to exercise finer control over the scheduling of maintenance tasks and on their CPU consumption.

  For more information, see "Viewing Automatic SQL Tuning Results".

• Customizable Performance page

  You can customize the Performance page to show only the graphs and charts that you want displayed. You can also choose whether to include AWR baselines in the performance charts.

  For more information, see "Customizing the Database Performance Page".

• I/O Statistics

  The Performance page now contains charts for Throughput, I/O, Parallel Execution, and Services. You can use the I/O charts to monitor I/O throughput and latency information based on various criteria such as function (for example, Recovery Manager), consumer groups, and file types.

  For more information, see "Monitoring Instance Activity".