Upgraded db from 11.2.0.3.0 to 12.1.0.2.0. Slow Journal Import

Hi,

We upgraded our database from 11.2.0.3.0 to 12.1.0.2.0 on PROD on weekend of 18/19 June 2016.

We also applied CPU patches and others (13942692, 18813637, 12404574, 15969020, 18835102, 21612876, 17889841, 12598630, 18991480, 22465286, 22614470, 16289505, 18039691, 9833058,, 16958896, 22378313).

During the testing we hit an issue with slow performance of the "Journal Import" GLLEZL job.

We find that when the Journal Import runs slowly (e.g. for a 19,000 line Web ADI journal the "Web ADI - Journal Import" job takes 2.5 hours compared to a couple of minutes on the Database 11 version).

For other jobs, e.g. when we load data into the GL_INTERFACE and run a standard "Program - Journal Import", e.g. a 120,000 line journal, the job never completes.