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

From: Stephan Bressler <stephan.bressler_at_siemens.com>
Date: Fri, 11 Apr 2003 15:12:18 +0200
Message-ID: <b76esr$fs7$1@news.mch.sbs.de>

Hi,
expand your query with a.server. Will show you the server type (dedicated, shared, none) for those sessions.
Maybe some clients connect via mts.

Regards
Stephan

"srivenu" <srivenu_at_hotmail.com> wrote in message news:1a68177.0304110348.33f8181c_at_posting.google.com...
> We are running Oracle 9i RAC on SUN E15K (OS solaris 5.8)
> We are running in Dedicated server mode.
> I see that multiple sessions are being bound to a single background server
process.
>
> select a.sid,b.pid,a.process,b.program sprogram,b.spid
> from v$session a,v$process b
> where a.paddr(+)=b.addr
> order by 5
>
> Client Oracle
> Process Server Backgroun
> SID PID ID Program ProcessID
> ---- ---- ---------- ------------------------------ ---------
>
> 29 253 11037 oracle_at_xxxxxxxxxxxxx (TNS V1-V 27997
> 44 253 11037 oracle_at_xxxxxxxxxxxxx (TNS V1-V 27997
> 139 162 11903 oracle_at_xxxxxxxxxxxxx (TNS V1-V 28461
> 299 162 11903 oracle_at_xxxxxxxxxxxxx (TNS V1-V 28461
> 478 157 13201 oracle_at_xxxxxxxxxxxxx (TNS V1-V 29180
> 493 157 13201 oracle_at_xxxxxxxxxxxxx (TNS V1-V 29180
> 214 167 13375 oracle_at_xxxxxxxxxxxxx (TNS V1-V 29306
> 287 167 13375 oracle_at_xxxxxxxxxxxxx (TNS V1-V 29306
> 289 260 13813 oracle_at_xxxxxxxxxxxxx (TNS V1-V 29676
> 182 263 13874 oracle_at_xxxxxxxxxxxxx (TNS V1-V 29710
> 539 263 13874 oracle_at_xxxxxxxxxxxxx (TNS V1-V 29710
>
>
> My question is why are multiple sessions being bound to a single server
process ?
>
> Thanks in advance for any responce.
> regards
> Srivenu
Received on Fri Apr 11 2003 - 08:12:18 CDT