Re: ARCH question

From: Howard J. Rogers <howardjr_at_www.com>
Date: Sat, 11 Nov 2000 21:42:42 +1100
Message-ID: <3a0d22db@news.iprimus.com.au>

The advice is to comment out the line in your init.ora that says log_archive_start=true.

That will switch ARCH off.

It's unfortunately perfectly possible to have the background process sitting there doing nothing apart from just taking up memory even when you are in noarchivelog mode, as you've discovered. You just have to remember to prevent ARCH being switched on automatically at each Instance startup.

You can do it dynamically, to: alter system archive log stop;

But if you don't edit the init.ora, then ARCH will revert to being switched on next time you bounce the Instance.

Regards
HJR

--
---------------------------------------------------------------------------
Opinions expressed are my own, and not those of Oracle Corporation
Oracle DBA Resources:               http://www.geocities.com/howardjr2000
---------------------------------------------------------------------------


<kal121_at_my-deja.com> wrote in message news:8ui0lg$s84$1_at_nnrp1.deja.com...


> I turned off archive mode on a test database here. It's still running

> the ARC0 process. Is this necessary?

>

> In the alert.log, everytime it does a checkpoint, there are messages

> from ARC0 such as "media recovery disabled". So there obviously is some

> overhead from having it on.

>

> Advice?

>

>

> Sent via Deja.com http://www.deja.com/

> Before you buy.

Received on Sat Nov 11 2000 - 04:42:42 CST