Refresh Collection Snapshots Running Long After DB Upgrade to 19c 

Reason:

In 19c Database parameter _mv_refresh_shrink_log was set to TRUE.
This caused the following command to be run.

ALTER TABLE "ONT"."MLOG$_OE_ORDER_LINES_ALL" SHRINK SPACE




Solution


1.  Execute the following command on the EBS instance

alter system set "_mv_refresh_shrink_log" = FALSE;

 2.  Retest the program




If you like please follow and comment