MQSeries.net :: View topic - WMB<->ORA DB Session Handling

spahrson · Posted: Thu Oct 25, 2012 1:23 am Post subject: WMB<->ORA DB Session Handling

Hi all,

I have a broker application connected to an oracle mts environment with odbc. I use the data direct odbc driver. Now I have noticed that it is important how I scale the application. Eg. if I create 1 executiongroup with 80 additional instances, the number of processed messages is much lower than when I create 3 processes with each 20 additional instances. With this change i jumped form 3msg/s up to 110msg/s for database inserts over storedprocedures.

My explanation for this is that the broker is handling ora sessions differently. So which each exeGrp I get a new proccess on ora database, because I use a different session. While additional instances always use the same one session of the exeGrp. So, if I need multiprocessing on ora, i have to create multiple exeGrp (with all its disadvantages, eg. additional JVM).

Does that makes sense? I don't have much experience with ora, and I don't have any dba rights on ora. So I can't check the sessions/procceses on the database.