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 04, 2024

Applies to:

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

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