prompt Parent Sessions

WITH px_session AS (

SELECT

qcsid,

qcserial#,

MAX (degree) degree,

MAX (req_degree) req_degree,

COUNT ( * ) no_of_processes

FROM

v$px_session p

GROUP BY qcsid, qcserial#)

s.sid,

s.username,

degree,

req_degree,

no_of_processes,

sql_text

v$session s

px_session p

(s.sid = p.qcsid AND s.serial# = p.qcserial#)

v$sql sql

(sql.sql_id = s.sql_id

sql.child_number = s.sql_child_number);

prompt Child Sessions

select

ps.qcsid,

ps.sid,

p.spid,

ps.inst_id,

ps.degree,

ps.req_degree

from

For full scripts, download the Oracle script collection.

gv$px_session ps

join

gv$session s

on ps.sid=s.sid

and

ps.inst_id=s.inst_id

join

gv$process p

on p.addr=s.paddr

and

p.inst_id=s.inst_id

order by

qcsid,

server_group desc,

inst_id,

sid;