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

Home -> Community -> Usenet -> c.d.o.misc -> Re: undo retention

Re: undo retention

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sun, 12 Feb 2006 12:34:25 +0100
Message-ID: <u67uu1df0hl4bedcmocg0rpvbmsd6f0d1b@4ax.com>


On 11 Feb 2006 14:09:26 -0800, "Mark D Powell" <Mark.Powell_at_eds.com> wrote:

>jg, I will disagree that committing within a loop is in and of itself
>bad.

It is bad in itself. Know what a transaction is? a *logical* unit of work. So why breaking up a logical unit of work into many physical ones, while you have your database configured incorrectly? Why continue to fight symptoms instead of repairing the problem?

--
Sybrand Bakker, Senior Oracle DBA
Received on Sun Feb 12 2006 - 05:34:25 CST

Original text of this message

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