Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!postnews.google.com!c13g2000cwb.googlegroups.com!not-for-mail
From: "Thorsten Jens" <thojens@gmx.de>
Newsgroups: comp.databases.oracle.server
Subject: Re: Frequent log switches during sqlldr batch jobs
Date: 2 Feb 2005 06:02:20 -0800
Organization: http://groups.google.com
Lines: 26
Message-ID: <1107352940.025679.72000@c13g2000cwb.googlegroups.com>
References: <1107345398.659511.227130@f14g2000cwb.googlegroups.com>
   <ctqibn$lrv$1@news4.zwoll1.ov.home.nl>
NNTP-Posting-Host: 149.211.153.105
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1107352945 10693 127.0.0.1 (2 Feb 2005 14:02:25 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Wed, 2 Feb 2005 14:02:25 +0000 (UTC)
In-Reply-To: <ctqibn$lrv$1@news4.zwoll1.ov.home.nl>
User-Agent: G2/0.2
Complaints-To: groups-abuse@google.com
Injection-Info: c13g2000cwb.googlegroups.com; posting-host=149.211.153.105;
   posting-account=04xo1wwAAACGFsrxghT3BGMK-q2BKabl
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:234798


Frank van Bortel wrote:
> thojens@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