Session ID: 1621


Redo generation is a vital part of the Oracle recovery mechanism. Without it, an instance will not recover when it crashes and will not start in a consistent state. Excessive redo generation is the result of excessive work on the database. This presentation covers the subject of reducing redo generation using LOGGING and NOLOGGING options, the differences between them, how it happens, how to reduce it and when to use.

Objective 1: Learn the main differences of LOGGING and NOLOGGING modes

Objective 2: Learn how to use LOGGING and NOLOGGING modes and their impact on recoverability and performance

Objective 3: Learn some best practices and tips regarding this topic.

Audience: In-Depth