Helen,

thanks for your explanation. we were under many delusions..., all
clarified now.


1. select statements constituted readonly transactions
2. select statements did not contribute to the OAT/OIT.
3. autocommit did hardcommit

We were using autocommit only for tables/queries that did not perform
any writes. We have now proved in a sample application that redoing
this fixes the problem that was leading to the slowdown.

Regards