[AWR] method to turn off AWR snapshot collection
In an Oracle 11g environment, the default collection period for AWR is 1 hour, and the snapshot retention time is 8 days.
In some special cases, we may need to turn off snapshot capture of AWR. For example, we do not want to have other irrelevant scheduled scheduling tasks in the database background when the system is under high load.
Here we give the Enterprise Manager method (referred to as the EM method) and the command line method to turn off AWR snapshot collection.
1. Go to the AWR management page
In the Chinese EM environment, navigation method: "Server" → "Statistical Information Management" → "automatic workload data Archive", click to enter.
two。 Click "Edit"
The "General Information" and "manage Snapshots and baselines" information for AWR are given on the page.
What is shown here is the default value.
Snapshot retention time (days) 8
Snapshot interval (minutes) 60
Collection level TYPICAL
Next snapshot capture time *
3. Select "close snapshot collection" in snapshot collection, and click "Show SQL"
4. To close the SQL adjustment method collected by AWR snapshots, click "back".
The corresponding SQL statement is as follows:
Begin DBMS_WORKLOAD_REPOSITORY.MODIFY_SNAPSHOT_SETTINGS (11520); end
Of which 11520 is the number of hours of 8 days.
5. Click OK to confirm this adjustment
6. Effect of turning off AWR snapshot collection
AWR snapshot collection is turned off at this point.
At this point, the Snapshot interval (minutes) displays "not collected" and "next snapshot capture time" displays "not collected".
7. The description in the official document
For the description of DBMS_WORKLOAD_REPOSITORY.MODIFY_SNAPSHOT_SETTINGS in the official documentation, please refer to the link below.
Http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14258/d_wkrpos.htm#sthref8044
Interval
The new interval setting between each snapshot, in units of minutes. The specified value must be in the range MIN_RETENTION (10 minutes) to MAX_RETENTION (1 year).
If ZERO is specified, automatic and manual snapshots will be disabled. A large system-defined value will be used as the retention setting.
If NULL is specified, the current value is preserved.
8. Summary
The hourly automatic acquisition of AWR is a useful tool to assist in troubleshooting system performance problems. If there is no special need, it is recommended not to turn off the automatic acquisition function of AWR.
Good luck.
Secooler
11.07.08
-- The End--
