Janne,
Thanks very much for your wonderful detail suggestion. I'll definitely use
it to analyze the redo.
David
From: Jan Korecki [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: insert in batch loading
Date: Tue, 25 Nov
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
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
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
We have 5 groups of redo log. Each group has two members. Each member is
100 MB.
David
From: Mladen Gogala [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: insert in batch loading
Date: Tue, 25 Nov 2003 07:44:33 -0800
How
PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: insert in batch loading
Date: Tue, 25 Nov 2003 08:19:26 -0800
David Boyd wrote:
Hi All,
We have some batch loading jobs that truncate the tables first, then
insert into the tables as select
.
The table has two indexes. We don't set them to unusable during inserting.
David
From: Jan Korecki [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: insert in batch loading
Date: Tue, 25 Nov 2003 08:19:26 -0800
David
checkpoint? Thanks for your inputs.
David
From: Mladen Gogala [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: insert in batch loading
Date: Tue, 25 Nov 2003 12:49:28 -0800
What does it mean that redo log size dominates checkpoint
them to unusable
during inserting.
David
From: Jan Korecki [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: insert in batch loading
Date: Tue, 25 Nov 2003 08:19:26 -0800
David Boyd wrote:
Hi All,
We have some batch loading