Technology Stack - EBS (MOSC)

MOSC Banner

adop actualize_all.. Compiling invalids !!!

edited Aug 20, 2021 11:52AM in Technology Stack - EBS (MOSC) 3 commentsAnswered

Hi Experts,

I am planning to run actualize_all in production system. When I am running it in non-Prod environment, I can see it is compiling invalids (using dbms_scheduler) and it is causing many concurrency wait events like 'row cache lock', library cache lock/pin etc.. We have a sensitive system in this regard.

So my question is, theoretically its an online activity/phase but is it practical to run this in a very very high transactional EBS environment ? Oracle doesn't recommend compiling object in an very active database then how is this phase doing the same ? Is it compiling objects in old edition, which I doubt because I could see the last_ddl of objects changing run edition of DB.

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