demo02.sql

Expert Oracle Database Architecture 9i and 10g sql源码

alter session enable parallel dml;
update big_table set status = 'done';
select a.sid, a.program, b.start_time, b.used_ublk,
       b.xidusn ||'.'|| b.xidslot || '.' || b.xidsqn trans_id
  from v$session a, v$transaction b
 where a.taddr = b.addr
   and a.sid in ( select sid
                    from v$px_session
                   where qcsid = 162 )
 order by sid
/