Re: most expeditious way to update a large number of rows

Brian Peasland wrote:
> You can verify this yourself. In your session, issue the following query:
>
> SELECT value
> FROM v$mystat m, v$statname s
> WHERE m.statistic#=s.statistic#
> AND s.name='redo size';
>
> Then run your UPDATE statement. Next, run the above query again. The
> difference between the two numbers should serve as a pretty good
> approximation.
>
>
> HTH,
> Brian
>

Thanks, Brian. That was extremely helpful. The result of your query is 736. I assume that's bytes, right?

If that's the case, my update will generate ~ 471MB of redo.

Thanks again,
Myles Received on Mon Oct 16 2006 - 16:59:31 CDT