Monday, May 23, 2011

Performance comparison of audit levels in SOA Suite 11g

I ran multiple tests to compare the performance of various audit level settings in Oracle SOA Suite 11g.

The two parameters tested are:
  • Audit Level
  • Capture Composite Instance State
To access these settings, log in to the EM console and navigate to SOA --> (right-click on) soa_server1 --> SOA Administration --> Common Properties.


Test #
Audit
Capture Composite Instance State
Min (ms)
Max
(ms)
Avg
(ms)
1
Off
n/a
27
519
50
2
Off
n/a
27
551
51
3
Off
n/a
27
325
49
4
Production
Disabled
77
825
128
5
Production
Disabled
63
420
104
6
Production
Disabled
62
697
108
7
Production
Enabled
75
475
153
8
Production
Enabled
85
649
149
9
Production
Enabled
82
1057
147


Results:
  • Audit=Off yields the best performance
  • Audit=Production is approximately 56% slower in performance than Audit=Off
  • Setting CaptureCompositeInstanceState=Disabled yields an additional 24% performance improvement

Recommendations:
  • Settings Audit=Development is unacceptable in a production environment due to the high performance overhead incurred
  • Setting Audit=Off, despite the drastic performance improvement, is unacceptable since absolutely no metadata is logged in the database and you have zero visibility into your instances
  • Set Audit=Production in a production environment
  • Consider setting CaptureCompositeInstanceState=Disabled, as you obtain this data by querying the tables in the database
  • Performing database tuning can improve performance of Audit=Production by at least 30%, so engage your DBAs

Applicable Versions:
  • Oracle SOA Suite 11g (11.1.1.4)

6 comments:

Tony said...

Hi Ahmed,

In 10g disabling audit also effectively disabled the fault policy. That's something to be aware off.

Kind regards,
Tony van Esch

Ahmed Aboulnaga said...

Check out step 7 in this blog post to drastically improve the performance of auditing:

http://blog.ipnweb.com/2011/04/performance-tuning-oracle-soa-suite-11g.html

reamon said...

Great stuff. Can you share details about the database tuning done to achieve the 30% gain?

Ahmed Aboulnaga said...

Hi Reamon,

Check out step 10 in this blog post (I just added it):

http://blog.ipnweb.com/2011/04/performance-tuning-oracle-soa-suite-11g.html

reamon said...

Thanks!

SOA and OIC Technology for beginners and learners said...

Hi Ahmed.. i need an urgent help.

i have an esb..

with one routing service and one soup service

when i am migrating to 11g.. i am getting in service reference and one reference pointing to 10g wsdl..ok

when i deployed the same code to 11g it got deployed successfully..

now i want to point the both routing service and soap service to 11g port..

i am able to get the routing service wsdl ,can you please let me know where can i find the soup service wsdl pointing to 11g port..