Not quite true that my stuff has been "moved"; just "copied". Think of "cp" instead of "mv" commands...
on 6/11/03 3:49 AM, Ranganath K at [EMAIL PROTECTED] wrote: > Hi John, > > Tim Gorman's site has been moved to http://www.sagelogix.com. So one > can find all the UNIX and SQL scripts in sagelogix.com rather than > evbdt.com. > > > Regards, > > Ranganath > > -----Original Message----- > Sent: Wednesday, June 11, 2003 2:00 PM > To: Multiple recipients of list ORACLE-L > > Tim Gorman has produced an excellent package sppurpkg.sql which > certainly does the business for me > It can be found at http://www.evdbt.com/sppurpkg.sql > > John > > -----Original Message----- > Sent: 11 June 2003 00:35 > To: Multiple recipients of list ORACLE-L > > > Version : 8.1.7.3. > > I am not sure how it is working for you just by deleting from > stats$snapshot and we do not have 8.1.6 here. > > > Thanks > > > -----Original Message----- > Sent: Tuesday, June 10, 2003 4:40 PM > To: Multiple recipients of list ORACLE-L > > > Reddy - You didn't mention your Oracle version. I am on 8.1.6 and I > don't > think those scripts are available there (sorry, busy day, no time to > research). So I just delete from stats$snapshot. It seems to remove data > from the associated tables just fine. First I select the snap_id and > snap_time from stats$snapshot to determine which snapshots to remove. It > runs slowly (because of all the child tables?), so I just remove a > hundred > or so at a time. > > Dennis Williams > DBA, 80%OCP, 100% DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > > > -----Original Message----- > Sent: Tuesday, June 10, 2003 2:15 PM > To: Multiple recipients of list ORACLE-L > > > Hello All, > We have a job ( shell Script ) which deletes from the statspack tables > every > Sunday, but uses SPPURGE.sql ( $ORACLE_HOME/rdbms/admin). Seems like it > is > not deleting all tables and hence causing the tablespace to grow. Does > anybody has a different approach which deletes all table without any > referential integrity issues ?? > > I do not want to use SPTRUNC.sql please. > > Pl find below some of the statspack tables are growing so big ( also > Indexes > /PKs ). > > STATS$BG_EVENT_SUMMARY 7 > STATS$ROWCACHE_SUMMARY 8 > STATS$SGASTAT 8 > STATS$LATCH_PARENT 10 > STATS$SYSTEM_EVENT 19 > STATS$ROLLSTAT 37 > STATS$LATCH 50 > STATS$SYSSTAT 51 > > TABLE Size in MB > ------------------------------ ---------- > STATS$PARAMETER 56 > STATS$LATCH_MISSES_SUMMARY 84 > STATS$SQLTEXT 122 > STATS$FILESTATXS 234 > STATS$SQL_SUMMARY 886 > STATS$LATCH_CHILDREN 2872 ( These are just tables , > didnt > show indexes here) > > Thank You , > Madhu Reddy > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman 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).
