Skip to Main Content
  • Questions
  • Excessive redo generation after upgrade from 12c to 19c

Breadcrumb

Question and Answer

Chris Saxon

Thanks for the question.

Asked: July 28, 2025 - 4:20 am UTC

Last updated: July 29, 2025 - 12:24 pm UTC

Version: 19c

Viewed 1000+ times

You Asked

Hi,
I have just upgraded my database from 12c to 19c using expdp/impdp. Since upgrade I have tried to match all parameters from 12c.

We are facing excessive logging in the new 19c DB. Earlier it was about 6GB per day compared to almost 70GB now. We are not using any materialized views.
Please can you guide if there are any new parameters or features that I need to change/tweak in 19c? The application connecting to the DB is exactly the same with no code changes.

I have already set db_lost_write_protect to none and temp_undo_enabled to true.

Thanks in advance,
Regards,
RD.

and Chris said...

I'm not aware of new features from 12c -> 19c that would cause this increase. A couple of existing candidates come to mind though:

The 19c database has supplemental logging enabled, the 12c one didn't
The 19c database has force logging, the 12c didn't and had (lots) of NOLOGGING statements

You can check these settings by querying v$database:

select supplemental_log_data_min, force_logging from v$database;


If that doesn't explain it, then you can find which sessions are generating lots of redo by querying:

select * from v$sesstat
join   v$statname
using ( statistic# )
where  display_name like 'redo size';


Then drilling into the details of what these are doing and diagnosing from there.

Rating

  (1 rating)

Comments

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...
Chris Saxon
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.

More to Explore

Data Pump

All of the database utilities including Data Pump are explained in the Utilities guide.