Technology Stack - EBS (MOSC)

MOSC Banner

How to perform Full_cleanup without impacting EBS performance

edited Jan 18, 2020 4:04AM in Technology Stack - EBS (MOSC) 1 commentAnswered

Understood Various actions are performed during cleanup, including dropping (removing) obsolete:

Crossedition triggers

Seed data

Editioned code objects (covered objects)

Indexes

Columns

Editions

I would like to perform full cleanup ( to ged rid of all old editions in database,Performs maximum cleanup, which drops all obsolete code and data from earlier editions

)

adop phase=cleanup cleanup_mode=full

We would like to know possibilities ( if available )

- perform edition cleanup alternatively ( other than using adop phase=cleanup mode=full_cleanup)

- can we perform edition cleanup in stages

- what happens if we have a heavily used Transaction processing system and full_cleanup is running for long ( due to size of database and number of old editions )

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