| Oracle user process [message #256940] |
Tue, 07 August 2007 04:02  |
preet_kumar
Messages: 204
Registered: March 2007
|
Senior Member |
|
|
While creating the database on 10g there is an option to choose the number of Operating system User process the default of which is 150.
What does it exactly mean and if there any limitation of setting this higher whats the advantage.
Thanks
|
|
|
|
|
|
|
|
|
|
| Re: Oracle user process [message #257022 is a reply to message #256975] |
Tue, 07 August 2007 07:16  |
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
|
Senior Member |
|
|
And when you change PROCESSES parameter you need to restart Oracle Server.
alter system set processes = value SCOPE=SPFILE;
restart ---> shutdown immediate + startup
Because processes parameter is not modifiable.
Regards
Taj
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
