Thursday, January 17, 2008

Oracle: How to watch parallel session in a RAC configured Database

This is the sql statement that you will issue to see your session if it did use
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: