Re: Who spawns a dedicated server process?

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

"Ed prochak" <ed.prochak_at_magicinterface.com> wrote in message news:4b5394b2.0309250457.7c9105c6_at_posting.google.com...
> "Michael J. Moore" <NOhicamelSPAM_at_comcast.net> wrote in message
 news:<UNrcb.425915$Oz4.221120_at_rwcrnsc54>...
> > 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
>
> --
> Magic Interface, Ltd.
> 440-498-3700
Received on Fri Sep 26 2003 - 03:14:06 CEST