Upgrading From 11i To R12.2 and Running into Performance Issues with Jlzzmigawtdist.sql
(Doc ID 1674542.1)
Last updated on AUGUST 19, 2020
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 adworkers, which should be better.
The query is joining the following two tables, if split, it should reduce run time.
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.
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
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.