Re: HELP!! Oracle Server Processes on UNIXWARE 7.1

vijaylamba_at_my-deja.com wrote:
>
> Hi,
> 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.

AFAIK these are Parallel Query processes -- if they are eating up a lot of CPU that is what I would expect...
> I would appreciate if somebody can help me out in this.
> Regards
> Vijay
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

--

Vincent Ventrone    |  The MITRE Corp.
DBA, Dept. R101     |  M/S C020
vav_at_mitre.org       |  202 Burlington Rd.
(781) 271-7048      |  Bedford, MA 01730