Friday, November 2, 2012

Script to generate AWR automatically using Crotab utility

I have created a script which will take out a Performance reports like AWR/ASH automatically which means you don't need to login into the Database through SQL command prompt.
Also You can schedule this job based on your requirement.

Below are the link to download the AWR/ASH script.

AWR Script

Below are the script view.


































Here in my AWR script, I have took the ORACLE_SID of one node and Begin/End time according to my necessity, you can change it according to you ease.

Now running this script through crontab scheduler.

Let me give a brief idea about Cron job.

Crontab Commands

crontab -e    Edit your crontab file, or create one if it doesn’t already exist.
crontab -l    Display your crontab file.
crontab -r    Remove your crontab file.

 

Crontab file
Crontab syntax :
A crontab file has five fields for specifying day , date and time followed by the command to be run at that interval.


*     *     *   *    *        command to be executed
-     -     -   -    -
|     |     |   |    |
|     |     |   |    +----- day of week (0 - 6) (Sunday=0)
|     |     |   +------- month (1 - 12)
|     |     +--------- day of        month (1 - 31)
|     +----------- hour (0 - 23)
+------------- min (0 - 59)

* in the value field above means all legal values as in braces for that column.
The value column can have a * or a list of elements separated by commas. An element is either a number in the ranges shown above or two numbers in the range separated by a hyphen (meaning an inclusive range).


Notes

 
A.)Repeat pattern like /2 for every 2 minutes or /10 for every 10 minutes is not supported by all operating systems. If you try to use it and crontab complains it is probably not supported.

B.) The specification of days can be made in two fields: month day and weekday. If both are specified in an entry, they are cumulative meaning both of the entries will get executed.

1 comment:

  1. Hi Rahul , can you post awr script here , im unable to open you awr script

    ReplyDelete