Thursday Jun 11, 2015

Preparing Your Database for SOA Suite 12c

DB Prep

One of the things that struck me about joining Oracle almost 17 years ago was the sheer power and comprehensiveness of the Oracle Database.  I have never been a database guy, Oracle recruited me because I understood Java, and I have always worked with Oracle middleware.  But the awe of the capabilities of the database has never left me.  SOA Suite 12c uses the database for many things, including storing composites, storing composite execution state, storing human workflow state, persisting BAM data objects and so on.  Because of the reliance of SOA Suite on the database then getting the database set up properly is well worth the investment.

When running the Repository Creation Utility (RCU) you are asked about the size of the database required; small, medium or large.  All 3 sizes have the same table structures, but the large schema has a different storage structure.  It uses a database feature called partitioning which can help with managing database growth and accelerate the purge process.  Partitioning stripes a database table across multiple files based on a partition key, typically a date.  Default partitioning is based on monthly interval partitioning.  The benefit of this is that if all your composites from 3 months ago have completed then you can get rid of them from the database by just dropping the partition that holds the data from three months ago.  Scripts will check that you have no live data in the partition before you drop it.

Partitioning is just one of the cool features that SOA Suite uses in the oracle database. There are others.

So how do you know how to take best advantage of the database used by SOA?  Fortunately with 12c Oracle have significantly improved the tuning and management documentation for the database.  Below is a list of links I recently gathered for a large manufacturer who is going live on 12.1.3 over the next few months.  I think you will find them well worth the study.

Following documentation may be helpful in configuring database for 12c SOA


Friday Mar 15, 2013

New SOA Suite 11g Database Performance Tuning White Paper

We're pleased to announce a new SOA Suite 11g Database Performance Tuning White Paper.

This Fusion Middleware 11g white paper discusses performance optimizations in the SOA database to derive maximum value from your implementation.

These recommendations are for SOA 11g running under Oracle database release 11.1.0.1 and above. The SOA database can be hosted in a non- RAC configuration and RAC configuration.

It’s available on one of the SOA Suite OTN Advanced pages or directly HERE.

Enjoy!

Friday May 27, 2011

Purging Strategies in Oracle SOA Suite 11gR1 PS3

UPDATE: the detailed whitepaper on "SOA 11g Database Growth Management Strategy" is now available.

Just a quick post before taking off for the long Memorial Day weekend in the US (we are off on Monday).

Since shipping Oracle SOA Suite 11g we’ve seen an explosion of the amount of data being processed by the product across the world. The net result of this is a corresponding growth in audit data and increasingly more complex needs on the purging side: often times purges need to happen on running system and that means with the least possible impact on operations. We have added several improvements in PS3 to the purge scripts. Here is a set of slides describing the various purging strategies now available in Oracle SOA Suite: from the graphical tools in Enterprise Manager, to PL/SQL scripts (looped purge and parallel purge) and database partitioning.

image This slide deck is a work in progress so please leave your questions on purging in comments and I will try to address them in the next version (and if I don’t, Deepak will in the more substantial whitepaper that he is preparing on this very topic).

About

Find Us on facebook Follow us on twitter Oracle SOA Suite forum
SOA PM team
Welcome to the Oracle SOA Suite team blog. We'll use this site for news and information that did not make it into our official documentation for a reason or another.

Search

Archives
« July 2015
SunMonTueWedThuFriSat
   
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
28
29
30
31
 
       
Today