Re: ora_p[-0-9] procs have pid=1; OK?

From: Dave Mausner <d-mausner_at_nwu.edu>
Date: 1996/02/25
Message-ID: <4gq6nu$nee_at_news.acns.nwu.edu>#1/1


In article <4gnvjk$cif_at_cloner4.netcom.com>,

   "Timothy M. McGirr" <mcgirr_at_ix.netcom.com> wrote:
>doing 'ps -ef |grep ora_p0 reveals that there are a large number
 of
>parallel processes with a pid=1.
>Also there are several with identical names (eg. ora_p008_TOMM)
>
>Can anyone tell me what the proper behavior for these processes
 is
>and give me a pointer to a document to read about it.

read the dba guide: the parallel parameters allow you to specify the instance min and max parallel server count. when they are not busy, they attach themselves to process 1, otherwise they attach themselves to the process tree that is doing SQL. you can also specify a timeout period so that these things linger for awhile and then kill themselves off.

--
Dave Mausner, Consulting Manager, Braun Technology Group, Chicago.
Received on Sun Feb 25 1996 - 00:00:00 CET

Original text of this message