Re: does update table with identical values actually write to disk?
- From: Clay Colburn <clay.colburn@xxxxxxxxx>
- To: rjoralist2@xxxxxxxxxxxxxxxxxxxxx
- Date: Mon, 1 Nov 2010 13:30:27 -0700
Sorry guys, I seemed to have committed at the wrong time. So it looks like
the redo log is incremented when doing this operation. Thanks to Jared for
pointing out the error!
On Mon, Nov 1, 2010 at 12:57 PM, Rich Jesse <
rjoralist2@xxxxxxxxxxxxxxxxxxxxx> wrote:
> Clay Colburn wrote:
>
> > For those not inclined to run through the example, the answer was that it
> > does not update the row, oracle intelligently skips the operation.
>
> Can you post your example? I've tried several tests where the data is
> same/different, before/after commit, and multiple columns -- all unindexed
> -- but am unable to find a correlation in the numbers resulting from
> Jared's
> query run before and after each test.
>
> It's probably something obvious that I'm not seeing. It *is* Monday after
> all...
>
> Rich
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
Other related posts:
