1. SPEForums need your contributions to build up a strong repository of performance engineering resources.

    Dismiss Notice
  2. Whatsapp Group For Software Performance Engineering Professionals!! Click here to get added . No Spam for strictly professional discussions only.
    Dismiss Notice
Dismiss Notice
Hello Guest,

Please reach out to us at admin@speforums.com/+91 8600177662 in case you face any issues with SPEForums. Share your feedback - Click Here

Please support us by sharing performance engineering tutorials/resources with SPEForums.com

-Crew

Modify AWR Automatic Snapshot Settings

Configure awr settings for your database

  1. admin
    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