Install, Upgrade, Clone, Patch - EBS (MOSC)

MOSC Banner

apidstln.sql configuration tuning

edited Aug 20, 2021 9:56AM in Install, Upgrade, Clone, Patch - EBS (MOSC) 3 commentsAnswered
We have a script that is taking 27 hours longer to run in an 80 processor environment than it did on a 46 processor environment.  The script is apidstln.sql.  The script is read and write intensive and my guess the most read and write intensive in our environment than the other thosands of scripts that are part of the upgrade process.  We believe we need to make adjustments that are environmental to the Oracle DB server to speed up this one process but we don't have time remaining to go thru full upgrade cycles currently taking 12+ days on 80
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center