My Oracle Support Banner

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 FEBRUARY 17, 2019

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

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.