All right, now I understand you are looking for statspack report not stats as in statistics generated from using dbms_stats package. Someone, already seems to have rightly suggested you to use spreport.sql in /rdbms/admin directory off of your ORACLE_HOME. If I remember it now you need to give it the two ids, starting and ending based upon which it generates a report for you. You may develop the report using different start and end ids or same start and end ids [in this case oracle tells you about what was gathered in one go only].
If you want to automate this process I guess you will need to create a schedule [in crontab or dbms_job] and execute the process that runs statspack and gathers the statistics on performance of the system. Simultaneously from this script you may execute another script which will run the spreport.sql against the highest or latest id in the table holding statistics.
Gurmohan
www.onlymath.com - Place to learn and teach math.
-----Original Message-----
From: thirupal
[mailto:oracledba-ezmlmshield-x97883775.[Email address protected]
Sent: Wednesday, November 30, 2005 11:08 AM
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
Oracle LazyDBA home page