PJI_PMV_ENGINE.Convert_Organization Library Cache Locks
Last updated on FEBRUARY 15, 2018
Applies to:Oracle Project Intelligence - Version 12.1.3 and later
Information in this document applies to any platform.
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?
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