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 06:02:20 -0800
Message-ID: <1107352940.025679.72000@c13g2000cwb.googlegroups.com>

Frank van Bortel wrote:
> thojens_at_gmx.de wrote:
> > Hi,
> >
> > we are running 9.2.0.6 on Solaris. Each night, a bunch of sqlldr
batch
> > jobs are run and the redo log switches per hour increase
dramatically:
> > 100 and more per hour, while during normal production hours we're
at a
> > maximum of about 25 (usually much lower).
>
> The amount of data written would indeed be the same; there is some
O/S
> overhead in closing a file, and opening a new one (new inode entry),
> but I wouldn't worry about it, unless you see switches within a
second.

OK.

> Query optimal_logfile_size in V$instance_recovery.
Not available in 9i, I'm afraid.

Thorsten Received on Wed Feb 02 2005 - 08:02:20 CST

Original text of this message

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