2012-12-11 11gR2 "2 Day + Performance Tuning Guide" page 1 - 51

 

 

Gathering Database Statistics Using the Automatic Workload Repository -- 使用AWR收集系统信息
The following initialization parameters are relevant for AWR:
 -- STATISTICS_LEVEL
Set this parameter to TYPICAL (default) or ALL to enable statistics gathering by
AWR. Setting STATISTICS_LEVEL to BASIC disables many database features,
including AWR, and is not recommended. To learn more about this initialization
parameter, see Oracle Database Reference.
 -- STATISTICS_LEVEL 设置为TYPUCAL或者ALL

 

 -- CONTROL_MANAGEMENT_PACK_ACCESS
Set to DIAGNOSTIC+TUNING (default) or DIAGNOSTIC to enable automatic
database diagnostic monitoring. Setting CONTROL_MANAGEMENT_PACK_ACCESS
to NONE disables many database features, including ADDM, and is strongly
discouraged. To learn more about this initialization parameter, see Oracle Database
Reference.
 -- CONTROL_MANAGEMENT_PACK_ACCESS设置为 DIAGNOSTIC+TUNING或者DIAGNOSTIC

 

Time Model Statistics -- 时间模型数据
A session is a logical entity in the database instance memory that represents the state
of a current user login to a database. Database time is calculated by aggregating the
CPU time and wait time of all active sessions (sessions that are not idle). For any
database request, the CPU time is the sum of the time spent working on the request,
while the wait time is the sum of all the waits for various database instance resources.
DB time includes only time spent on client processes and does not include time spent
on background processes such as PMON.
 -- DB TIME是数据库中最为重要的一个时间模型

Using the Oracle Performance Method -- 调优方法论
In the proactive tuning phase, you must perform tuning tasks as part of your daily
database maintenance routine, such as reviewing ADDM analysis and findings,
monitoring the real-time performance of the database, and responding to alerts.
 -- 预警，每天查看监控数据库

In the reactive tuning phase, you must respond to issues reported by users, such as
performance problems that may occur for only a short duration of time, or
performance degradation to the database over a period of time.
 -- 反映，根据客户的需求做出调整