Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Redo Activity

Re: Redo Activity

From: Stefan Knecht <knecht.stefan_at_gmail.com>
Date: Mon, 22 May 2006 12:47:06 +0200
Message-ID: <486b2b610605220347x65bdf548s1dae8af96133f30c@mail.gmail.com>


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
Received on Mon May 22 2006 - 05:47:06 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US