Himanshu Sinha - Oracle Apps DBA , Oracle DBA, Oracle Cloud DBA , Enterprise Architect.

During Subscriber Removal we were getting below Oracle Error. SQL> DECLARE   subscriber   SYS.aq$_agent; BEGIN   subscriber := SYS.aq$_agent ('ORA_692K6D2264P48DHO6OR3ACPJ6T', NULL, NULL);   DBMS_AQADM.remove_subscriber (queue_name      => 'WF_BPEL_Q',                                 subscriber      => subscriber                                ); END;  / DECLARE * ERROR at line 1: ORA-04030: out of process memory when trying to allocate 16328 bytes (koh-kghu call ,pmucalm coll) ORA-06512: at "SYS.DBMS_AQADM_SYS", line 7560 ORA-06512: at "SYS.DBMS_AQADM", line 441 ORA-06512: at line 5 == We were running a PL/SQL package or procedure and are consistently encountering an ORA-4030 when the process uses 4GB.  The values for the _PGA_MAX...

Remove Subscriber from WF_BPEL_Q consumers How to Check your current consumers SELECT * FROM ALL_QUEUE_SUBSCRIBERS WHERE QUEUE_NAME = 'WF_BPEL_Q';     SELECT * FROM apps."AQ$_WF_BPEL_QTAB_S" WHERE NAME IS NOT NULL and name like 'ORA_*****';  How to Remove Subscriber from WF_BPEL consumer DECLARE    subscriber       sys.aq$_agent;    begin subscriber := sys.aq$_agent('<CONSUMER_NAME>', NULL, NULL);    dbms_aqadm.remove_subscriber(queue_name => 'WF_BPEL_Q', subscriber => subscriber); End;