||Oracle Tips by Burleson
Easy Oracle Automation
Chapter 2 -
Architecture Changes in a Nutshell
What’s new in
the 10g Architecture?
Next will be an examination of the
performance improvement features in this flagship database
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
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
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
The above text is
an excerpt from:
Easy Oracle Automation
Storage, Memory and Diagnostic Features
by Dr. Arun Kumar R.
||Need an Oracle Health Check?
Does your boss blame you for an Oracle performance problem?
Need to prove that your database is properly optimized?
BC Oracle performance guru's can quickly verify every aspect of your
Oracle database and provide a complete certification that your database
is fully optimized.