 |
|
Oracle Tips by Burleson |
Oracle 10g AWR Collection Process
The collection process involves the capture of
in-memory statistics from the SGA and their transfer to the physical
tables located in the workload repository. The new background
process, MMON, does this. The frequency of the capture snapshot is
30 minutes by default, however it can be adjusted suitably.
You can control the interval and retention of
snapshot generation by the dbms_workload_repository.
modify_snapshot_settings procedure. For example:
EXEC
DBMS_WORKLOAD_REPOSITORY.MODIFY_SNAPSHOT_SETTINGS (43200, 15);
In this example, the retention period is
specified as 30 days (43200 min) and the interval between each
snapshot is 10 min.
The snapshots are used for computing the rate
of change of a statistic. This is mainly used for performance
analysis. A snapshot sequence numer (snap_id) identifies each
snapshot, which is unique within the Workload Repository.
Figure 9.4
shows the relation of AWR to other components.
Get the complete Oracle10g story:
To get the code instantly, click here:
Need an Oracle Mentor?
BEI is now offering personal mentors for Oracle DBAs where you can have an
Oracle expert right at your fingertips, anytime day or night. We work with
hundreds of Oracle databases every year, so we know exactly how to quickly
assist you with any Oracle question.
Why risk an unplanned outage? You can now get telephone access to Don
Burleson or any of his Oracle Certified DBAs with more than 20 years of
full-time IT experience. Click here for details:
http://www.dba-oracle.com/service_oracle_backup.htm
|
