R12.1.1 Upgrade Performance Issues With EGOEXTUPG.sql (Doc ID 1517483.1)

Last updated on AUGUST 21, 2016

Applies to:

Oracle Product Hub - Version 12.1.1 and later
Information in this document applies to any platform.

Goal

We are upgrading our 11.5.10.CU2 environment to R12, this SQL EGOEXTUPG.sql as a part of R12.1.1 upgrade driver runs on average 1hrs 20mins to 1 hrs 45 minutes. We requested any workaround/patches to cut down the timing on this SQL in the below post of EBS Patching forum. There was a workaround to add a parallel hint, but that errored out with a syntactical error. They further mentioned to check with Product team on a solution further on this.
We would like to know on any patch that could be applied that would bring in higher version of this SQL which will improve the performance of this SQL during the upgrade.
 

Solution

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