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: APPEND hint (Was: Which is faster??)

RE: APPEND hint (Was: Which is faster??)

From: Steve Adams <steve.adams_at_ixora.com.au>
Date: Sun, 25 Mar 2001 03:33:22 -0800
Message-ID: <F001.002D752B.20010325031520@fatcity.com>

Hi Yong,

I don't think that's right. Try it on a table with no indexes, and dump the redo and undo blocks afterwards. My tests show that there is no row level redo (layer 11) except against the data dictionary tables for space management, regardless of whether the table or tablespace is defined as NOLOGGING. The undo is correspondingly trivial. However, if there are indexes then you get lots of index redo (layer 10) and corresponding undo.

@ Regards,
@ Steve Adams
@ http://www.ixora.com.au/
@ http://www.christianity.net.au/

-----Original Message-----
Sent: Sunday, 25 March 2001 15:18
To: Multiple recipients of list ORACLE-L

Hi, Connor,

The append hint to insert does not disable generating rollback info. It does
stop redo generation for a nologging table.

Yong Huang
yong321_at_yahoo.com

you wrote:

If you're on 8.0 or higher, try

insert /*+ APPEND */
into table
select * from other_table;

where "table" is defined as nologging. Then you won't hit either redo logs or rollback segments..Its the equivalent of a sqlldr direct load

hth
connor



Do You Yahoo!?
Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: yong huang
  INET: yong321_at_yahoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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.com
-- 
Author: Steve Adams
  INET: steve.adams_at_ixora.com.au

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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 Sun Mar 25 2001 - 05:33:22 CST

Original text of this message

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