We still get threads blocking each other when accessing Oracle. We have
tried cx_Oracle and DCOracle2. The symptom is as follows:
- Launch AppServer.
- Launch WAPT load testing tool with 40 users.
- Performance is poor, but acceptable.
- The AppServer windows freezes.
- We hit ^C. One of the threads says that Oracle has interrupted the
command by user request (or sth). The other threads respond immediately.
So, I think it is clear that the stopped thread was indeed blocking
other threads. We are not using any locking mechanism in our code.
Where should I look?