How to perform Full_cleanup without impacting EBS performance
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 )