Tag Archive: Integrated SOA Gateway

Purging Oracle EBS Integrated SOA Gateway Tables

If you happen to be using Oracle E-Business Suite Integrated SOA Gateway (ISG) you may at some point find yourself retaining way too much data.  Did you know that there is a seeded purge program available that will delete data from the underlying tables?  This is helpful to maintain the data at a reasonable size to help performance and minimize the storage footprint.   Observations My SOA purging journey began due to a performance related issue.  This occurred when I navigated to the Integrated SOA Gateway responsibility > SOA Monitor, it was taking upwards of 5 minutes to pull up that web page.  When I…
Read more