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: uwe.weber@computacenter.com

Re: uwe.weber@computacenter.com

From: hpuxrac <johnbhurley_at_sbcglobal.net>
Date: 4 Oct 2006 15:02:37 -0700
Message-ID: <1159999356.978888.99240@h48g2000cwc.googlegroups.com>

Uwe Weber wrote:
> Bug 4475314 - DELETE then INSERT without commit on ASSM segment can be slow
> Doc ID: Note:4475314.8

Workaround is commit after delete?

But Tom Kyte teaches us to commit only when it makes business sense within a transaction. No need to make transactions arbitrarily short in oracle.

Well except if you are running ASSM maybe. Thinking about it maybe I have seen this in Tom Kyte's asktom.oracle.com already. Received on Wed Oct 04 2006 - 17:02:37 CDT

Original text of this message

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