OraFAQ Forum: Performance Tuning » Increasing number of Processes

Home » RDBMS Server » Performance Tuning » Increasing number of Processes

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

Increasing number of Processes [message #402886]

Wed, 13 May 2009 00:05

nishantprabhakar
Messages: 28
Registered: April 2009
Location: UAE

Junior Member

Hi

What are the measurement I have to take If I am going to increase the number of Processes from 150 to 200. Do I need to change any other parameter value or simply I need to run the query (alter system set processes=200 scope=spfile;)

System is already running with ASMM (Automatic Shared Memory Management) enabled.

Also please let me know if I have to change anything in Listener.ora.

Thanks

Report message to a moderator

Re: Increasing number of Processes [message #402891 is a reply to message #402886]

Wed, 13 May 2009 00:12

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/

>What are the measurement I have to take If I am going to increase the number of Processes from 150 to 200.
system parameters, but we don't know what Operating System (name & version) or Oracle version (to 4 decimal places).

Report message to a moderator

Re: Increasing number of Processes [message #402912 is a reply to message #402891]

Wed, 13 May 2009 01:23

nishantprabhakar
Messages: 28
Registered: April 2009
Location: UAE

Junior Member

Operating System : Windows 2003 server XP (Enterprise Edition)
Oracle : version 10g
RAM : 4 GB

SGA : 924
PGA : 100
we are using spfile.

Application : JDEdwards
Users : Nearly 100 -150

Report message to a moderator

Re: Increasing number of Processes [message #403127 is a reply to message #402886]

Wed, 13 May 2009 19:24

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

When all else fails Read The Fine Manual

http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/initparams.htm#i1132608

I realize that it is easier for you to have me lookup the answers for you, rather than you doing so yourself.

Enjoy!

>Oracle : version 10g
Not exactly 4 decimal places as previously requested.
Could you benefit from remedial counting training?

[Updated on: Wed, 13 May 2009 19:26]

Report message to a moderator

Re: Increasing number of Processes [message #403675 is a reply to message #403127]

Mon, 18 May 2009 00:41

nishantprabhakar
Messages: 28
Registered: April 2009
Location: UAE

Junior Member

I have already read this document.. but I wanted to know from a real time environment..

I will simplfy my question.

Can I directly go ahead and increase Oracle processes from 150 to 180?
(using the command Alter system set processes=180 scope =spfile;)

Report message to a moderator

Re: Increasing number of Processes [message #403691 is a reply to message #403675]

Mon, 18 May 2009 01:55

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

Senior Member
Account Moderator

Quote:

I will simplfy my question.
Can I directly go ahead and increase Oracle processes from 150 to 180?
(using the command Alter system set processes=180 scope =spfile;)

Yes.

Regards
Michel

[Updated on: Mon, 18 May 2009 01:56]

Report message to a moderator

Re: Increasing number of Processes [message #403760 is a reply to message #403691]

Mon, 18 May 2009 09:14

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Michel Cadot wrote on Sun, 17 May 2009 23:55

Quote:

I will simplfy my question.
Can I directly go ahead and increase Oracle processes from 150 to 180?
(using the command Alter system set processes=180 scope =spfile;)

Yes.

Regards
Michel

No, because PROCESSES can not be changed dynamically.
It can be changed only when DB is down.

Report message to a moderator

Re: Increasing number of Processes [message #403774 is a reply to message #403760]

Mon, 18 May 2009 10:12

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

Senior Member
Account Moderator

SQL> Alter system set processes=180 scope =spfile;

System altered.

Syntaxically he can.

Regards
Michel

Report message to a moderator

Re: Increasing number of Processes [message #403776 is a reply to message #402886]

Mon, 18 May 2009 10:24

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

I stand corrected.
Long story short is/was I misread response.
scope=spfile succeeds
scope=both fails - which is what I thought I saw.

Report message to a moderator

Previous Topic:	Queries on the fly using DBMS_ADVANCED_REWRITE
Next Topic:	performance Tunning

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jun 02 12:42:39 CDT 2024