Re: Identifying parallel query slaves

The unix PPID is always 1. That doesn't help me.

What I want to do is find out which PQ slaves are running queries for a particular parent SID. In other words if there are 100 PQ slaves running, and my query has 4 of them, I want to know which 4 are working on my query.

• Original Message ----- From: "RSH" <RSH_Oracle_at_worldnet.att.net> Newsgroups: comp.databases.oracle.server Sent: Tuesday, June 04, 2002 2:16 PM Subject: Re: Identifying parallel query slaves

> Look at the PID and PPID's.
>
> Also, slave PQ processes have rather distinctive names.
>
> a
>
> ps -fu <oracle owner> | grep <PPID> ought to give you a list of what you
> want without a lot of trash.
>
> (don't use the angle brackets, just the appropriate values)
>
> RSH.
> "Chuck" <chuckhNOSPAM_at_softhome.net> wrote in message
> news:adid77$113k23$1_at_ID-85580.news.dfncis.de...
> > Is there a way to associate active parallel query slaves with the parent
> > SID?
Received on Tue Jun 04 2002 - 14:38:11 CDT