Oracle 8.0.4.4.0 Listener process on UNIXWARE 7.1

From: <vijaylamba_at_my-deja.com>
Date: Sat, 04 Dec 1999 13:59:19 GMT
Message-ID: <82b6nm$u5o$1@nnrp1.deja.com>

Hi,
We had Oracle 7.3.2 Enterprise on SCO open 5 server with NT clients. Example:
The processes on UNIX (# ps -ef|grep ora) would look like:

id       parent id        description


--       ---------        ------------


24        1               oralistener --listener process
25        1               ora_pmon_<sid> --b/g process
25        1               ora_lgwr_<sid> --b/g process
65        1               oracle<sid> --other process (select)
68        1               oracle<sid> --other process(executing proc)

Now we have moved to Oracle 8.0.4.4.0 on UNIXWARE 7.1 and the processes (# ps -ef|grep ora)look like:

id       parent id        description


--       ---------        ------------


24        1               oralistener --listener process
25        1               ora_pmon_<sid> --b/g process
25        1               ora_lgwr_<sid> --b/g process
65        24              oracle<sid> --other process (select)
68        24              oracle<sid> --other process(executing proc)
69        1               ora_p000_<sid> --?????
87        1               ora_p001_<sid> --?????

Questions:
1. Should the parent id of other oracle processes(65, 68) be the id of listener(24). It was not the case in 7.3.2. And what I understand is listener's job is to just listen to the user process and move out. Is this correct?
2. I dont know what ora_p000_<sid> process is? And its parent id is that of the operating system and not of listener. Also they eat up a lot of CPU time.
I would appreciate if somebody can help me out in this. Regards
Vijay

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Sat Dec 04 1999 - 07:59:19 CST