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

MOSC Banner

cstpostimportaad.sql has been running for over 13 hours and the overall upgrade just over 27 hours.

edited Aug 20, 2021 9:56AM in Install, Upgrade, Clone, Patch - EBS (MOSC) 6 comments
Hi,

I was hoping if anybody knew how to establish whether this upgrade script was actually doing anything. I'm applying the 12.1.1 upgrade driver u6678700.drv with the nocopyportion, nogenerateportion options.

I can tell that there is a process consuming high CPU on the server and that the session waits were mostly for Direct Path write and read temp on account of the hash joins being employed for executing the sql.

But is there a method to actually see how far the script has progressed. For instance earlier when it was running utl_recomp you could see how the number of invalid objects would reduce over time. Is there some query that will give a similiar result here.

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