Which process spawns a dedicated server process?

From: Michael J. Moore <NOhicamelSPAM_at_comcast.net>
Date: Sat, 27 Sep 2003 19:28:23 GMT
Message-ID: <rxldb.166107$mp.90993@rwcrnsc51.ops.asp.att.net>

I posted this on another group but I would still like a more detailed answer so I am trying here.
Here is the conversation as it exists so far ...

---

>>Which process spawns a dedicated server process?
 >>Is it the listener process, or some other Oracle process. Also, on a Unix
> > system, when you do "ps -ef" to see your processes, the PPID points back
 to
> > a process named "init". Why does the PPID not point to some other
 process
> > like, for example, the listener, or PMON, or whoever spawned it.
> > thanks,
> > Mike

---

> The processes are spawned by the OS, repesented by the process called
> init. Talk to you UNIX admin about how this works.
>
> Then my question back to you arises: why do you care?
>
> If you are the DBA, then you need to hit the manuals some more.
> If you are not the DBA, you should not care.
>
> (I suspect ayou are not the DBA but you feel to need to control this
> process somehow. If you have some problem of performance or other,
> post that and suggestions will come. Looking at process IDs will get
> you nowhere in understanding the ORACLE operations and architecture.)
>
> HTH,
> ed

---

Ed, I have hit the manuals resulting in the very need to ask this question.

According to OCP 9i Database Fundamentals 1 Exam Guide:

On page 12 it says: "... the listener tells Oracle to generate a new dedicated server ..." yet on page 14 in the questions and answers section it says "The listener spawns a new server process."

So, which is it, "listener tell Oracle" or "listener spawns"? Or now you have given me a third option "The processes are spawned by the OS".

The reason I care is because I would like to be able to answer this question correctly if it occurs on an exam.

regards,
Mike Received on Sat Sep 27 2003 - 14:28:23 CDT