Versions Compared

Old Version 1

changes.mady.by.user Arjen Visser

Saved on

compared with

New Version 2

changes.mady.by.user Arjen Visser

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Turn

...

remove or turn off

...

supplemental

...

logging at the database level

Section
Column
width1%

 

Column
width99%
Panel
bgColorCCC
SQL> alter database drop supplemental log data;

Supplemental logging can also be turned on per table. Use the following query to determine what has been turned on to disable

Section
Column
width1%

 

Column
width99%
Panel
bgColorCCC
SQL> SELECT supplemental_log_data_min MIN, supplemental_log_data_pk PK, supplemental_log_data_ui UI, supplemental_log_data_fk FK,supplemental_log_data_all "ALL" FROM v$database;