i grep db, grep arch in my initsid.ora but did not show anything that
indicates the 2 arch ,dbwr processes?

i did a grep ora_ar and grep ora_db and got 2 of these each.

where are they defined?

Is it possible that you are using a SPFILE, or that you didn't use the
INIT.ORA that your database is using?

Cheers,
Brian

yls177 wrote:
>
> i grep db, grep arch in my initsid.ora but did not show anything that
> indicates the 2 arch ,dbwr processes?
>
> i did a grep ora_ar and grep ora_db and got 2 of these each.
>
> where are they defined?

--
================================================== =================

Brian Peasland
dba@remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
the three"

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

srivenu@hotmail.com (srivenu) wrote in message news:<1a68177.0403040137.5bcc3152@posting.google.c om>...
> 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?

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

You set this in your initialization file, SPFILE or INIT.ORA. Make sure
that the INIT.ORA you are modifying is the one that the database is
actually using.

HTH,
Brian

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

You set this in your initialization file, SPFILE or INIT.ORA. Make sure
that the INIT.ORA you are modifying is the one that the database is
actually using.

HTH,
Brian