Oracle批量update和delete

2014-11-24 17:42:35 · 作者: · 浏览: 1

  --insert操作无论是1条或者多条,一次产生一条undo数据


  SQL> create table a (b number, c varchar2(30));


  Table created


  SQL> insert into a values (1,'zhangsan');


  1 row inserted


  SQL>


  SQL> select used_ublk,used_urec from v$session s, v$transaction t


  2 where s.audsid=sys_context('userenv', 'sessionid') and s.taddr = t.addr;


  USED_UBLK USED_UREC


  ---------- ----------


  1 1


  SQL> insert into a select rownum,rownum from dual connect by rownum<=50;


  50 rows inserted


  SQL>


  SQL> select used_ublk,used_urec from v$session s, v$transaction t


  2 where s.audsid=sys_context('userenv', 'sessionid') and s.taddr = t.addr;


  USED_UBLK USED_UREC


  ---------- ----------