Specifying FORCE LOGGING Mode

Some data definition language statements (such as CREATE TABLE) allow the NOLOGGING clause, which causes some database operations not to generate redo records in the database redo log.

project management training courses malaysia

The NOLOGGING setting can speed up operations that can be easily recovered outside of the database recovery mechanisms, but it can negatively affect media recovery and standby databases.

iot training courses malaysia

Oracle Database lets you force the writing of redo records even when NOLOGGING has been specified in DDL statements. The database never generates redo records for temporary tablespaces and temporary segments, so forced logging has no affect for objects.

itil training courses malaysia

• Using the FORCE LOGGING Clause
  You can force the writing of redo records even when NOLOGGING is specified in DDL statements.
• Performance Considerations of FORCE LOGGING Mode
  FORCE LOGGING mode results in some performance degradation.

devops training courses malaysia