Ebiz 11.5.10.2 To R12.2.0 Upgrade Patch : Performance Issue With OKSSREPV1.sql (Doc ID 2218048.1)

Last updated on DECEMBER 28, 2016

Applies to:

Oracle Service Contracts - Version 12.2 and later
Information in this document applies to any platform.

Symptoms

On : 12.2 version, Patch Application Issues

ACTUAL BEHAVIOR
---------------
Performance issue with script $OKS_TOP/patch/115/sql/OKSSREPV1.sql during R12.2.0 upgrade patch driver, multiple locking sessions getting spawned.

EXPECTED BEHAVIOR
-----------------------
Upgrade patch should not take longer hours.

STEPS
-----------------------
The issue can be reproduced with the following steps:
1. Follow instructions mentioned in 12.2 upgrade guide.
2. Execution took 2 hours 40 minutes for upgrade completion.

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