This event has ended. View the official site or create your own event → Check it out
This event has ended. Create your own
Sydney Oracle Meetup and APACOUC welcome you to the first Sydney OTN Day (Part of the 5th APAC OTN Tour).
View analytic
Monday, November 30 • 15:20 - 16:05
Logging or Nologging: That is the question! with Francisco Alvarez LIMITED

Sign up or log in to save this to your schedule and see who's attending!

Limited Capacity seats available

The main question about NOLOGGING I hear all the time is: does creating a table with the NOLOGGING option means there is “no generation of redo ever”, or just that the initial creation operation has no redo generation, but that DML down the road generates redo? How and when can the NOLOGGING option be employed?

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.

avatar for Francisco Munoz Alvarez

Francisco Munoz Alvarez

Vice President for Asia Pacific, Pythian
Francisco Munoz Alvarez has over two decades of experience in consulting, analysis, support, implementation, and migration of Oracle products. He is also an expert in most phases of a database life cycle, for example, development, stabilization, security, backup and recovery, tuning, installations, and data warehouse (ETL) with excellent implementation and support methodologies.He is an author and popular speaker at many Oracle conferences around... Read More →

Monday November 30, 2015 15:20 - 16:05
Main Room

Attendees (25)