Solution : https://service.sap.com/sap/support/notes/1326067 (SAP Service marketplace login required)
Summary :
This SAP Note explains the configuration process for the retention period and snapshot interval of performance data in the Automatic Workload Repository (AWR) for Oracle databases. It covers the default settings, which keep AWR data for seven days, with a recommendation for crucial SAP systems to extend this to at least 42 days for effective performance analysis. Detailed instructions are provided on how to adjust the retention period, check and possibly extend the SYSAUX tablespace, and modify snapshot settings for more granular performance analysis. Further references include Notes 853576, 974781, 1028068, 828268, and 1149771.
Key words :
sysdbasql>define num_days = 42select retention, sql>define snap_interval=30select to_char, system retains awr performance data, 'yyyy-month-dd hh24, automatic workload repositorydba_hist_wr_control reason, symptom automatic workload repository, automatic workload repository, awr performance data, important sap systems, monthly closings based
Related Notes :
| 1149771 | AWR: Retention time and interval settings |
| 828268 | Oracle Database 10g: New functions |