TOracleSession et Thread : UseSingleEnvironment

[cdev]

Hi,

I tried to write a Multi-threaded, multi-session application (each thread uses its own dedicated TOracleSession) with DOA 4.0.4.0

Unfortunately, during one thread "open" a long query, the others are uncapable to make use of their own sessions before the first thread's "open" end.
In this case, the database accesses are fully serialized.

I turned the value of the variable UseSingleEnvironment declared in OracleCI unit from true to false and then retry the same operations.
With this minor change, the database accesses seems to be fully paralellized.

• What is the effective goal of this variable?
• And why was it introduced in the version 4?

Thanks to any answer...

CdeV

 

[Marco Kalter]

This was an optimization in 4.0. However, if multiple threads block eachother, this is clearly not a good optimization. We'll look into this.