Re: Disabling ARCHIVELOG problem

Why are you disabling archive? Are you trying to reduce the amount of redo to save space or time?

Disabling archive is a bad idea. I think you should look for another way to reduce redo.

1. Use hints for inserting to avoid redo.

    insert /*+ append */ into mytable ........;

2. use SQLLDR with unrecoverable option to insert bulk data.

3. Disable indexes before process and rebuild when done.

4. Update only columns that change not the whole row.

5. Tune the SQL in batch jobs. Received on Tue Aug 31 2004 - 16:11:41 CDT