Re: Multi-threaded 7.3 OCI Question
Date: 1996/07/25
Message-ID: <31f6dc09.6847466_at_dcsun4>#1/1
On 24 Jul 1996 12:00:03 -0600, bhays_at_csn.net (Boyd Hays) wrote:
>I'm trying to use the thread-safe mode of Oracle's OCI 7.3.
>The documentation states that there are three requisites:
> 1. Use olog() instead of orlon().
> 2. The hda must be initialized to zeros.
> 3. The function opinit() must be called to setup
> Oracle's use of threads.
>
>I cannot find the opinit() function in either the shared
>object version of the client library or in any of the
>static libraries. Does anyone know where this function lives?
>At what revision level of the 7.3 libraries was it included?
>
The utility symfind is useful in these cases, for example:
$ symfind opinit
SymFind - Find Symbol <opinit> in <**>.a, .o, .so
Command: /usr/oracle/bin/symfind opinit Local Directory: /usr/oracle
Output File: (none)
Note: I do not traverse symbolic links
Use '-v' option to show any symbolic links
Locating Archive and Object files ...
Symbols from ./lib/libclient.a[opinit.o]:
[1] | 0| 0|FILE |LOCL |0 |ABS |opinit.s [4] | 0| 12|FUNC |GLOB |0 |2 |opinit ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ ./lib/libclient.a [85] | 16| 16|FUNC |GLOB |0 |23 |opinit_ ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ ./rdbms/lib/ocifor.o
It would appear that with 7.3.2.2 opinit is in libclient.a
>Also, does anyone know if Oracle allocates thread-local
>storage in a connection specific way? My application's design
>uses a pool of threads on Solaris 2.5.1 and at runtime any
>of those threads can be used to service an OCI request. My
>concern is that I may need to restrict all activity for a
>specific connection to the same thread that is in turn
>bound to its corresponding Oracle thread.
>
>Thanks in advance,
>Boyd Hays -- bhays_at_csn.org
>
Thomas Kyte
Oracle Government
tkyte_at_us.oracle.com
http://govt.us.oracle.com -- Check out our web site! Brand new, uses Oracle Web Server and Database
statements and opinions are mine and do not necessarily reflect the opinions of Oracle Corporation Received on Thu Jul 25 1996 - 00:00:00 CEST