OraFAQ Forum: Server Administration

Home » RDBMS Server » Server Administration » Oracle user process

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Report message to a moderator

Re: Oracle user process [message #256943 is a reply to message #256940]

Tue, 07 August 2007 04:18

Michel Cadot
Messages: 68686
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

Report message to a moderator

Re: Oracle user process [message #256956 is a reply to message #256943]

Tue, 07 August 2007 04:54

preet_kumar
Messages: 204
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.

Report message to a moderator

Re: Oracle user process [message #256975 is a reply to message #256956]

Tue, 07 August 2007 05:22

Michel Cadot
Messages: 68686
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

1/ select count(*) from v$processes.
2/ Change processes parameter.

Regards
Michel

Report message to a moderator

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

Report message to a moderator

Previous Topic:	database account is locked
Next Topic:	ORA-04043: object RAY.MTE_LOG does not exist

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 14:04:48 CDT 2024