Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Deleting Statspack tables.
I know there are some versions that the sppurge doesn't remove rows from
the children tables. I haven't noticed this since I got to 8.1.7.3 on
Tru64. You can write a script to delete from the other tables where
they don't have a record in the parent table and run it the same time as
SPURGE.
Stephen
>>> [EMAIL PROTECTED] 06/10/03 12:14PM >>>
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: Reddy, Madhusudana 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Andert 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).Received on Tue Jun 10 2003 - 14:26:47 CDT