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.