R12 After Upgrade to 12.1.3, PRC: Update Project Performance Data Shows a Large Wait on Event PL/SQL lock timer (Doc ID 1918587.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Project Planning and Control - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

After upgrade to 12.1.3, the process PRC: Update Project Performance Data shows the following in the trace file:

Elapsed times include waiting on following events:
 Event waited on                             Times   Max. Wait  Total Waited
 ----------------------------------------   Waited  ----------  ------------
 log file sync                                   1         0.00          0.00
 SQL*Net message to client              7         0.00          0.00
 SQL*Net message from client          7         0.00          0.00
 utl_file I/O                                    22        0.00          0.00
 PL/SQL lock timer                          3402     300.02    1019912.70

Note that there was no other performance issue found in the trace.

Cause

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