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

Home -> Community -> Usenet -> c.d.o.server -> Re: Direct-Path on Global_Temp_T ?

Re: Direct-Path on Global_Temp_T ?

From: <fitzjarrell_at_cox.net>
Date: 7 May 2007 13:11:34 -0700
Message-ID: <1178568694.505161.192660@n59g2000hsh.googlegroups.com>


On May 7, 2:30 pm, "tea" <t..._at_mailinator.com> wrote:
> 10gR2/Solaris 8
>
> Does it make any sense/difference to do Direct-Path Insert on GTT
> (Global_Temp_Table) ?
>
> i.e. add "/*+ APPEND */" to
> "INSERT into GTT SELECT * FROM sometable"
>
> or is it moot ?
>
> thanks

No, it doesn't make sense, really. The redo generated for temporary tables is minimal, and can't be disabled. Thus a direct-path insert behaves no differently for a temporary table than does a plain-vanilla insert.

David Fitzjarrell Received on Mon May 07 2007 - 15:11:34 CDT

Original text of this message

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