3 Replies Latest reply on Oct 30, 2009 12:05 AM by dhausercan2

    JBOSS ESB - ORACLE DB performance and admin questions

    dhausercan2

      Hi There,

      I have switched the ESB over to Oracle 10g using the docs (i.e. oracle-ds.xml). After a few cycles of testing it seems that the DBMS schema that I setup for storing the ESB tables has a very high level of growth (86 MB in 2 days).

      Can somebody speak to how this should be managed. My messaging on the ESB is only SOAP in / SOAP out with no Reliable Messaging setup. My expectation is that any DBMS table entries would not need to persist after the SOAP requests complete, but this seems not to be the case.

      If the ESB does not 'cleanup' records, then please let me know the recommendation for creating an SQL utility script to do the same.

      Thanks,
      David.