Shulou(Shulou.com)06/02 Report--

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--

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.