SQL> insert /**//*+append*/ into t select * from dba_objects nologging;
9157 rows created.
SQL> select a.xidusn,a.xidslot,a.used_ublk,a.used_urec,b.username
2 from v$transaction a,v$session b,v$mystat c
3 where a.addr = b.taddr and c.statistic# = 1
4 /
XIDUSN XIDSLOT USED_UBLK USED_UREC USERNAME
---------- ---------- ----------
2 21 1 1 CUST
SQL> commit;
Commit complete.
SQL> insert into t select * from dba_objects;
9157 rows created.
SQL> select a.xidusn,a.xidslot,a.used_ublk,a.used_urec,b.username
2 from v$transaction a,v$session b,v$mystat c
3 where a.addr = b.taddr and c.statistic# = 1
4 /
XIDUSN XIDSLOT USED_UBLK USED_UREC USERNAME
---------- ---------- ----------
1 1 13 423 CUST |