Re: Tablespace SYSTEM grows too much
Date: Tue, 07 Sep 1999 16:51:46 GMT
Message-ID: <7r3fqt$p5k$1_at_nnrp1.deja.com>
you may also want to check to see if you have auditing enabled. Check to see if there is anything stored in the SYS.AUD$ table.
In article <37D50B25.2EA8E14_at_Unforgettable.com>,
BluesSax_at_Unforgettable.com wrote:
> 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.
>
>
Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't.
Received on Tue Sep 07 1999 - 18:51:46 CEST