Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Frequent log switches during sqlldr batch jobs
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