I think the link above covers the topic much better than I can. But I will add that NOLOGGING does not mean that all DML transactions are not written to the online redo logs. This is a popular misconception. The document above clearly outlines what is not logged.
Dig Deeper on Oracle DBA jobs, training and certification
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.