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

Also,

Is this an in-house system that you know all about, or a 3rd party system with a
block box n-tier architecture.

I believe it is possible to get multiple sessions all associated with a single SID if you have an OCI client that is making use of proxy users to maintain n-tier pass-through authentication.

--
Regards

Jonathan Lewis
http://www.jlcomp.demon.co.uk

  The educated person is not the person
  who can answer the questions, but the
  person who can question the answers -- T. Schick Jr


One-day tutorials:
http://www.jlcomp.demon.co.uk/tutorial.html

____UK_______April 22nd
____Denmark__May 21-23rd
____USA_(FL)_May 2nd

Three-day seminar:
see http://www.jlcomp.demon.co.uk/seminar.html
____UK_(Manchester)_May
____Estonia___June (provisional)
____Australia_June (provisional)
____USA_(CA, TX)_August

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html


"Stephan Bressler" <stephan.bressler_at_siemens.com> wrote in message
news:b76esr$fs7$1_at_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

>

>