Re: 2 arch and db processes

From: Brian Peasland <dba_at_remove_spam.peasland.com>
Date: Tue, 9 Mar 2004 22:50:13 GMT
Message-ID: <404E4A25.E39FCB0B@remove_spam.peasland.com>

> so back to the question, i still cant any definitions of processes in
> my initsid.ora? i did a grep to get rid of all the comments but still
> cant find any process definitions except for this "processes=1000"

If you do not have the PROCESS parameter in your initialization file, then it will default. To verify if your instance is using the default value, then query the ISDEFAULT column of V$PARAMETER. The default value is derived from PARALLEL_MAX_SERVERS. Of course, you can override this value by specifying it in your intialization file, but it is not necessary.

HTH,
Brian Received on Tue Mar 09 2004 - 16:50:13 CST