Re: Changing "processes" parameter in the init.ora file...
Originally posted by bikramjeet77
If I can, can I change the parameter value while the database is still running ??
It will be a great help if someone could answer my questions.
As far as changing the parameters on a running database you need to look at a copy of the SQL 8i Reference. Look it up at http://otn.oracle.com/documentation/content.html. You'll probably need to register, but I think its free. Ninety percent of the parameters can be changed on a running database by doing an Alter System or Alter Database command. Any changes made in the init.ora do not take effect until the database is restarted.