Re: 2 arch and db processes

> to round it off, we cant change the value in v$parameter right?
>
> for this to happen, we have to put it in initsid.ora

Some parameters can be changed "on the fly". You'll have to look in V$PARAMETER, specifically the ISSYS_MODIFIABLE column. This will let you know if you can use the ALTER SYSTEM command to modify it "on the fly". If not, then your only recourse is to modify your INIT.ORA file, then you will have to bounce the database.

HTH,
Brian

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

Brian Peasland
dba_at_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"