More archive generation after upgrade 11G to 19C and MV refresh is taking a longer time
Hello,
we have upgrade our one of the database from 11G to 19C (19.9). But after the upgrade one MV refresh which used to take 15-20 minutes on 11G is taking close to 2 hours on 19C. and also during this MV refresh process the archive log files which were only generated 35-40 max not are generating more than 110. Any idea what is cause and how this can be resolved?