Performance Issue in okltxnupd.sql during R12 upgrade (Doc ID 2267089.1)

Last updated on MAY 17, 2017

Applies to:

Oracle Lease and Finance Management - Version 12.1.1 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.1 version, INSTALL

ACTUAL BEHAVIOR
---------------
Upgrade script okltxnupd.sql is taking more than 8 hours to run during an upgrace from 11i to R12 (currently 12.1.1 driver is running).


EXPECTED BEHAVIOR
-----------------------
Expect the script to complete in an hour

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Upgrade from 11i to R12

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, the upgrade is taking longer than the time available and long running SQLs need to be tuned to lower the time to upgrade.

Changes

 

Cause

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