Oracle Database - NOLOGGING

Card Puncher Data Processing

About

A table of a statement marked as NOLOGGING will bypass the Oracle Database - Redo Log (Transaction Log Files) generation.

Just setting a table to NOLOGGING does not mean that all redo is prevented against this table.
Only certain, Data Processing - (Batch|Bulk) Processing operation, such as direct path insert, will not be logged in the normal fashion. All other operation such as insert, update, delete and merge, will be logged as normal.

DDL

alter table big_table nologging;

Recovery

The operation will not be logged and then you prevent the redo log to be generated. It's not in the archive log and it cannot be recovered.





Discover More
Card Puncher Data Processing
Oracle Database - Data Loading Hint

The PL/SQL data loading procedures use the following HINTS for performance. They are /+ APPEND NOLOGGING PARALLEL / Append: - When “Append” hint is used in a PL/SQL INSERT statement, Oracle will...
Card Puncher Data Processing
Oracle Database - Direct (path insert|load) (/*+ APPEND */)

A direct-path insert is also known as: direct load A direct-path insert is a bulk operation which will only bypass redo log generation in three cases : the database is in NOARCHIVELOG mode database...
Card Puncher Data Processing
Oracle Database - How to bypass the redo log generation ?

A direct path insert will only bypass Redo Log generation in two cases : the database is in NOARCHIVELOG Mode the operation is performed on a table marked as NOLOGGING The insert /+ APPEND / will...
Card Puncher Data Processing
Oracle Database - Table Logging Mode (LOGGING, NOLOGGING)

The logging mode of the target table (LOGGING, NOLOGGING) is what will dictate whether redo log is generated for the table or not. A table marked as LOGGING will generate redo in the while a table...
Card Puncher Data Processing
Oracle Database - Temporary Datafiles (tempfiles)

Tempfiles are a special class of datafiles that are associated only with temporary tablespaces. Locally managed temporary tablespaces have temporary datafiles (tempfiles), which are similar to ordinary...
Card Puncher Data Processing
Oracle Database - Why you have still a lot of redo and archive ? The Index side effect.

You use the direct path insert and set the logging mode as NOLOGGING but you have still a lot of redo log generated. Why ? The answer is that you have an index on the table, and the index cannot just...



Share this page:
Follow us:
Task Runner