You can find this report in the following location.
%ORACLE_HOME%\rdbms\admin\spreport
Regs,
Sree
-----Original Message-----
From: thirupal
[mailto:oracledba-ezmlmshield-x97883775.[Email address protected]
Sent: Wednesday, November 30, 2005 9:38 PM
To: LazyDBA Discussion
Subject: RE: stats report automation script
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.
--------
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
DISCLAIMER:
This email (including any attachments) is intended for the sole use of the intended recipient/s and may contain material that is CONFIDENTIAL AND PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or distribution or forwarding of any or all of the contents in this message is STRICTLY PROHIBITED. If you are not the intended recipient, please contact the sender by email and delete all copies; your cooperation in this regard is appreciated.
Oracle LazyDBA home page