After Applying VCP 12.1.3.9 or VCP 12.1.3.9.1 Patching MSRFWOR - Refresh Collection Snapshots Performance /Hangs And Will Not Complete (Doc ID 1591417.1)

Last updated on OCTOBER 04, 2021

Applies to:

Symptoms

Refresh Collection Snapshots with refresh mode of Complete has been running for over 48 hours without completing..

Trace files shows
-----------------------
BEGIN MRP_CL_REFRESH_SNAPSHOT.REFRESH_SNAPSHOT(:errbuf,:rc,:A0,:A1,:A2,:A3);
  END;

call    count  cpu      elapsed    disk       query      current    rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse   1          0.01       0.00          0          0          0          0
Execute 1          0.34 1830.68            84       6304          6          0
Fetch   0          0.00       0.00          0          0          0          0
------- ------ -------- ---------- ---------- ---------- ---------- ----------
total   2          0.35 1830.68            84       6304          6          0


The following SQL was used to locate the request's temporary log file:

The above SQL allowed the DBA to locate the temporary log file for the Refresh Collection Snapshots request.

The contents looked like:

04-SEP 11:23:20 : The beginning of Refresh Snapshot
04-SEP 11:23:20 : Standalone RCS - no instance details
04-SEP 11:23:20 : Waiting for all other runs to finish

If your temporary log file contains these messages, then the solution delivered in the patch below will resolve the issue.

STEPS
1. Run Refresh Collection Snapshots

Changes

 Upgrade to  VCP 12.1.3.9 <Patch.16974659> or <Patch 17350769> - VCP 12.1.3.9.1 PATCH

Cause

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