10046和dtrace研究一致读

<pre name="code" class="sql">SESSION 1:
SQL> update t set owner='AA' where object_id=500;

已更新 1 行。


SQL>   select xidusn,xidslot,xidsqn,ubablk,ubafil,ubarec,to_char(START_SCN,'9999999999999') from v$transaction;

    XIDUSN    XIDSLOT     XIDSQN     UBABLK     UBAFIL     UBAREC TO_CHAR(START_
---------- ---------- ---------- ---------- ---------- ---------- --------------
         4         30        903        413          3          1        1023079

SQL>  select name from v$rollname where usn=4;

NAME
------------------------------
_SYSSMU4_2140711993$




SQL> select spid from v$process where addr=(select paddr from v$session where sid=(select sid from v$mystat where rownum < 2));

SPID
------------------------
2744

SQL>  alter system flush BUFFER_CACHE;

系统已更改。

SQL> ALTER SESSION SET EVENTS '10046 trace name context forever, level 12';

会话已更改。

SQL>