MTS Oracle_XA performance tuning

I work for a software development firm which develops a warehouse management system. The system is setup in a 3-tier mode using Microsoft Transaction Server as the Transaction Monitor (middleware). Its database access model consists of using ADO classes which make use of the Oracle_XA interface to access the Oracle Resource Manager.

   One of the operations we perform, is 'UPDATE'-intensive (about 1000 updates)and we've noticed that during the operation (By way of 'select count(*) from v$session') there is only a total of 10 sessions connected to the database. The memory and CPU usages stay at about 50% and there is no activity on the disk I/O end either. Which leads me to believe that the problem might be in sequential access to the database.

      Is there a way to bump up the # of connections allowable in Oracle? My license_max_sessions = 0 (infinite # of sessions). But was wondering if there might be another issue as well. I've run the estat bstat tests on the db and it seems to be well tuned. Any suggestions?

Thanks

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Mon Dec 20 1999 - 14:53:37 CST