11.5.10 MSRFWOR: Refresh Collection Snapshot Performance Is Poor and Fails with Errors (Doc ID 306418.1)

Last updated on DECEMBER 13, 2016

Applies to:

Oracle Advanced Supply Chain Planning - Version 11.5.10 and later
Information in this document applies to any platform.
MSRFWOR
***Checked for relevance on 16-Jan-2014***


Symptoms

After upgrading to 11.5.10 and gathering Schema Statistics, the customer reports that the performance is very bad for refreshing collections snapshots when running the Memory Based Planner.

Additionally, the logfile shows:

MSRFWOR module: Refresh Collection Snapshots
 
ORA-12008: error in materialized view refresh path
ORA-01555: snapshot too old: rollback segment number 1 with name "_SYSSMU1$" too small
ORA-12034: materialized view log on "BOM"."BOM_OPERATIONAL_ROUTINGS" younger than last refresh

The degree of parallelism for Refreshing snapshots is set to:  0
Error in refresh snapshot program : ORA-12034: materialized view log on "BOM"."BOM_OPERATIONAL_ROUTINGS" younger than last refresh
Refreshing all snapshots in Complete Refresh mode
ORA-12008: error in materialized view refresh path
ORA-01555: snapshot too old: rollback segment number 1 with name "_SYSSMU1$" too small
ORA-12034: materialized view log on "BOM"."BOM_OPERATIONAL_ROUTINGS" younger than last refresh
ORA-12008: error in materialized view refresh path
ORA-01555: snapshot too old: rollback segment number 1 with name "_SYSSMU1$" too small
ORA-12034: materialized view log on "BOM"."BOM_OPERATIONAL_ROUTINGS" younger than last refresh

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms