When using the Direct Oracle Access components inside an ISAPI webapplication,
there are several things that are not quite clear to me:

1) Do I have to turn ThreadSafe property of OracleSession to True?

2) Connecting an OracleSession consumes a few seconds. Do I have to Connect and Disconnect before and after each webdispatch manually, or is it ok when I connect the session once and leave the session connected?

3) In which way are the OracleSession cached in the webserver and how many different sessions are launched in oracle when several user access the ISAPI at the same time?


Thanks in advance for any feedback,
Bernado.

1) If your ISAPI DLL will use multiple threads then yes set the ThreadSafe property to TRUE.

2) Leave the session connected.

3) If all your threads are using the same session (see #1 above) then there will only be one Oracle session.