| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Why does my insert creates so many logs?
is the tablespace in hotbackup mode?
-----Original Message-----
From: Gurelei [mailto:gurelei@yahoo.com]
Sent: Thursday, September 19, 2002 11:24 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@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@yahoo.com>
> >Reply-To: ORACLE-L@fatcity.com
> >To: Multiple recipients of list ORACLE-L
> <ORACLE-L@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@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@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@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@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@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@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@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@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@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@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@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: Nick Wagner INET: Nick.Wagner_at_quest.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).Received on Thu Sep 19 2002 - 15:58:31 CDT
 |
 |