Re: Multiple sessions bound to one background process in dedicated server

From: Yong Huang <yong321_at_yahoo.com>
Date: 17 Apr 2003 20:53:57 -0700
Message-ID: <b3cb12d6.0304171953.1bc49ed4@posting.google.com>

"Tanel Poder" <tanel@@peldik.com> wrote in message news:<3e994d41$1_2_at_news.estpak.ee>...
> Hello!
>
> One can create several sessions under same sqlnet connection using OCI8 and
> pthreads libraries.

That sounds quite right. I read somewhere that if your client application is multithreaded (maybe not necessarily using pthreads), it makes multiple sessions in v$session but all correspond to the same spid and pid in v$process. I'll verify that when I have time. I also saw this before, I think in an Oracle forms environment.

Yong Huang Received on Thu Apr 17 2003 - 22:53:57 CDT