Oracle的快速删除和快速插入

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

--------------------next---------------------