Hi, I'm doing direct load inserts of a table with 9.5Mio recs in
nologging mode.
I still get quite large archive logs: 4GB.
In the manual I only found the following:
In this mode, Oracle inserts data without redo or undo logging. (Some
minimal logging is done to mark new extents invalid, and data
dictionary changes are always logged.)
It's much faster than doing the same with logging and I guess that the
log files would come up to about 15GB in that case.
Does anyone now more about what oracle writes to the logs with
nologging and how this size could be calculated?
I appreciate your answer
Received on Fri Jan 27 2006 - 06:01:17 CST
