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

On 13 Aug 2002 06:29:31 -0700, muthy69_at_yahoo.com (murthy) wrote:

>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
>
>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

Unix process id's get reused. On some O/S the process id one way or another is bound to the starting address in memory, this might apply to Unix also.
So there is only one session connected to that process. The other ones died illegally and PMON didn't yet clear them up. That's all there is to it.

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Tue Aug 13 2002 - 12:45:59 CDT