Logging or no logging, that's the question

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.

Detalji o predavanju

Vrsta: Predavanje / Lecture

Razina težine: Vrlo detaljno i stručno / Expert

Poželjno iskustvo slušatelja: Iskusni (2-3 g.) / Experianced

Poželjna funkcija slušatelja:
Krajnji korisnik / End User
DBA

Predviđeno vrijeme trajanja rada - aktivnosti: 30 min

418_Munoz_Logging.pdf 1,18 MB

O predavaču

Francisco Munoz Alvarez

Oracle DBA Director

Francisco Munoz Alvarez is an Oracle ACE Director. He is the founder and CEO of DBIS - Database Integrated Solutions and has worked with Oracle since 1989.
He is also the President and Founder of CLOUG (Chilean Oracle Users Group) , President of LAOUC (Latin American Oracle Users Groups Council) and a member of NZOUG.
Francisco worked as associate technologist at Oracle Brazil and Chile, was an Oracle instructor for New Horizons Center, Chile and for Oracle education (Brazil and Chile), and also worked on the first team to introduce Oracle to South America (Oracle 6 and Beta version of Oracle 7). He was also the first Master Oracle 7 Database Administrator in South America.
Oracle Certification Levels: OCA (SQL & PL/SQL, 10g AS), OCP (10g DBA, E-Business 11i) and 10g RAC OCE.