Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Dedicated Server - but multiple sessions bound to a single server ?

Re: Dedicated Server - but multiple sessions bound to a single server ?

From: Thomas Kyte <tkyte_at_oracle.com>
Date: 13 Aug 2002 18:54:39 -0700
Message-ID: <ajcd8v028eb@drn.newsguy.com>


In article <300217f3.0208130529.35a47d15_at_posting.google.com>, muthy69_at_yahoo.com says...
>
>I 'am running CRM 11.5.6 on Solaris 8 , Oracle 8.1.7
>I would appreciate if anyone can explain this to me.
>
>I'am running the database in DEDICATED SERVER MODE.
>
>I gave this query to the database
>

a session is a "logical thing". There is a connection, then there is/are sessions on that connection.

we can have more then one session using the same physical connection.

You are seeing forms having more then one session using the same physical connection. This is normal, it saves (massively) on resources.

See
http://technet.oracle.com/docs/products/oracle8i/doc_library/817_doc/appdev.817/a76975/oci02bas.htm#423550

and page down to

"Option 2: Multiple Sessions or Connections"

for the 'technical' details.

>SELECT spid,count(*)
>FROM V$SESSION s,V$PROCESS p
>WHERE s.paddr=p.addr
>GROUP BY spid
>order by 2;
>
>SPID count(*)
>------ --------
>13638 1
>..... ..
>..... ..
>..... ..
>24306 2
>..... ..
>..... ..
>18725 15
>..... ..
>..... ..
>
>Well this Surprised me so i gave thsi query
>
>SELECT sid,username,status,process,machine,terminal
> program,type,last_call_et
>FROM V$SESSION
>WHERE paddr IN(
> SELECT addr
> FROM v$process
> WHERE spid=18725);
>
>
>SID USERNAME STATUS SERVER PROCESS MACHINE TERMINAL PROGRAM TYPE
>LAST_CALL_ET
>--- -------- ------ ------ ------- ------- -------- ------- ---- ----
>-------
>27 APPS INACTIVE DEDICATED 18683 crm USER 6862
>341 APPS INACTIVE DEDICATED 18683 crm USER 4664
>305 APPS INACTIVE DEDICATED 18683 crm USER 858
>...............................................................................
>73 APPS INACTIVE DEDICATED 18683 crm USER 7032
>
>13 rows selected.
>
>i saw that the process 18683 is f60webmx and process 18725 is ...TNS
>(v1-V2)...(a dedicated Server process)
>
>Now my questions are
>1) why are there multiple sessions bound to the same process while
>i'am running the database in DEDICATED SERVER MODE
>2) Why is the client PROCESS id the same in the second output ?
>
>Thanks in advance

--
Thomas Kyte (tkyte@oracle.com)             http://asktom.oracle.com/ 
Expert one on one Oracle, programming techniques and solutions for Oracle.
http://www.amazon.com/exec/obidos/ASIN/1861004826/  
Opinions are mine and do not necessarily reflect those of Oracle Corp 
Received on Tue Aug 13 2002 - 20:54:39 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US