What’s new in the 10g Architecture?

Next will be an examination of the performance improvement features in this flagship database release.

Summary of Performance Improvement Features

The new and improved performance features in Oracle Database 10g, Release 10.1.0.2, will be introduced next. In the following chapters, they will be explored in greater detail. Here is a summary of the new performance features:

• Automatic diagnosis of performance problems, potential or real, and subsequent correction is a novel feature in Oracle Database 10g. This is done by Automatic Statistics Collection and Retention, Automatic Database Diagnostic Monitor (ADDM), Automatic SQL Tuning, and Automated Space Management (ASM). The Automatic Statistics Collection is handled by the new Automatic Workload Repository (AWR). AWR collects the data, processes it, and maintains performance statistics for use by ADDM and other advisors for problem detection and automatic self-tuning.
   

• The optimizer statistics collection feature automates the process of getting optimizer statistics for objects. Objects with stale statistics or no statistics are automatically analyzed.  Remember that DBAs used to analyze large objects in earlier versions of Oracle databases for up-to-date statistics and performance improvement.  Also Rule-based Optimization (RBO) functionality is no longer supported. It still exists in Oracle Database 10g Release 1, but is no longer supported. Oracle supports only the query optimizer, and all applications using Oracle Database 10g (10.1) should make use of that optimizer.
   

• Automatic Shared Memory Management (ASMM) helps the DBA by simplifying management of System Global Area (SGA) parameters through self-tuning algorithms. ASMM also ensures the optimal utilization of available memory resources and improves overall database performance.