Slow Materialized View Refresh After Upgrading Materialized View database To 19C
(Doc ID 2766301.1)
Last updated on APRIL 17, 2023
Applies to:Oracle Database - Enterprise Edition - Version 22.214.171.124.0 and later
Information in this document applies to any platform.
or Public Documentation delivered with an Oracle database product. Any similarity to actual persons, living or dead, is purely coincidental and not intended in any manner.
You are having issues while refreshing some materialized views on the database after its upgrade from 126.96.36.199 to 19C. There is one materialized view refresh session which is waiting for "db file sequential read" while executing an insert on the materialized view itself, on the remote site(materialized view log) you see the corresponding session with ACTIVE status waiting for "SQL*Net more data to client".
The refresh process is taking too much time and enabling trace 10046 level12 on the session refreshing the mview you see lots of messages like these:
The materialized view site upgraded from 11204 to 19C
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document