Here is a simple example how to generate RDA report that will include AWR report for specific time.
The commands:
PRF_START=$(date +"%d-%h-%Y_%H:%M" --date="yesterday")
PRF_END=$(date +"%d-%h-%Y_%H:%M")
./rda.sh -vCRP -e PERF_START_TIME=$PRF_START,PERF_END_TIME=$PRF_END OS DB DBA INST ONET PROF PERF
so if you will schedule a crontab task let's say to 1AM with the above commands then the RDA report would be include AWR report for last the 24 hours period.
That's it.
No comments:
Post a Comment