Search This Blog

Tuesday 20 November 2012

RDA AWR Report

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