What does Nologging mean in Oracle?
What does Nologging mean in Oracle? LOGGING/NOLOGGING helps manage enabling direct path writes in order to reduce the generation of REDO and UNDO. It is one of several ways to control the delicate balance between recoverability and performance. Oracle Architecture Background Information. REDO is how Oracle provides durability, the "D" in ACID. What is Nologging in SQL? The nologging option is a great way to speed-up inserts and index creation. It bypasses the writing of the redo log, significantly improving performance. However, this approach is quite dangerous if you need to roll-forward through this time period during a database recovery....