Re: updating a table with the same value

The simple answer to the last bit of the question is that all blocks would be rewritten because even if a row hasn't changed it would be locked (and that's a "metadata" change to the row even when it's not a data change to the row.

Regards
Jonathan Lewis

On Thu, 8 Dec 2022 at 15:29, <ahmed.fikri_at_t-online.de> wrote:

>
> Hello, everyone,
>
> Could someone please tell if following queries produce the same amount of
> REDO/UNDO?
>
> 1) update table foo set status = 0;
> 2) update table foo set status = 1;
>
> In both cases the status for all records is 0.
>
> Are all blocks rewritten in both cases?
>
> I’m using Oracle 19.3
>
> Thanks
> Ahmed
>
>
>
> Gesendet mit der Telekom Mail App
> <http://www.t-online.de/service/redir/emailmobilapp_ios_smartphone_footerlink.htm>
>

--
http://www.freelists.org/webpage/oracle-l