Multiple sessions bound to one background process in dedicated server

From: srivenu <srivenu_at_hotmail.com>
Date: 11 Apr 2003 05:47:14 -0700
Message-ID: <1a68177.0304110348.33f8181c@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 - 07:47:14 CDT