Session ID: 187


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. Also, you will find examples and tips regarding each one of them. Logging is crucial to ensure performance and recoverability of any Cloud or in premises environment.

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

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

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

Audience: Mid-Level