System Tablespace gone mad!

From: Richard Q Woodland <richwoodland_at_magicinterface.com>
Date: Thu, 01 Nov 2001 12:23:26 -0500
Message-ID: <3BE1850E.5CF6F16C@magicinterface.com>

A few days ago, the system tablespace on our development server filled-up, and hit a half gig. At that time, we doubled the system tablespace to over a gig. Today, it's back to being filled up.

The load on this server, and the amount of development work being done has not changed in any significant way over this period of time.

The chief space hogs in system seem to be SYS.IDL_UB2$ (500+ Mb) and SYS.I_SOURCE1 (614Mb).

I can't imagine what a handful of users could possibly generate enough PL/SQL source code to consume a half gig in three days!!

Can anybody think of a scenario which might cause these two entities to start to ballon in size?

Thanks (in advance) for any comments!

Rich Woodland.
Magic Interface, Ltd. Received on Thu Nov 01 2001 - 11:23:26 CST