From: "Howard J. Rogers" Newsgroups: comp.databases.oracle.server References: <8ui0lg$s84$1@nnrp1.deja.com> Subject: Re: ARCH question Lines: 39 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 5.50.4133.2400 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 X-Original-NNTP-Posting-Host: 203.134.153.42 Message-ID: <3a0d22db@news.iprimus.com.au> X-Original-Trace: 11 Nov 2000 21:43:39 +1100, 203.134.153.42 Date: Sat, 11 Nov 2000 21:42:42 +1100 NNTP-Posting-Host: 203.134.64.67 X-Trace: news0.optus.net.au 973939420 203.134.64.67 (Sat, 11 Nov 2000 21:43:40 EST) NNTP-Posting-Date: Sat, 11 Nov 2000 21:43:40 EST Organization: CWO Customer - reports relating to abuse should be sent to abuse@optus.net.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 --------------------------------------------------------------------------- wrote in message news:8ui0lg$s84$1@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.