AQ$_FND_CP_GSM_OPP_AQTBL table created huge mess ....

Issue : OPP  given us issue and it got stuck .

Root cause identified that table AQ$_FND_CP_GSM_OPP_AQTBL huge size .

Followed below steps:

1. Shutdown application services

2. select count(*) from applsys.FND_CP_GSM_OPP_AQTBL ;

3. Sys user :

DECLARE
po dbms_aqadm.aq$_purge_options_t;
BEGIN
po.block := FALSE;
DBMS_AQADM.PURGE_QUEUE_TABLE(
queue_table => 'APPLSYS.FND_CP_GSM_OPP_AQTBL',
purge_condition => NULL,
purge_options => po);
END;
/

4. select count(*) from applsys.FND_CP_GSM_OPP_AQTBL ;

5. Run cmclean.sql ( For 12.2 environment use OAM ) 


6. Startup the services 


Our issue got fixed.


Thanks