How to delete more than 1000 unused managed objects

Symptom

 
There is an article, KB46453, that walks through how to trigger the Garbage Collection and how to schedule an Admin Task to auto-trigger the GC, but the default object counts we collect are always 1000. Here is the solution on how to enlarge the object counts.
 

Solution

 

1. Connect to the metadata database by DBQueryTool
    
   
2. Run the following SQL statements to update the system property

   GARBAGECOLLECTTRANSACTIONSIZE

   manually.
    
   

// if there is no 'GARBAGECOLLECTTRANSACTIONSIZE' set in DSSMDSYSPROP table, run this query first insert into DSSMDSYSPROP (NAME, PROP_VAL) values ('GARBAGECOLLECTTRANSACTIONSIZE', '1000'); 

// Reset GC transaction size Update DSSMDSYSPROP set PROP_VAL = '5000' where NAME = 'GARBAGECOLLECTTRANSACTIONSIZE';

 
 
3. Follow the steps in KB46453 to retrigger the Garbage Collection.