Re: Oracle on Windows

From: dave <>
Date: Wed, 11 Feb 2009 14:27:26 -0500
Message-ID: <>

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 <> 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.

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

Original text of this message