My Oracle Support Banner

Script Ar120lclcsu.sql Took 32 Minutes To Complete During 11.5.10.2 To Release 12.1.1 Upgrade (Doc ID 1573729.1)

Last updated on FEBRUARY 01, 2018

Applies to:

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

Symptoms

Script Ar120lclcsu.sql Took 32 Minutes To Complete During 11.5.10.2 To Release 12.1.1 Upgrade

SGS use ARLCUPB.pls version 120.12.12010000.2
SGS use ar120lclcsu.sql version 120.2

This accounts for almost all the elapsed time and has a very inefficient execution plan.
There is a full table scan HZ_CUST_SITE_USES_ALL CSU in the inline view L

Changes

 

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.