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.
- Ethan Post
- http://www.geocities.com/epost1
>-----Original Message-----
>From: Carle, William T (Bill), NLCIO [mailto:[EMAIL PROTECTED]]
>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
>[EMAIL PROTECTED]
>
> -----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: [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: Carle, William T (Bill), NLCIO
> 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).
>
------------------------------------------------------------------------------
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: [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).