admin submitted a new resource:
Modify AWR Automatic Snapshot Settings - Configure awr settings for your database
Read more about this resource...
Modify AWR Automatic Snapshot Settings - Configure awr settings for your database
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
View attachment 170
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...
Read more about this resource...