分别在local instance的两个session中执行:
1 2 3 4 5 |
--在一个session: select * from t1@ora9i for update; --在另一个session: delete from t2@ora9i where rownum<=3; |
如何查找正在进行的分布式事务,可以用下面的几种方法: (1)语句如下:
1 2 3 |
select username, osuser, status, sid, serial#, machine, process, terminal, program from v$session where saddr in (select k2gtdses from sys.x$k2gte ); |
显式结果: [crayon-66 […]