Program 'APS Collections Refresh Snapshot Thread' Is Taking Longer And Log Shows Message Like '21-MAY 03:48:15 : Could not get lock, sleeping for 5 seconds' (Doc ID 2442712.1)

Last updated on SEPTEMBER 11, 2019

Applies to:

Symptoms

Data Collections

ACTUAL BEHAVIOR
---------------
Sometimes APS Collections Refresh Snapshot Thread waits and does not progress - log shows messages

21-MAY 03:48:15 : Could not get lock, sleeping for 5 seconds
21-MAY 03:48:20 : Could not get lock, sleeping for 5 seconds
21-MAY 03:48:26 : Could not get lock, sleeping for 5 seconds
21-MAY 03:48:32 : Could not get lock, sleeping for 5 seconds
21-MAY 03:48:38 : Could not get lock, sleeping for 5 seconds
21-MAY 03:48:44 : Could not get lock, sleeping for 5 seconds
21-MAY 03:48:49 : Could not get lock, sleeping for 5 seconds

EXPECTED BEHAVIOR
-----------------------
APS Collections Refresh Snapshot Thread should end in seconds.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run APS Collections Refresh Snapshot 

Cause

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