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 6 7406
"Michael J. Moore" <NO***********@comcast.net> wrote in message news:<UNrcb.425915$Oz4.221120@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
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********@magicinterface.com> wrote in message
news:4b**************************@posting.google.c om... "Michael J. Moore" <NO***********@comcast.net> wrote in message
news:<UNrcb.425915$Oz4.221120@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
"Michael J. Moore" <NO***********@comcast.net> wrote in message news:<ypMcb.432226$cF.134811@rwcrnsc53>... 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********@magicinterface.com> wrote in message news:4b**************************@posting.google.c om... "Michael J. Moore" <NO***********@comcast.net> wrote in message news:<UNrcb.425915$Oz4.221120@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
The last response was not correct. The O/S doesn't know how to start
Oracle processes on it's own. The ppid of the dedicated server
processes is the init process because Oracle pulls a little trick to
make that happen.
For remote connections (i.e. over the network) the dedicated server
process is actually spawned by the listener, and Oracle then makes the
init process into the parent of that dedicated server. If the ppid
(parent process id) remained the listener, you'd never be able to
shutdown the listener without killing all of your users. The init
process didn't start the server process because it doesn't even know
how to start an Oracle process.
For local connections (i.e. on the same box, on UNIX), the dedicated
server process is actually spawned by the client process. You can
easily see this becaue the ppid of the dedicated server process is the
client. If I remember correctly, Oracle doesn't make the server
process into a child of the init process because death of the client
means the server should die.
Corrections or comments are welcome...
"Michael J. Moore" <NO***********@comcast.net> wrote in message news:<ypMcb.432226$cF.134811@rwcrnsc53>... 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********@magicinterface.com> wrote in message news:4b**************************@posting.google.c om... "Michael J. Moore" <NO***********@comcast.net> wrote in message news:<UNrcb.425915$Oz4.221120@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
The last response was not correct. The O/S doesn't know how to start
Oracle processes on it's own. The ppid of the dedicated server
processes is the init process because Oracle pulls a little trick to
make that happen.
For remote connections (i.e. over the network) the dedicated server
process is actually spawned by the listener, and Oracle then makes the
init process into the parent of that dedicated server. If the ppid
(parent process id) remained the listener, you'd never be able to
shutdown the listener without killing all of your users. The init
process didn't start the server process because it doesn't even know
how to start an Oracle process.
For local connections (i.e. on the same box, on UNIX), the dedicated
server process is actually spawned by the client process. You can
easily see this becaue the ppid of the dedicated server process is the
client. If I remember correctly, Oracle doesn't make the server
process into a child of the init process because death of the client
means the server should die.
Corrections or comments are welcome...
"Michael J. Moore" <NO***********@comcast.net> wrote in message news:<UNrcb.425915$Oz4.221120@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 init process is the "initial" process that was started when the
UNIX system was booted. Everything comes after init. In UNIX, if a
process dies, then all of it's children die. If the listener was the
parent, then you wouldn't be able to bounce the listener without
killing all of the sessions. If PMON (or another background process)
was the parent of the dedicated servers, then it would have to respond
to all of the signals generated by those clients. It would get VERY
ugly from a performance perspective. The init process is the parent
because the listener MADE it be the parent. Pretty cool. Don't ask
me how they do it. They're smarter than me. mi*********@yahoo.com (Mr. DB) wrote in message news:<40*************************@posting.google.c om>... "Michael J. Moore" <NO***********@comcast.net> wrote in message news:<UNrcb.425915$Oz4.221120@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 init process is the "initial" process that was started when the UNIX system was booted. Everything comes after init. In UNIX, if a process dies, then all of it's children die. If the listener was the parent, then you wouldn't be able to bounce the listener without killing all of the sessions. If PMON (or another background process) was the parent of the dedicated servers, then it would have to respond to all of the signals generated by those clients. It would get VERY ugly from a performance perspective. The init process is the parent because the listener MADE it be the parent. Pretty cool. Don't ask me how they do it. They're smarter than me.
Because they start it as a background process. From the UNIX prompt
you can perform the similar functions using the nohup command. And yes
I did leave this out of my other response. My oversight, I responded
too quickly without noting all the possibilities.
So the way they do it is actually pretty easy (a couple options during
the fork()/exec() processing).
(So much information, so hard to know how much the reader needs!)
Thanks for the assist mr DB.
Ed Prochak This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Paul Eden |
last post by:
Afternoon all.
I wonder if someone might lend a little hand here?
I'm using input.htm to take some data using radio and a text field
from the user, which then "get"s them to update.php.
Now...
|
by: Rohit |
last post by:
Hi
I've got a web site running on a Windows 2003 server (Web edition)
cluster i.e. web farm. The cluster is accessed through a virtual IP
(say a.a.a.a).
Through an asp page (asp 3.0) i need...
|
by: scott |
last post by:
what is the best way to send data to and query SQL 2005 server express
edition db hosted on a dedicated server with ISP ?
i need to query it directly from an application on my LAN (asp site on...
|
by: Liam |
last post by:
We currently have a dedicated server with Rackspace, and they've been
been great for 5 years now.
But they are SO expensive!
We're looking into GoDaddy's dedicated hosting, and they're 1/3 to...
|
by: Desmond |
last post by:
Some major websites have their own dedicated page not found error. I
do not have control of the server that is used for my website. Can I
still have my own dedicated 404 page?
Desmond.
|
by: Michael J. Moore |
last post by:
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...
|
by: =?GB2312?B?0rvK18qr?= |
last post by:
Hi all,
Recently I had a new coworker. There is some dispute between us.
The last company he worked for has a special networking programming
model. They split the business logic into...
|
by: adlloyd |
last post by:
Hi all,
I'm doing a little research into Windows-based managed/dedicated servers.
There are a few companies that provide what I want with a reputation to back it up: rackspace.co.uk...
|
by: DolphinDB |
last post by:
Tired of spending countless mintues downsampling your data? Look no further!
In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
|
by: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: Vimpel783 |
last post by:
Hello!
Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
|
by: ArrayDB |
last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
|
by: Defcon1945 |
last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
|
by: af34tf |
last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome former...
| |