Oralce/OCI Multi-threading question ?

From: Srinivas B.S.S <bsssrinivas_at_lycos.co.uk>
Date: Sat, 05 Apr 2003 13:57:36 +0530
Message-ID: <3E8E9378.5090003@lycos.co.uk>

Hi,

How Oracle handles the TNS requests by default ? i.e. without enabling any multi-threaded options. Will it handle them serially(one after another) ?

I have a multi-threaded application in which each thread owns a connection object(hence, OCI handle) exclusively. But the sniffer trace looks like all the TNS requests from the application are being sent one after another like a single threaded application ?

OCI handle is initialized with OCI_THREADED flag, but in this case, it should cause OCI to maintain extra mutex and some extra processing, not the observed behavior. Any thoughts on this ?

Thanks,
Srinivas. Received on Sat Apr 05 2003 - 02:27:36 CST