Huge archivelog generated in DB when loading data in BI.
We have observed that a huge log is being generated when ever theres a loading activity carried on BI.The log occupies huge Undo space.
Loaded 50 million recs in BI which generated 208 GB and undo space 117 GB at DB level.
So the concern is how to prevent such huge log being generated ? or are there any settings at BI that prevents generating huge Archive log at DB when ever theres huge load activity being performed ?
Pls suggest / inputs.