RE: Why does my insert creates so many logs?

PK has it's own index... did u drop that too ?

> ----------
> From: Gurelei[SMTP:gurelei_at_yahoo.com]
> Reply To: ORACLE-L_at_fatcity.com
> Sent: Friday, September 20, 2002 1:23 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Why does my insert creates so many logs?
>
> All the indices are dropped and the PK is disabled.
> I agree that there are some changes to be done
> in the data disctinary tables, but the amount of
> archived logs - about 90M per minute looked too high
> to me
>
> --- Viral Desai <viral303_at_hotmail.com> wrote:
> >
> > 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 <gurelei_at_yahoo.com>
> > >Reply-To: ORACLE-L_at_fatcity.com
> > >To: Multiple recipients of list ORACLE-L
> > <ORACLE-L_at_fatcity.com>
> > >Subject: RE: Why does my insert creates so many
> > logs?
> > >Date: Thu, 19 Sep 2002 06:03:29 -0800
> > >
> > >None.
> > >--- "Nicoll, Iain (Calanais)"
> > ><iain.nicoll_at_calanais.com> 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: gurelei_at_yahoo.com
> > > >
> > > > 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: 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: Nicoll, Iain \(Calanais\)
> > > > INET: iain.nicoll_at_calanais.com
> > > >
> > > > 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: 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).
> > >
> > >
> > >__________________________________________________
> > >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: gurelei_at_yahoo.com
> > >
> > >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: 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).
> >
> >
> >
> >
> >
> _________________________________________________________________
> > 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: viral303_at_hotmail.com
> >
> > 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: 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).
>
>
> __________________________________________________
> 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: gurelei_at_yahoo.com
>
> 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: 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: Rahul
  INET: rahul_at_ratelindo.co.id

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: 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).