My requirement is, if I pass the snap ids and report name ...the script
needs to be generate sp report for given snap ids.

Thanks & Regards,
Thirupal Reddy.

-----Original Message-----
From: Shergill Gurmohan
[mailto:oracledba-ezmlmshield-x20697499.[Email address protected]
Sent: Wednesday, November 30, 2005 9:07 PM
To: LazyDBA Discussion
Subject: RE: stats report automation script

What is it you are looking for creating stats or creating report from
stattab table?

If it is creating a report from the stattab table it is a matter of only
choosing what you need to print, and if it is generating stats then I
can give you a sql script - actually generating stats and a shell script
causing the sql script to execute. Then you can schedule a cron job for
its execution. Or, you can go the different way, of executing the sql
script through a dbms job.

Gurmohan
www.onlymath.com - Place to learn and teach math.




-----Original Message-----
From: thirupal
[mailto:oracledba-ezmlmshield-x68097229.[Email address protected]
Sent: Wednesday, November 30, 2005 10:11 AM
To: LazyDBA Discussion
Subject: stats report automation script




Hi,

Any body is having stats report automation script.


If we pass the parameters begin and end snap id and report name it will
automatically generates stats report.

Thanks in advance.



Confidentiality Notice


The information contained in this electronic message and any attachments
to this message are intended
for the exclusive use of the addressee(s) and may contain confidential
or privileged information. If
you are not the intended recipient, please notify the sender at Wipro or
[Email address protected] immediately
and destroy all copies of this message and any attachments.


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html




Confidentiality Notice

The information contained in this electronic message and any attachments to this message are intended
for the exclusive use of the addressee(s) and may contain confidential or privileged information. If
you are not the intended recipient, please notify the sender at Wipro or [Email address protected] immediately
and destroy all copies of this message and any attachments.

Oracle LazyDBA home page