Re: Oracle shadow process parent id of 1

dbaplusplus_at_hotmail.com wrote in
news:1130009040.821094.64370_at_f14g2000cwb.googlegroups.com:

> Genrally, parent id is the pid of UNIX process who made connection to
> database.
> That is if I did
> sqlplus /nolog
> conn scott/tigger
>
> my process say is 1000,
> then Oracle will start a shadow process say process id of 1001. ps -aef
> will
> show parent id of process 1001 as 1000 and not 1.
>
> Somehow, in Oracle 10.1.0.4 on my HP unix machine, parent process id is
> 1
> for all oracle shadow processes.
>
>

So why is this a problem?

Below is from a Solaris running Oracle V9.2

oracle   15226     1  0 11:58 ?        00:00:09 oraclecdb1 (LOCAL=NO)
oracle   15514     1  2 12:00 ?        00:00:21 oraclecdb1 (LOCAL=NO)
oracle   15608     1  3 12:00 ?        00:00:32 oraclecdb1 (LOCAL=NO)
oracle   15959     1  1 12:02 ?        00:00:12 oraclecdb1 (LOCAL=NO)
oracle   16708     1  0 12:06 ?        00:00:00 oraclecdb1 (LOCAL=NO)
oracle   16710     1  0 12:06 ?        00:00:02 oraclecdb1 (LOCAL=NO)
oracle   16804     1  1 12:07 ?        00:00:09 oraclecdb1 (LOCAL=NO)
oracle   16811     1  0 12:08 ?        00:00:00 oraclecdb1 (LOCAL=NO)
oracle   16813     1  0 12:08 ?        00:00:00 oraclecdb1 (LOCAL=NO)
oracle   17281     1 13 12:12 ?        00:00:33 oraclecdb1 (LOCAL=NO)
oracle   17307     1  3 12:12 ?        00:00:06 oraclecdb1 (LOCAL=NO)
oracle   17451     1  3 12:12 ?        00:00:06 oraclecdb1 (LOCAL=NO)