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 <[EMAIL PROTECTED]> 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: [EMAIL PROTECTED] > > 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: [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). > > > --------------------------------- > Do you Yahoo!? > Yahoo! Mail Plus - Powerful. Affordable. Sign up now -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] 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: [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).
