Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Re: Which method is more efficient
oh it wasnt none, it was cut in half. I skimmed it.
my bad
> From: Richard Foote <richard.foote_at_bigpond.com>
> Date: 2003/05/29 Thu AM 08:45:46 EDT
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> Subject: Re: Which method is more efficient
>
>
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Thursday, May 29, 2003 3:14 AM
>
>
> > 1. to totally eliminate redo, load your staging records into a global temp
> table. it has absolutely no redo and is very fast.
>
> Hi
>
> The above is not quite true. Global temp tables *do* generate redo (albeit
> indirectly) and potentially quite a bit of it. The point to make here is
> that changes to GTT generate undo and this undo makes changes to undo
> segments and these changes subsequently generate redo. So depending on the
> type of DML (eg. deletes) and the volume of changes, you can end up
> generating quite a bit of the redo.
>
> Not as much as a non-GTT but enough to certainly invalidate the above
> statement.
>
> Cheers
>
> Richard Foote
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: Richard Foote
> INET: richard.foote_at_bigpond.com
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
>
-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <rgaffuri_at_cox.net INET: rgaffuri_at_cox.net Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Thu May 29 2003 - 10:04:45 CDT