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: Oracle 8i database size

Re: Oracle 8i database size

From: Joel Garry <joel-garry_at_home.com>
Date: 29 Sep 2004 16:36:49 -0700
Message-ID: <91884734.0409291536.71da0c77@posting.google.com>


captain_2010_at_yahoo.com (captain) wrote in message news:<27aae5ab.0409280705.4f9641db_at_posting.google.com>...
> hi,
>
> My database size is increasing drastically everyday it consumes 1 GB.
> Actually database is not more than 200 MB. Do not know where it consumes.
>
> Archive file are increasing daily.
>
>
> CONTROL01/2/3.CTL 15 Mb
> INDX01.DBF 60 Mb
> RBS01.DBF 600 MB Max file
> SYSTEM01.DBF 400 Mb
> TEMP01.DBF 90 Mb
> TOOLS01.DBF 20 Mb
> USERS01.DBF 150 Mb
> REDO01/2/3.LOG 2 Mb
>
> What I need to do ? Please it is urgent. Space is running out.
>
> Regards,
>
> Captain

Are your tablespaces in hot backup mode?

What exactly is your app doing transactionally? I've found http://metalink.oracle.com/metalink/plsql/showdoc?db=NOT&id=875027.101 can be helpful for figuring things out.

Where phsycially is the 200M you are talking about? How exactly do you know about the 1GB?

http://metalink.oracle.com/metalink/plsql/ml2_documents.showFrameDocument?p_database_id=NOT&p_id=122669.1 can be helpful for generally seeing if things are in the ballpark.

jg

--
@home.com is bogus.
http://money.cnn.com/2004/09/22/technology/kumar/index.htm?cnn=yes
Received on Wed Sep 29 2004 - 18:36:49 CDT

Original text of this message

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