Hi,
just doing abit of researching.
There are times when customer won't ask to have a awr that is older then the retention period.
The retention period is set as 31 days.
So i can't possible retrive an awr that has pass the retention period.
Do u guys use a script to generate the awr and keep it and use a os script to housekeep the reports.
But what happen if they are asking a shorter range of time then those timing you have fix to collect the awr for archiving?