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: Re: Which method is more efficient

Re: Re: Which method is more efficient

From: <rgaffuri_at_cox.net>
Date: Thu, 29 May 2003 07:04:45 -0800
Message-ID: <F001.005A58FC.20030529070445@fatcity.com>


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

Original text of this message

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