Oracle 8.0.4.4.0 Listener Process on Unixware 7.1

   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 Mon Dec 06 1999 - 11:35:39 CST