I have faced an issue where my environment's Index agent was NOT able to process new documents. While checking I fond out that dmi_queue_item cont is very high, so I am posting this self answered question which will let us know how to get your queue items cleaned up with Xplore OLD items.
In order to clear the unwanted queue items , we will have to perform following steps
create table temp_dmi_queue_item_s as (select * from dmi_queue_item_s where name <> 'dm_fulltext_index_user' AND name <> 'dm_fulltext_index_user_01' );
truncate table dmi_queue_item_s;
insert into dmi_queue_item_s select * from temp_dmi_queue_item_s;
4)Run ftintegrity in order to fix any inconsistencies between Repository and Index data
Note- Make sure, implementation of the above steps should be tested on non-production environment before production