Jack, I have another twist on this situation. Again I'm loading the tables in nologging mode with all the indices dropped. Both transactions are insert into table nologging (select *). The only difference is that one select is a select from a single table while the other - is a select from two joined tables.
The first insert (from a single) table produce archives, while the other (from two tables) - doesn't. Is there en explanation for that? thanks Gene --- Jack Silvey <[EMAIL PROTECTED]> wrote: > sorry, meant insert as select, not insert as append > --- Jack Silvey <[EMAIL PROTECTED]> wrote: > > Gene, > > > > This sounds right. > > > > Standard insert as append does freelist block > > checking > > and generates redo. Parallel DML generates > minimial > > redo, just for the new temp segments being > created, > > not for the datablock updates. This is one reason > it > > is so fast. > > > > Index changes are always logged, even in PDML and > > append modes. > > __________________________________________________ Do You Yahoo!? HotJobs - Search Thousands of New Jobs http://www.hotjobs.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gurelei INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).