Monday, September 28, 2009

Oracle Performance Tuning Features

Automatic Oracle Performance Tuning Features

■ Automatic Workload Repository (AWR) collects, processes, and maintains
performance statistics for problem detection and self-tuning purposes.

■ Automatic Database Diagnostic Monitor (ADDM) analyzes the information
collected by the AWR for possible performance problems with the Oracle

■ SQL Tuning Advisor allows a quick and efficient technique for optimizing SQL
statements without modifying any statements.

■ SQLAccess Advisor provides advice on materialized views, indexes, and
materialized view logs.

■ End to End Application tracing identifies excessive workloads on the system by
specific user, service, or application component.

■ Server-generated alerts automatically provide notifications when impending
problems are detected. See Oracle Database Administrator's Guide for information
about monitoring the operation of the database with server-generated alerts.

■ Additional advisors that can be launched from Oracle Enterprise Manager, such as
memory advisors to optimize memory for an instance. The memory advisors are
commonly used when automatic memory management is not set up for the
database. Other advisors are used to optimize mean time to recovery (MTTR),
shrinking of segments, and undo tablespace settings. For information about using
advisors that are available with Oracle Enterprise Manager, see Oracle Database 2
Day + Performance Tuning Guide.

■ The Database Performance page in Oracle Enterprise Manager displays host,
instance service time, and throughput information for real time monitoring and
diagnosis. The page can be set to refresh automatically in selected intervals or
manually. For information about the Database Performance page, see Oracle
Database 2 Day + Performance Tuning Guide.

(Manually) Oracle Performance Tuning Features

■ V$ Performance Views

The V$ views are the performance information sources used by all Oracle performance
tuning tools. The V$ views are based on memory structures initialized at instance
startup. The memory structures, and the views that represent them, are automatically
maintained by Oracle throughout the life of the instance. See Oracle Database Reference for information about dynamic performance views

No comments: