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.
>
Received on Fri Jun 07 2002 - 02:57:13 CDT
