Search This Blog

Sunday, February 18, 2007

General Overview

Tools For Database Tunning.
1.Oracle Enterprise Manager
2.Oracle Diagnostics Pack
3.Oracle Database Tuning Pack

Gathering Database Statistics Using the Automatic Workload Repository

Gathering database statistics using the AWR is enabled by default and is controlled by the STATISTICS_LEVEL initialization parameter. The STATISTICS_LEVEL parameter should be set to TYPICAL or ALL to enable statistics gathering by the AWR.
By default, this process is repeated every hour, and the result is called an AWR snapshot.

No comments: