Home » RDBMS Server » Server Administration » Oracle user process
Oracle user process [message #256940] Tue, 07 August 2007 04:02 Go to next message
preet_kumar
Messages: 195
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 #256943 is a reply to message #256940] Tue, 07 August 2007 04:18 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Give the number of processes you expected to have, no more, no less.
Less you'll have an error when you'll exceed the value.
More you'll use too much resource and slow down performances.

Regards
Michel
Re: Oracle user process [message #256956 is a reply to message #256943] Tue, 07 August 2007 04:54 Go to previous messageGo to next message
preet_kumar
Messages: 195
Registered: March 2007
Senior Member
Thanks Michel

How can i now increase the process,is there any way to check how much user process is being used and way to increase it.
Re: Oracle user process [message #256975 is a reply to message #256956] Tue, 07 August 2007 05:22 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
1/ select count(*) from v$processes.
2/ Change processes parameter.

Regards
Michel
Re: Oracle user process [message #257022 is a reply to message #256975] Tue, 07 August 2007 07:16 Go to previous message
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
Previous Topic: database account is locked
Next Topic: ORA-04043: object RAY.MTE_LOG does not exist
Goto Forum:
  


Current Time: Sat Dec 03 08:02:24 CST 2016

Total time taken to generate the page: 0.11464 seconds