Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Asynchronous Commit in Oracle Database 10g R2

Re: Asynchronous Commit in Oracle Database 10g R2

From: AnySQL (d.c.b.a) <anysql_at_gmail.com>
Date: 5 Sep 2005 20:49:11 -0700
Message-ID: <1125978551.139964.163860@o13g2000cwo.googlegroups.com> 





Asynchronous may not be so effeciency as the log format changes, I have
heard that oracle 10g can reduce the log generation in bulk
update/delete, in earlier version, each updated/deleted row will have
an log entry, as you know, in the log file, more than half of the bytes
are the control information, by packing then togather just as bulk
insert, it will greatly improve the bulk update/delte performance.



http://www.anysql.net/en/
Received on Mon Sep 05 2005 - 22:49:11 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US