Re: Oracle on Windows

From: dave <david.best_at_gmail.com>
Date: Wed, 11 Feb 2009 14:27:26 -0500
Message-ID: <9256898f0902111127w5e3e73bwe34e9eb73d14bc8d_at_mail.gmail.com>

Maybe your using an spfile? Login via sqlplus and type

SQL> show parameter spfile

If it shows a value then your using spfiles. So to change the number of processes you'll need to:

alter system set processes = 100 scope=spfile;

Then bounce your instance.

On Wed, Feb 11, 2009 at 2:21 PM, Zelli, Brian <Brian.Zelli_at_roswellpark.org> wrote:
> We have an 3 instances of 10g on a windows server. I needed to change the
> number of processes. So I edited the init file, changed the processes, saved
> it and then bounced the instance. When I do a v$parameter on processes, I
> still get the old number. What the heck is wrong? Do I have to stop the
> service at all? Restart it before I bring up the database? I did set the
> sid for that instance before I logged in.

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Feb 11 2009 - 13:27:26 CST