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: 10gR2 - direct path load with enabled indexes - lots of undo generated from indexes

RE: 10gR2 - direct path load with enabled indexes - lots of undo generated from indexes

From: Powell, Mark D <mark.powell_at_eds.com>
Date: Tue, 30 May 2006 16:02:44 -0400
Message-ID: <5A14AF34CFF8AD44A44891F7C9FF410507658E50@usahm236.amer.corp.eds.com>


 Basically, index DML operations always log no matter what the documentation says.

HTH -- Mark D Powell --

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Christo Kutrovsky Sent: Tuesday, May 30, 2006 3:49 PM
To: oracle-l
Subject: 10gR2 - direct path load with enabled indexes - lots of undo generated from indexes

Hello All,

We're doing a direct path to an empty table via:

insert /*+ APPEND*/ into TABLE as select * from other_schema.SAME_TABLE;

The table has a primary key and a few extra indexes. The goal is to perform the entire operation in nologging mode. The table and all indexes are "nologging".

The problem we have is that there's undo (rollback) generated for the indexes, which I dont understand. Why is there undo generated for an index built, equivalent to the size of all indexes ? Is this normal ?

The process goes as follow
- start writing into table segment

Any ideas? It doesn't make sense to use that much undo (rollback) ? When you do a normal index build you dont use that much undo.

--
Christo Kutrovsky
Senior Database/System Administrator
The Pythian Group - www.pythian.com
I blog at http://www.pythian.com/blogs/
--
http://www.freelists.org/webpage/oracle-l


--
http://www.freelists.org/webpage/oracle-l
Received on Tue May 30 2006 - 15:02:44 CDT

Original text of this message

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