PJI_PMV_ENGINE.Convert_Organization Library Cache Locks
(Doc ID 1951583.1)
Last updated on FEBRUARY 03, 2019
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?
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