Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: most expeditious way to update a large number of rows
myl..._at_gmail.com wrote:
> 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
Sorry, that's "736" after updating a single row. Received on Mon Oct 16 2006 - 17:03:36 CDT