Supplemental logging question
We need to replicate data for one table from one Oracle DB to another DB.
Do we know what is the overhead of enabling supplemental logging, most of the documents say that enabling minimal logging is not a significant overhead but I have a push from the DBA on this saying it causes overhead even though in this case it is going to be one table,DB size is 40TB
I guess following are the 2 commands that I need to execute:-
ALTER DATABASE ADD SUPPLEMENTAL LOG DATA -- Enable minimal supplemental logging for the complete database
ALTER TABLE CUSTOMER ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS -- Enable logging for the required table