Re: How to tune archiver?

From: Pete Sharman <psharman_at_us.oracle.com>
Date: Wed, 21 Apr 1999 14:09:40 -0700
Message-ID: <371E3E94.938F9C68@us.oracle.com>

In addition, you can schedule a cron job (or equivalent on non-Unix OS's) to perform an archive log all. This will start up multiple slave processes to perform the archive, instead of just the ARCH process doing all the work.

But this and the ping-ponging suggestion made by Kelly are addressing the symptoms, not the problem. What are you seeing as the probelm with the archive process? Is it hanging the database because LGWR comes back to try to write to the log that ARCH hasn't completed reading? If so, you probably should look at better sizing the redo logs so this doesn't happen.

HTH. Pete

Kelly Young wrote:

> Steve Hodge wrote:
> >
> > Does anyone have suggestions on how to get the archiver process to work
> > faster in Oracle 7.3.x ?
> >
> > Our alternative at the moment is too run the database in NOARCHIVELOG
> > mode, but I was looking for middle ground?
> >
> > Thanks,
> > Steve
>
> Steve,
> Make sure your redo logs and archive logs are on separate disks
> and that they are on disks with little I/O activity. If you have
> available disks, you should also split the redo logs on separate
> disks. For example, if you have 4 redo logs configured, put logs
> #1 and #3 on one disk; #2 and #4 on another disk. You can also
> experiment with the initialization parameters:
> log_archive_buffer_size and log_archive_buffers
> --
> Kelly Young
> Maricopa Community Colleges
> young_at_maricopa.edu

Regards

Pete

Peter Sharman                             Email: psharman_at_us.oracle.com
WISE Course Development Manager           Phone: +1.650.607.0109 (int'l)
Worldwide Internal Services Education            (650)607 0109 (local)

San Francisco

SQL> select standard_disclaimer, witty_remark 2 from company_requirements;

Opinions are mine and do not necessarily reflect those of Oracle Corporation

"Controlling application developers is like herding cats." Kevin Loney, ORACLE DBA Handbook
"Oh no it's not! It's much harder than that!" Bruce Pihlamae, long term ORACLE DBA

Received on Wed Apr 21 1999 - 16:09:40 CDT