Re: Oracle 8i database size

From: Anton Dischner <nomail_at_nospam.org>
Date: Wed, 29 Sep 2004 10:29:50 +0200
Message-ID: <290920041029502069%nomail@nospam.org>

Hi,

if your rollback tablespace gets too large make shure you do a commit statement after each dml-command (insert, update, delete).

Close unused sqlplus-sessions.

regards,

Toni

In article <27aae5ab.0409280705.4f9641db_at_posting.google.com>, captain <captain_2010_at_yahoo.com> wrote:

> 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
Received on Wed Sep 29 2004 - 03:29:50 CDT