Hi, thanks to every one who helped In my 10.1.0.3.0. database I tested and got the following Setting both I got an error, so I tried only discrete transactions as you can see. alter system set "_DISCRETE_TRANSACTIONS_ENABLED" = TRUE SCOPE=SPFILE; alter system set "_DISABLE_LOGGING" = TRUE SCOPE=SPFILE; Errors in file e:\oracle\product\10.1.0\admin\cachon\bdump\cachon_lgwr_2396 trc: ORA-07445: exception encountered: core dump [INT_DIVIDE_BY_ZERO] [0x228F17A] [] [] [] [] alter system set "_DISABLE_LOGGING" = FALSE SCOPE=SPFILE; But I didn't found improvement and still there were undo blocks SQL> ALTER TABLE TEST NOLOGGING ; Table altered. SQL> exec dbms_transaction.begin_discrete_transaction; SQL> insert into test select a.* from dba_objects a,(select 1 from dba_objects w here rownum <101); SQL> select used_ublk,used_urec from v$transaction ; USED_UBLK USED_UREC ---------- ---------- 31594 3885977 So the conclusion is, to speed the process is to use create as select, instead of insert to add more records to the table. Juan Carlos Reyes Pacheco OCP -- //www.freelists.org/webpage/oracle-l