a parallel slaves
sql>select a.insT_id,a.sid,a.program,b.start_time,b.used_ublk,b.xidusn||'.'||b.xidslot||'.'||b.xidsqn trans_id from gv$session a, gv$transaction b where a.taddr = b.addr and a.inst_id = b.inst_id and (a.sid,a.inst_id) in (select z.sid,z.inst_id from gv$px_session z where z.qcsid = &sid) order by sid
/
please omit the sql> prompt when copying
No comments:
Post a Comment