RE: Oracle on Windows

From: Zelli, Brian <>
Date: Wed, 11 Feb 2009 14:43:23 -0500
Message-ID: <>

No spfile that I know of. In looking at the startup script, it just has startup pfile=c:\yadayadayada\init.ora  


-----Original Message-----
[] On Behalf Of dave Sent: Wednesday, February 11, 2009 2:27 PM To:
Subject: Re: Oracle on Windows

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


This email message may contain legally privileged and/or confidential information.  If you are not the intended recipient(s), or the employee or agent responsible for the delivery of this message to the intended recipient(s), you are hereby notified that any disclosure, copying, distribution, or use of this email message is prohibited.  If you have received this message in error, please notify the sender immediately by e-mail and delete this email message from your computer. Thank you.
Received on Wed Feb 11 2009 - 13:43:23 CST

Original text of this message