Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: 2 arch and db processes

Re: 2 arch and db processes

From: yls177 <yls177_at_hotmail.com>
Date: 5 Mar 2004 01:53:55 -0800
Message-ID: <c06e4d68.0403050153.70d87f4c@posting.google.com>


srivenu_at_hotmail.com (srivenu) wrote in message news:<1a68177.0403040137.5bcc3152_at_posting.google.com>...
> I dont know why you have 2 DBWR process. (You sure they belong to the
> same instance ?).
> But even if you have not set the LOG_ARCHIVE_MAX_PROCESSES parameter,
> you can have multiple archive processes running in an Oracle instance.
> LOG_ARCHIVE_MAX_PROCESSES specifies the number of archiver background
> processes that Oracle starts during instance startup.
> The actual number of archiver processes in use may vary subsequently
> based on archive workload.
> One process will archive one log. If one process is busy and there are
> two logs to archive, the second one will kick in. Generally, if one
> can keep up, only one will ever be active.
>
> regards
> Srivenu

agreed. but now i wanted to know where to set the number of dbwr or arch.. and there is no spfile whatever.

advise? Received on Fri Mar 05 2004 - 03:53:55 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US