This procedure was adapted from the standard STATSPACK
"sppurge.sql" script that comes with v8.1.7 STATSPACK. I
haven't tested it fully in v9 STATSPACK yet. It works, but
I don't know if it purges everything -- I think that it does
though. STATSPACK has ON DELETE CASCADE constraints
enabled, so it's pretty self-sufficient...
>
> Seema:
> Head to Tim Gorman's site (www.evdbt.com) and find his
> sppurpkg.sql download. It uses dbms_jobs to run with a
> purge each set number of days. It's really slick.
> Barb
> Seema Singh <oracledbam_at_hotmail.com> wrote:Hi
> How to clean all old STATSPACK data?
> Thx
> -Seema
>
>
>
>
>
> __________________________________________________________
> _______ STOP MORE SPAM with the new MSN 8 and get 2 months
> FREE* http://join.msn.com/?page=features/junkmail
>
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com --
> Author: Seema Singh
> INET: oracledbam_at_hotmail.com
>
> Fat City Network Services -- 858-538-5051
> http://www.fatcity.com San Diego, California -- Mailing
> list and web hosting services
> ----------------------------------------------------------
> ----------- 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).
>
>
> ---------------------------------
> Do you Yahoo!?
> Yahoo! Mail Plus - Powerful. Affordable. Sign up now
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: tim_at_sagelogix.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
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 Dec 09 2002 - 11:59:19 CST
