Re: Deleting Statspack tables.

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).