Re: Multi-Threaded Oracle Clients

     Bob Stewart wrote in article <3cu5s3$701_at_moon.earthlink.net> :
>
>Andrew Grace (apgrace_at_jungle.bt.co.uk) wrote:
>: Can an Oracle client run multi-threaded?
 

>: In my client code, I want to connect to the database once, then
>: execute a number of non-blocking DML actions, with each action running
>: in its own thread?
 

>: Can the oracle server cope with having more than one concurrent request
>: from the same login context?
>
>We tried to do something similar which Oracle Tech support didn't want
>to talk seriously about. We have a process connected which is a process
>monitor. As a real time partial transaction come in it needs to add it to
>a table, check the table for a complete transaction, and if complete
>do some other action. We chose to fork the processes off as workers,
>and got memory corruption errors, as each forked process was firmly
>convince it was already connected. We finally had to fork/exec. Seems
>like a waste of time, but that was where they left us.
>
>--
>If power corrupts, and absolute power corrupts absolutely,
>government corruption WILL be reduced by reducing government power. q.e.d.
>
>Bob Stewart (KB9ZW)
>wk USA (310) 335-7152
>

Well, Oracle told us officially that they do not support MT-safe threads on the Unix platform. They think of doing this in versions >= 7.3...  

Helmut Kaufmann (kaufmann_at_inf.ethz.ch) Institut fuer Informationssysteme---Fachgruppe Datenbanken

                                                      ,,,,,,,,
                                           .:::.   .;''      '``;.
   ....                                    :::::  ::    ::  ::    ::
 ,;' .;:                ()  ..:            `:::' ::     ::  ::     ::
 ::.      ..:,:;.,:;.    .   ::   .::::.    `:'  :: .:' ::  :: `:. ::
  '''::,   ::  ::  ::  `::   ::  ;:   .::    :   ::  :          :  ::
,:';  ::;  ::  ::  ::   ::   ::  ::,::''.    .    :: `:.      .:' ::
`:,,,,;;' ,;; ,;;, ;;, ,;;, ,;;, `:,,,,:'   :;:    `;..``::::''..;'
                                                     ``::,,,,::''