Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Frequent log switches during sqlldr batch jobs

Re: Frequent log switches during sqlldr batch jobs

From: Thorsten Jens <thojens_at_gmx.de>
Date: 2 Feb 2005 22:38:31 -0800
Message-ID: <1107412711.540061.313400@z14g2000cwz.googlegroups.com> 





Frank van Bortel wrote:

>




> Take about 5 switches per hour, then. Gives you 12 minutes

> worth of transactions to loose when the current redolog file

> crashes.




If I sized the redo logs to have ~5 switches per hour during high load
times, then I'd have almost no switches at all during the day -- which
would mean a lot of lost work in the worst case.
Thorsten
Received on Thu Feb 03 2005 - 00:38:31 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US