SQL Performance (MOSC)

MOSC Banner

How to clean up a large number of abandoned objects in the recycle bin?

There are more than 12 million abandoned objects in our production environment. According to the general method, last month,we use command "purge DBA_RECYCLEBIN" cleaning up our recycle bin. However,this command has been running for a month, and only 3 million abandoned objects have been cleaned up. Now there are more than 8 million abandoned objects in the recycle bin.At this rate, it will take another two months to completely empty the recycle bin, which is unacceptable to us. Therefore, we ask if there is a parallel cleaning method in the Oracle recycle bin, such as using multithreading to improve the

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