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

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 Received on Tue Aug 13 2002 - 08:29:31 CDT