My Oracle Support Banner

AQ Based ESB_CONTROL Topic Queue Tables Grow (Doc ID 784898.1)

Last updated on FEBRUARY 01, 2018

Applies to:

Oracle ESB - Version and later
Information in this document applies to any platform.


Having set up the AQ based persistence for JMS queues for ESB (as described in the Enterprise Deployment Guide), when the SOA services are shut down and do not stop gracefully, the AQ subscribers are not removed and new subscribers are registered when the system is restarted.

To reproduce/verify the issue:

  1. Setup AQ based persistence for JMS queues following the sections 3.23, 3.24, and 3.25 from the Oracle Application Server Enterprise Deployment Guide 10g Release 3 ( using SOA Suite with MLR#1 to MLR#4.
  2. Deploy any ESB Project.
  3. Connect to sqlplus as the oraesb user.
  4. In another terminal window, shutdown the services using: 
    $ORACLE_HOME/opmn/bin/opmnctl shutdown
  5. Do a count on the table aq$esb_control_s in the sqlplus session while starting and stopping the server in another terminal window (see steps below):
    (Numbers of subscribers will vary, for this example assume 12 to start)
    1. Perform the initial count when the SOA Services are down.
      select count(*) of table aq$esb_control_s;
      result = 12
    2. Start the SOA Services using
      $ORACLE_HOME/opmn/bin/opmnctl startall
    3. Perform another count:
      select count(*) of table aq$esb_control_s;
      result = 14;
    4. Shutdown the SOA Services again and perform another count:
      result = 13;
    5. Start the SOA Services agaun and perform the last count to verify:
      select count(*) of table aq$esb_control_s;

Instead of shutting down you also can shut down only the JVM, this can be done doing a kill -9 of all the java processes, the instances will restart automatically and the number of subscribers will be increased every time it is restarted.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.