Knarayan, thanks for your response.

We are using EJBs as well. I would very much appreciate if you would send me the sample code for item 1 and 3 you have mentioned. I will discuss this option with the Bea Developers over here.

I wouldn't mind increasing the INITTRANS value if we were
doing DML acitivity in these transactions. We are just doing SELECT statements. I hope I am in the right direction???
Please correct me if I am wrong.


Cheers!