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