By Juergenkress-Oracle on Jul 03, 2013
Oracle has released a new version 18.104.22.168.0 for their Oracle Fusion Middleware product line. This version includes Patch Set #6 (PS6) for Oracle SOA Suite 11g R1, with a big list of improvements and fixes for each component in that suite.
In this post we will highlight some of the interesting updates with regards to troubleshooting, performance, reliability and scalability.
Database growth is a common problem for large-scale Oracle SOA Suite deployments. Oracle already provides multiple purging strategies for the SOA Suite runtime database. This patch set includes two new scripts for purging most of the runtime data:
- Table Recreation Script (TRS): This script can be used to reclaim as much database space as possible, while still retaining the open instances. It can be used as a corrective action for databases that grew excessively, for example when purging was not performed at all. This should be used as a single corrective action only; the script does not replace the normal purging scripts.
- Truncate script: Remove all records from the SOA Suite runtime tables without dropping the tables. This script can be used for cloning SOA Suite environments without copying the instance data, or for recreating test scenarios by cleaning all the runtime data.
The Oracle SOA Suite Administrator's guide contains a table with the available purging strategies.
Using WLST you could already dump diagnostic information about various components of the SOA Suite. This version adds support to retrieve more information on BPEL and Adapters from the command-line.
Diagnostic dumps for BPEL
diagnostic dumps are available for BPEL to get information on thread
pools, average processing time for BPEL components, and average waiting
times for asynchronous instances. This information can be very useful
for performance analysis or troubleshooting. With WLST this information
can be retrieved from the command-line and included for monitoring or
reporting. Read the full article here.
For regular information on Oracle SOA Suite become a member in the SOA & BPM Partner Community for registration please visit www.oracle.com/goto/emea/soa (OPN account required) If you need support with your account please contact the Oracle Partner Business Center.