My Oracle Support Banner

Refresh Collection Snapshots - performance issue for the Atomic Refresh (Doc ID 2105282.1)

Last updated on JANUARY 23, 2023

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.


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.