Posts

Showing posts from October 8, 2013

Oracle 10g:Automate AWR reports to get in mail attachment.

Image
Automate Automatic Workload Repository Report in a mail Every time go to database and collect reports is old fashioned way.Now, Lets do some automated work for oracle workload reports. This is required when number of databases and also we all lazy to avoid see reports everyday.So it is better to make one schedule who will send us yesterdays all working day awr report in one single mail where just need to see if anything problematic in off -office hours. Simple and easy way creating one single procedure and schedule by scheduler. lets do some coding. 1.Create directory for parameters file for awrpt input parameters. --Report Type, --Num days --Begin snapshot id --End snapshot id --Reporrt Name This is the mandatory report parameter needs to generate awr report. 2.Create stored procedure. --Change directory name  --Get host_command from one of blog post. --set report path CREATE OR REPLACE PROCEDURE SYSTEM.USP_AUTOMATE_AWR