Re: Avoiding several archiver processes

From: Roman Mirzaitov <rmirzaitov_at_kt.kg>
Date: Mon, 19 Aug 2002 17:10:06 +0600
Message-ID: <ajqjmj$1d8m5u$1@ID-127142.news.dfncis.de>

Hi,

what is a value for LOG_ARCHIVE_MAX_PROCESSES init.ora parameter? If you want to limit the number of archiver processes you run set it to 1. And you can make it dynamically (alter system ...) without restarting a database.
But notice that this parameter limits the MAX number of arc processes. Oracle decides itself how many archiver processes should be run depending on system load (from 1 to LOG_ARCHIVE_MAX_PROCESSES). So if you have 2 processes running it possibly means that load of your system relatively high.

Regards,

--
Roman Mirzaitov
Brainbench MVP for Oracle Administration
www.brainbench.com

"Rick Denoire" <100.17706_at_germanynet.de> wrote in message
news:bmlvlu07jd8rvfj09h6pskjfgd1724424s_at_4ax.com...


> Hello

>

> From the alert_log files, I noticed that I have constantly at least

> two archiver processes that try to archive the same file and produce

> an error message (Oracle 8.1.7 on Solaris 2.7).

>

> How can avoid starting several archiver processes if I only have one

> archive destination? Do I need to restart the instance to do that?

>

> Thanks a lot

>

> Rick

Received on Mon Aug 19 2002 - 06:10:06 CDT