Hi,
Is there a way to clear the information collected by the ANALYZE_WORKLOAD function? After running it with the "true" options several times I lost some of the recommendations that I had from the original run .
I'd like to clear the history and get back to the original recommendations from the first run if possible! Does anyone know how to do that?
ANALYZE_WORKLOAD
Moderator: NorbertKrupa
-
- Intermediate
- Posts: 149
- Joined: Mon Apr 30, 2012 10:04 pm
- Location: New York
- Contact:
Re: ANALYZE_WORKLOAD
Analyze workload is based on real load through the system so there is no way to go "back". You can clear it though the data collector and its control functions.