oracle 11 client external exception incident

[commander]

last year i mentioned that there are problems with
oracle 11 client and doa.
since nobody could give me an idea what to do i kept
using oracle 11 client.

today i found a curious workaround...

my environment:
1 main process with 3x toraclesession
2-10 threads each with toraclesession and one query

problem: when ever the session in the threads started
i got an external exception and all oracle session even
in the main process crashed

workaround: i set the THREADSAFE property in all oraclesessions to TRUE and everything works fine.

question: i wonder if this brings my thread model back to
serial execution of all the oracle actions.
i wanted to use threads because i needed a non blocking
way to access oracle from different event controlled threads

and why does this not happen in oracle 10 client ?

help is absolutley appreciated !

cheers
claus reinhardt

 

[Marco Kalter]

question: i wonder if this brings my thread model back to serial execution of all the oracle actions.

Only database activities for the same session will be serialized. If multiple threads access the same TOracleSession instances, then ThreadSafe must be set to True.