Long running query in Multi Threading application

[Joseph]

I am looking for some help. I have a server application that receives a text file and process this data in oracle. It works fine for two thread but when I tried to run more than two, somehow I am experiencing queries that run longer or even keeps running without stopping. My application is using blocking calls and each thread has each own oracle session.
Thus anybody have any idea as to what am I doing wrong.

thanks

 

[Marco Kalter]

Could this perhaps be a locking issue? This is the most common issue when multiple threads with dedicated sessions run into such problems: the separate sessions block each other at the table/record level.