Stefano,
Unfortunately, I don't know how you'd separate off to different db pools, but now I understand why you want to. I guess I'd point to 2 primary issues:
- The use of OAS immediately introduces a performance degradation. It may only be 10-20% on most platforms, but can be as high as 200% on Linux, because you have to move away from the JRockit JDK to the Sun JDK.
- Many times slowdowns in integration aren't a DB-related issue (though, it's definitely worth checking), but rather caused by either backups in the Event Queues (check via the EventDiagServlet - glog.webserver.event.EventDiagServlet) or with object contention (check via the MediatorDiagServlet - glog.webserver.mediator.MediatorDiagServlet).--
May I ask what is necessitating the swap from WebLogic to OAS?
--Chris