Re: Tablespace SYSTEM grows too much

From: Kenneth C Stahl <BluesSax_at_Unforgettable.com>
Date: Tue, 07 Sep 1999 08:55:02 -0400
Message-ID: <37D50B25.2EA8E14@Unforgettable.com>

Jorge wrote:

> Hi Everybody,
> I have a Replication environment between almost 50 machines whith one
> server, and tablespace for DATA is not bigger than 200 Mgbytes but SYSTEM
> tablespace is almos 1 Gb, so what is happenig whit it???
> anybody knows about it??
> thans a lot

Do you have any accounts other than SYS and SYSTEM which have a DEFAULT tablespace of SYSTEM? Do you have any users other than SYS and SYSTEM which have any quotas on the SYSTEM tablespace? Do you have rollback segments other than the SYSTEM rollback segment in the SYSTEM tablespace? Do you have large amounts of large stored procedures/packages? All of these things can affect SYSTEM tablespace usage. Received on Tue Sep 07 1999 - 07:55:02 CDT