Refresh Collection Snapshots - performance issue for the Atomic Refresh

(Doc ID 2105282.1)

Last updated on JUNE 28, 2017

Applies to:

Oracle Advanced Supply Chain Planning - Version 12.1.3 and later
Information in this document applies to any platform.


On : version, Data Collections

Issue :

After all the programs 'Create XXX snapshot' end, the MSRFWOR program 'Refresh Collection Snapshots' still runs for 20 minutes.
The performance issue is at atomic refresh of all the snapshots , as seen below :
10-SEP 00:07:42 : Doing a force refresh of all snapshots...
10-SEP 00:07:42 : lv_snapshot_str: AHL_SCH_MTLS_SN ... MTL_ITEM_CATS_SN
10-SEP 00:07:42 : lv_refresh_param:
10-SEP 00:07:42 : lv_DEGREE: 0
10-SEP 00:25:28 : Done with update complete refresh MViews timestamp

Why is the atomic refresh takes so long compared to all the individual SN refresh , which all take up to 6 minutes.


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