Please a parameter to disable undo, EPILOGUE 2004-10-07 - By Juan Carlos Reyes Pacheco
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 (See ORA-07445.ora-code.com): 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
--
http://www.freelists.org/webpage/oracle-l
|
|
