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