Re: Redo Activity

there's a pretty good presentation by julian dyke:

http://julian.dyke.users.btopenworld.com/com/Presentations/Presentations.html#RedoInternals

the informationt therein, plus knowledge of your data (avg col lengths etc) will give you a pretty close figure of how much redo to expect.

Stefan

On 5/19/06, Ebadi, Abdul <Abdul.Ebadi_at_level3.com> wrote:
>
> Is there any way to figure out the amount of redo generated per INSERT
> (or any statement)? We are currently loading a table (via conventional
> sqlldr) and are interested to find out how much redo generation will be
> gone if that table is dropped/moved to another DB?
>
> Oracle 9.2.0.4 on Solaris 10.
>
> Thanks,
> Abdul
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

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