打开一个窗口以hr用户登录,执行:
HR@orcl 18-SEP-14>begin
2 insert into t values(2);
3 end;
4 /
PL/SQL procedure successfully completed.
这个pl/sql中没有commit。
到另一个窗口中以sys用户登录,查看动态性能视图v$transaction:
SYS@orcl 18-SEP-14>select xid,xidusn from v$transaction;
XID XIDUSN
---------------- ----------
14001E00EB000000 20
SYS@orcl 18-SEP-14>/
no rows selected