| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Schedule Statspack Report Creation
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: ewilliams_at_brownco.com
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: ListGuru_at_fatcity.com (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).
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: ListGuru_at_fatcity.com (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). Received on Wed Aug 28 2002 - 14:48:34 CDT
 |
 |