Re: Oracle on Windows
- From: dave <david.best@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Wed, 11 Feb 2009 14:27:26 -0500
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@xxxxxxxxxxxxxxx> 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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
