Re: Identifying parallel query slaves

Jonathan Lewis wrote:
>
> You might want to start by looking at v$px_session
> which has a qcsid, qcserial# as well as the sid, serial#
>
> --
> Jonathan Lewis
> http://www.jlcomp.demon.co.uk
>
> Next Seminars
> UK June / July
> Australia July / August
> http://www.jlcomp.demon.co.uk/seminar.html
>
> Sybrand Bakker wrote in message ...
> >
> >"Chuck" <chuckhNOSPAM_at_softhome.net> wrote in message
> >news:adj6q3$11sbnr$1_at_ID-85580.news.dfncis.de...
> >>
> >> "Fred" <fpuhan_at_precise.com> wrote in message
> >> news:20020604154214846-0400_at_news.his.com...
> >> > In <adj4va$11460m$1_at_ID-85580.news.dfncis.de> Chuck wrote:
>
> >It definitely is possible.
> >I remember something about all the session having the same sid, but
> >different serials, and program names like 'P000' etc.
> >However, at home I can't check.
> >I will try to check tomorrow in a live system which definitely is, though
> >inadvertently, running parallel query.
> >

On a similar note - anyone noticed that db writer slaves don't seem to appear in v$bgprocess (9i)

Connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."