Versions Compared

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 No Format
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 No Format
bgColorCCC
SQL> SELECT 
SELECT supplemental
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;

 

...