The scripts below save you from having to type the same old commands in again and again to create AWR and ADDR reports. You can call this script via a CGI script from a browser, you will get a link back to the actual report which you can then open in a browser.

The mkawrrpt.sh script makes an AWR report for a given cluster. 

	usage: mkawrrpt.sh [-s] [-h] [-u userid] [-p password] [startsnapid endsnapid]
	-s       - list snap ids
	-h       - HTML output

The mkaddmrpt.sh script makes an ADDR report for a given cluster. 

	usage: mkaddmrpt.sh [-s] [-h] [-u userid] [-p password] [startsnapid endsnapid]
	-s       - list snap ids
	-h       - HTML output

You will need to modify both of these scripts for your purposes as there are specific assumptions on naming standards related to the clusters that may differ in your environment.
view mkawrrpt.sh or download mkawrrpt.sh
view mkaddmrpt.sh or download mkaddmrpt.sh


For more on Oracle Performance Reporting look here

Home