Re: ARCHIVELOG and large number of inserts.

Can you change your strategy from

    'insert and update'
to

    'create as select'

If so switch the tablespace to NOLOGGING, and use the NOLOGGING options for creating tables and indexes. This avoids the generation of redo log.

There is also a parallel DML insert option available in 8.0, which allows you to do NOLOGGING inserts, but you may have to go for a more expensive license to do that.

--

Jonathan Lewis
Yet another Oracle-related web site: www.jlcomp.demon.co.uk

Yann Doussot wrote in message ...
> I'm using Oracle 8.05 (standard edition) and seeking some help
>on backup strategy. I want my DB avaible 24H/24, so according to the docs,
>the only solution for me is to use ARCHIVELOG mode and hot backup. But,
>once a day, I fill DB with ~1.000.000 lines, do lot of updates, queries,
...
>and then delete the whole table. These operations generate a lot of redo
log
>files. Datas used is this temporary table are not critical, I can afford to
>loose them.
Received on Fri Mar 12 1999 - 09:20:57 CST