PJI_PMV_ENGINE.Convert_Organization Library Cache Locks (Doc ID 1951583.1)

Last updated on AUGUST 01, 2016

Applies to:

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

Goal

12.1.3

When multiple sessions are running the below PLSQLblocks, there are lots of library cache locks in the database.  This is
causing a severe performance degradation.
 
begin PJI_PMV_ENGINE.Convert_Organization; end;
 
This is being caused by the below two lines in the PJI_PMV_ENGINE package.
 
PJI_PMV_ENGINE.set_table_stats('PJI','PJI_PMV_ORG_DIM_TMP',10,10,10);
PJI_PMV_ENGINE.set_table_stats('PJI','PJI_PMV_ORGZ_DIM_TMP',10,10,10);

Bug 19233841 is logged for this issue and the fix is included 


The bug is fixed in <Patch 17855246>:R12.PJ_PF.B ( CUMULATIVE RELEASE 5 ON 12.1.3.DELTA.6 ON RELEASE DATE 14-NOV-14) but applying all of these changes to Production during a busy
season isn't possible. Is there a one-off fix available?

Solution

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