Re: Why does Oracle start another arc process?

Starting with Oracle9iR2 (9.2.0.0), the log_archive_max_processes init.ora parameter *really* does limit the number of ARCH processes that will be spawned. Also, the default value for this parameter was changed to "2" (of course, you can dynamically change it smaller or larger as your system requirements dictate).

FYI. Rick

Vince Laurent wrote:

> Well, we run HP-UX 11.00 and 11.11. The extra processes show up then
> disappear. I know this is happening because we use HP IT/Operations
> to monitor our databases (all 8.1.7.3 now).
>
> Thanks for all the info on this too!
>
> On Sat, 29 Jun 2002 08:08:11 +1000, "Howard J. Rogers"
> <dba_at_hjrdba.com> wrote:
>
> >Exactly. I've checked it on Solaris and NT/W2K/XP, so it would be nice to
> >know if HP was also affected. But like you, I think I can live with a few
> >idle processes!
> >
> >"Sean M" <smckeownNO_at_BACKSIESearthlink.net> wrote in message
> >> "Howard J. Rogers" wrote:
> >> >
> >> > Oracle is then supposed to kill off the additional archiver process, and
> >> > re-spawn them if needed. But I've rarely seen it do it. The additional
> >> > processes seem to hang around for ever, idle. Not sure if that's a
> >(minor) bug, or a feature, or operating system dependent.
> >>
> >> I've seen this before too, but for the life of me I can't remember what
> >> version of Oracle or whether it was Sun or HP/UX. I haven't checked
> >> recently, but I was never really worried much about it to begin with...
> >> no real harm done except maybe a small waste of resources.
Received on Mon Jul 01 2002 - 11:42:22 CDT