Hi,

I am working on a datawarehouseing project and currently developing load processes. We use SQL ( direct) to move data to staging tables & then PL/SQL procedure to insert/update data in main tables. The tables along with indexes are with logging option and DB is running in archivelog mode.

There is too much redo log generation. In on test it was about 5.5 of data size ( data size 72 MB ( num_rows*avg_row_len)) and redo generated was 370 MB. In another test, the data size was 52 MB and redo 1.5 GB!

Even if you consider that there is redo for DML on tables , indexes and entries generated for RB segments for these DML, do you not think such sizes ( specially 30 times) too high?

How is it possible to reduce redo without turning to NOLOGGING?

TIA.