Re: Oracle 8i database size

Comments embedded ....

On Wed, 29 Sep 2004 10:29:50 +0200, Anton Dischner <nomail_at_nospam.org> wrote:

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

That's absurd! Commits should be used at the end of a logical unit of work, as defined by the business need. NOT arbitrarily thrown in after every dml command. Imagine a textbook case of moving money from one bank account to another ...

:trans_amt = 1000000
UPDATE accounts
SET acct_bal = acct_bal - :trans_amt
WHERE acct_num = '123';

<system crashes here>

UPDATE accounts
SET acct_bal = acct_bal + :trans_amt
WHERE acct_num = '456';

What happens when the system crashes?

And with your suggestion:

UPDATE accounts
SET acct_bal = acct_bal - :trans_amt
WHERE acct_num = '123';

COMMIT:
<system crash>

UPDATE accounts
SET acct_bal = acct_bal + :trans_amt
WHERE acct_num = '456';

Oopsies! You just lost a million dollars!

>Close unused sqlplus-sessions.
>

And how does this address the problem reported by the OP?

>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 - 07:31:17 CDT