My Oracle Support Banner

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

Last updated on JULY 03, 2024

Applies to:

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

Symptoms

On : 12.1.3.9.1 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
~~~~~~

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


Cause

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
Symptoms
Cause
Solution
References


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