| 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: insert in batch loading
We have 5 groups of redo log. Each group has two members. Each member is
100 MB.
David
>From: Mladen Gogala <mladen_at_wangtrading.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: Re: insert in batch loading
>Date: Tue, 25 Nov 2003 07:44:33 -0800
>
>How big are yor redo logs? How many o them do you have?
>On 11/25/2003 10:29:37 AM, David Boyd wrote:
> > Hi All,
> >
> > We have some batch loading jobs that truncate the tables first, then
>insert
> > into the tables as select from tables through database link. Those jobs
>run
> > daily. Every time when those jobs run, they cause "cannot allocate new
>log,
> > Checkpoint not complete". All of tables and their indexes are in
>nologging
> > mode. We have /*+append*/ hint in the insert statement. We have 5 redo
> > groups with member of 100 MB. Some tables have more than 1 million
>records.
> > I was wondering if any body knows a method that forces a commit after
> > every 1000 records inserted, which is like delete_commit procedure.
> >
> > David
> >
> > _________________________________________________________________
> > Groove on the latest from the hot new rock groups! Get downloads,
>videos,
> > and more here. http://special.msn.com/entertainment/wiredformusic.armx
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author: David Boyd
> > INET: davidb158_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).
> >
>
>Mladen Gogala
>Oracle DBA
>
>
>
>Note:
>This message is for the named person's use only. It may contain
>confidential, proprietary or legally privileged information. No
>confidentiality or privilege is waived or lost by any mistransmission. If
>you receive this message in error, please immediately delete it and all
>copies of it from your system, destroy any hard copies of it and notify the
>sender. You must not, directly or indirectly, use, disclose, distribute,
>print, or copy any part of this message if you are not the intended
>recipient. Wang Trading LLC and any of its subsidiaries each reserve the
>right to monitor all e-mail communications through its networks.
>Any views expressed in this message are those of the individual sender,
>except where the message states otherwise and the sender is authorized to
>state them to be the views of any such entity.
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.net
>--
>Author: Mladen Gogala
> INET: mladen_at_wangtrading.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.net -- Author: David Boyd INET: davidb158_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).Received on Tue Nov 25 2003 - 10:59:34 CST
 |
 |