Turn
...
remove or turn off
...
supplemental
...
logging at the database level
| No Format | ||
|---|---|---|
| ||
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
| No Format | ||
|---|---|---|
| ||
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; |