| 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: Remove Statspack Snapshots
How are you using the 168 snapshots to gather information? I saw a tool out there that will turn your statspack info into a graphical representation. I would certainly hate pouring through tons of output from spreport.sql. I have my own performance monitor for watching most of this stuff. I have automated the ability to schedule a statspack snapshot. The report is processed automatically and sent to me via email. This allows me to do things like place a trigger on a job queue table for our ERP system that takes a snapshot before and after a specific job. A few minutes after the job runs I get a statpack report in my inbox. This way I can help diagnose problems with the job without constantly being in contact with the application consultants about when they will run the job next.
>-----Original Message-----
>From: Carle, William T (Bill), NLCIO [mailto:wcarle_at_att.com]
>Sent: Monday, September 24, 2001 6:25 AM
>To: Multiple recipients of list ORACLE-L
>Subject: RE: Remove Statspack Snapshots
>
>
>Hi,
>
> I take a snapshot every hour and delete the ones over a
>week old. So at
>any one time, I have 168 snapshots.
>
>
>Bill Carle
>AT&T
>Database Administrator
>816-995-3922
>wcarle_at_att.com
>
> -----Original Message-----
>Sent: Saturday, September 22, 2001 1:15 AM
>To: Multiple recipients of list ORACLE-L
>Subject: Remove Statspack Snapshots
>
>Anyone found a more efficient way to remove a statspack
>snapshot prior to
>8.17?
>
>
>***METALINK SAYS***
>
>7) How do I remove StatsPack snapshots that I am no longer
>interested in?
>
> This functionality is available in Oracle 8.1.7 using a
>script called
>
> sppurge.sql located in $ORACLE_HOME/rdbms/admin.
>
> In Oracle 8.1.6 you will need to contact Oracle Support for
>assistance. **YOU GOT TO BE KIDDING**
>
>Thanks,
>- Ethan Post
>- http://www.geocities.com/epost1
>
>---------------------------------------------------------------
>-------------
>--
>This e-mail is intended for the use of the addressee(s) only
>and may contain
>privileged, confidential, or proprietary information that is
>exempt from
>disclosure under law. If you have received this message in
>error, please
>inform us promptly by reply e-mail, then delete the e-mail and
>destroy any
>printed copy. Thank you.
>
>===============================================================
>=============
>==
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Post, Ethan
> INET: epost_at_kcc.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).
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Carle, William T (Bill), NLCIO
> INET: wcarle_at_att.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).
>
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: epost_at_kcc.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).Received on Mon Sep 24 2001 - 11:36:35 CDT
 |
 |