Erik - I'm suggesting that you may be looking at the issue from the spreport.sql perspective. Spreport just compares the performance between two distinct snapshots. Rather than automating this report, consider a fresh approach. If you collect snapshots at regular intervals, then you have a wealth of statistics stored in your STATSPACK tables. Consider direct queries against these tables to measure performance trends over time. In Don Burleson's book he has many scripts that will produce trend reports. And you can modify these scripts to suit your needs. Take a look at his book, and I think you'll be pleased with his approach.
Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -----Original Message----- Sent: Thursday, August 29, 2002 7:58 AM To: Multiple recipients of list ORACLE-L I have the collections of snapshots scheduled in DBMS_JOBS, but I was looking for a way to automate running of the reports from these snapshots. It looks as though there is no easy way to do this. Thanks for the quick responses. Erik -----Original Message----- Sent: Wednesday, August 28, 2002 3:49 PM To: Multiple recipients of list ORACLE-L Erik - Two thoughts for you. 1) If you are looking at regular collection of STATSPACK statistics, take a look at Don Burleson's book Oracle High-Performance Tuning with STATSPACK. He offers many scripts for reporting on selected STATSPACK statistics over time, rather than just point in time reports. The statsauto.sql script starts hourly data collection, but you can modify the parameter it uses to submit the dbms_job to collect statistics on more frequent intervals. 2) If you really need to enable the users to trigger a STATSPACK snapshot at a point in time, like the database is really dragging, you could create a small script that would log into a special username and EXECUTE STATSPACK.SNAP. I have even investigated creating a Web page with Java code where they could just click on a button to trigger the STATSPACK snapshot. -----Original Message----- Sent: Wednesday, August 28, 2002 11:52 AM To: Multiple recipients of list ORACLE-L I would like to schedule the creation of statspack reports with DBMS_JOBs. The statsrep.sql script does not take any arguments and seems to require user interaction. Has anyone here tried to automate the creation of these reports? I am being asked to produce these reports by other people in my group who do not have access to the database. I am hoping that there is a way to automate this. Erik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Erik Williams INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Erik Williams INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
