Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Extensive SYSTEM-Tblspc growing!ß!

Re: Extensive SYSTEM-Tblspc growing!ß!

From: Pete Finnigan <pete_at_peterfinnigan.demon.co.uk>
Date: Fri, 24 Aug 2001 16:42:45 +0100
Message-ID: <e4JymiA1Xnh7EwMI@peterfinnigan.demon.co.uk>


hi

is audit on ?, and sys.aud$ still in the system tablespace ?

cheers

pete finnigan
www.pentest-limited.com

In article <3B860D2A.7D84CB56_at_vie.ce.philips.com>, R. Schicht <schicht_at_vie.ce.philips.com> writes
>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
>

-- 
Pete Finnigan
IT Security Consultant
PenTest Limited

Office  01565 830 990
Fax     01565 830 889
Mobile  07974 087 885

pete.finnigan_at_pentest-limited.com

www.pentest-limited.com
Received on Fri Aug 24 2001 - 10:42:45 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US