Re: Extensive SYSTEM-Tblspc growing!ß!

From: Scott Watson <swatson_at_datachest.com>
Date: Fri, 24 Aug 2001 11:34:34 -0400
Message-ID: <Btuh7.53767$wZ3.4298338@news20.bellglobal.com>

Do you have rollback segments defined in this tablespace??? (Other than the system rollback of course)

Scott Watson.

"R. Schicht" <schicht_at_vie.ce.philips.com> wrote in message news:3B860D2A.7D84CB56_at_vie.ce.philips.com...
> What could be a reason for the SYSTEM-Tablespace to grow up very fast
> (05.2001 about 1GB -> today about 8GB)?!?
>
> It´s Oracle 8i (NT) with no auditing and pctincrease set on 50% for
> SYSTEM-TABLESPACE.
>
>
> I have made a simply query like
>
>
> select sum(bytes) from dba_segments where tablespace_name = 'SYTEM';
>
> brought me the knowledge there are only 38Megabytes in this
> Tablepace!!!!!
>
> The other miracle is, that the datafile is defined with 5,7GB in
> dba_data_files but on disk i habe a file with 8GB!!!
>
> Does anyone has an idea??
>
> Any idea and help would be appreciated
>
> Roman Schicht
>
Received on Fri Aug 24 2001 - 10:34:34 CDT