A couple of things to try ---
1. Drop the indexes and primary key instead of disabling them. Insert the data and recreate pk. 2. This could be due to changes in data dictionary, when you insert large number of rows in the table, new extents may be allocated or high water mark of the table would be modified. This information need to be logged. I think that the redo generated due to this should not be very large though. Hope this helps. Viral Desai >From: Gurelei <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: RE: Why does my insert creates so many logs? >Date: Thu, 19 Sep 2002 06:03:29 -0800 > >None. >--- "Nicoll, Iain (Calanais)" ><[EMAIL PROTECTED]> wrote: > > Doesn't have any triggers does it? > > > > -----Original Message----- > > Sent: Wednesday, September 18, 2002 8:39 PM > > To: Multiple recipients of list ORACLE-L > > > > > > Hi. > > > > A developer of mine is running a large insert as > > select: > > > > insert /* parallel hint */ into table A > > nologging > > (select * from table b where ...); > > > > There are no indices on table A and a PK disabled. > > Still that insert generates a large amount of logs. > > What could be the reason for that? Any ideas? Table > > A > > is not partitioned and has NOLOGGING attribute on > > the > > dba_tables set to Yes. > > > > thanks > > > > Gene > > > > __________________________________________________ > > Do you Yahoo!? > > Yahoo! News - Today's headlines > > http://news.yahoo.com > > -- > > Please see the official ORACLE-L FAQ: > > http://www.orafaq.com > > -- > > Author: Gurelei > > INET: [EMAIL PROTECTED] > > > > 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: [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). > > -- > > Please see the official ORACLE-L FAQ: > > http://www.orafaq.com > > -- > > Author: Nicoll, Iain \(Calanais\) > > INET: [EMAIL PROTECTED] > > > > 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: [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). > > >__________________________________________________ >Do you Yahoo!? >New DSL Internet Access from SBC & Yahoo! >http://sbc.yahoo.com >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Gurelei > INET: [EMAIL PROTECTED] > >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: [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). _________________________________________________________________ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Viral Desai INET: [EMAIL PROTECTED] 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: [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).
