Upgrading From 11i To R12.2 and Running into Performance Issues with Jlzzmigawtdist.sql
Last updated on APRIL 09, 2018
Applies to:Oracle Financials for the Americas - Version 12.2.1 and later
Information in this document applies to any platform.
On : 12.2.1 version, Argentina Payables
You are upgrading from 11i to R12.2 and are having a performance issue with jlzzmigawtdist.sql 120.26.
Steps to Reproduce:
Run 12.2 migration steps on Test environment.
Performance issues with jlzzmigawtdist.sql 120.26 (latest version) while upgrading from 11i to R12.2.
The migration script jlzzmigawtdist.sql is taking too much time to run. It should be parallelized to run in several adworkers.
It took almost 5:30 to run is a test environment (former prod hardware).
The script is performing a single INSERT-SELECT, it's not parallelized to run in several adoworkers, which should be better.
The query is joining the following two tables, if split, it should reduce run time.
AP_INVOICE_DISTRIBUTIONS_ALL: 41,479,662 rows
JL_ZZ_AP_INV_DIS_WH_ALL_T: 55,346,849 rows
The whole migration process took around 98hs, so this single script took 5% of the time.
Even though it ran ok, it's too much time in a single step that perhaps can be shorten.
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