Anwer to the query
Rahul, July      28, 2025 - 8:40 pm UTC
 
 
Hi,
Thanks for the response.
I have queried my old 12c database and it has:
SUPPLIMENTAL_LOG   FORCE_LOGGING
-----------------------    --------------------
NO                                     YES
On my new 19c database:
SUPPLIMENTAL_LOG   FORCE_LOGGING
-----------------------    --------------------
NO                                     NO
Is this what is expected? I thought it should the the other way round... 
July      29, 2025 - 12:24 pm UTC 
 
Well those are your settings - it doesn't really matter what they "should" be. Are these settings for the CDB or PDB? Enabling these in a CDB also enables these in a PDB.
If this still doesn't explain the difference, then you'll have to start looking at the session stats to see what is generating so much redo.