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 -> Commit after transacton is completed

Commit after transacton is completed

From: Pradeep <agarwalp_at_eeism.com>
Date: 25 Nov 2005 00:23:28 -0800
Message-ID: <1132907008.179667.238670@g49g2000cwa.googlegroups.com> 





Expert-one-on-one mentions that we should commit only after the
transaction completes, otherwise it takes more time and generates more
redo. I agree to it. But suppose if my transaction takes a few minutes
to complete, i will be holding locks for that time and other people
will be reading the history data. So isn't this the disadvantage of
commiting after transaction??



thanks



Pradeep
Received on Fri Nov 25 2005 - 02:23:28 CST












Original text of this message













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