Turn remove or turn off supplemental logging at the database level
Section |
---|
Column | ||
---|---|---|
| ||
|
width | 99% |
---|
bgColor | CCC |
---|
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 | ||
---|---|---|
| ||
|
width | 99% |
---|
bgColor | CCC |
---|
SQL> SELECTSELECT
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;
...