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

> Ok, help me understand. Approximately how much "redo" will my update
> generate? I'm modifiying a single varchar(19) field in every row
> (671,000 rows). Block size is 8kB.
>
> Thanks,
> Myles
>

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

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown