Pages

Wednesday, June 8, 2022

When setting the table to NOLOGGING, what is the expected result?

When setting the table to NOLOGGING, what is the expected result?

The actual result would depend if database is in ARCHIVE MODE or not, and if the INSERT on table is in APPEND mode or not.

Table Mode  Insert Mode   ArchiveLog mode Result
----------- ------------- ----------------- --------------
LOGGING     APPEND   ARCHIVE LOG redo generated  NOLOGGING   APPEND   ARCHIVE LOG         no redo
LOGGING     NO APPEND   ARCHIVE LOG redo generated
NOLOGGING   NO APPEND   ARCHIVE LOG redo generated

LOGGING     APPEND   NOARCHIVE LOG MODE no redo
NOLOGGING   APPEND   NOARCHIVE LOG MODE no redo
LOGGING     NO APPEND   NOARCHIVE LOG MODE redo generated
NOLOGGING   NO APPEND   NOARCHIVE LOG MODE redo generated