Resource icon

Modify AWR Automatic Snapshot Settings

  • perf-test.com need your contributions to build up a strong repository of performance engineering resources.

If you recently installed Oracle database setup for trying out some performance hotspot areas. You may want to configure the AWR automatic collection frequency

1. Login as sysdba and execute following command to check if automatic AWR collection is enabled

Code:
show parameter statistics_level

upload_2018-11-11_11-46-27.png


If the value is BASIC , change it to TYPICAL to enable automatic AWR collection.

2. Select suitable retention period for AWR. In following example we are setting awr retention to 11520 minutes.

Code:
execute dbms_workload_repository.modify_snapshot_settings (interval => 60,retention => 11520);

upload_2018-11-11_11-50-51.png
Author
admin
Views
79
First release
Last update
Rating
0.00 star(s) 0 ratings

More resources from admin