RE: Index in SUMDELTA$

From: Robertson Lee - lerobe <>
Date: Mon, 22 Jun 2009 16:35:07 +0100
Message-ID: <>

OK, took the bull by the horns and a rebuild of the index did the trick
(down to 1Mb now). Would still be interested in any opinions on what may
be happening.  


From: Robertson Lee - lerobe
Sent: 22 June 2009 13:11
Subject: Index in SUMDELTA$


Oracle 10gR2
AIX 6   Got alerted that our SYSTEM tablespace was getting full and on checking the space taken up by the objects in there noticed that we have an index
(IN_SUMDELTA$) on the table SUMDELTA$, taking up 344Mb of SYSTEM
tablespace. The table is only 55Mb.
I don't know too much about this but a quick google showed me that it is tied to materialized views. Not much out there on Google other than that and I don't have access to Metalink at the moment as our SAC has changed and I am awaiting authorization.  

I can see that there are a few bugs around about the table not clearing down on refreshes of the MV but nothing with regards to the index. Any advice or links to articles would be much appreciated. I am reluctant to rebuild the index on one of these "SYSTEM" tables.  


The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged.

If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited.

If you have received this communication in error, please resend this communication to the sender and delete the original message or any copy of it from your computer system.

Thank you.

Received on Mon Jun 22 2009 - 10:35:07 CDT

Original text of this message