Home » RDBMS Server » Performance Tuning » Increasing number of Processes
Increasing number of Processes [message #402886] Wed, 13 May 2009 00:05 Go to next message
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
Re: Increasing number of Processes [message #402891 is a reply to message #402886] Wed, 13 May 2009 00:12 Go to previous messageGo to next message
BlackSwan
Messages: 25050
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).
Re: Increasing number of Processes [message #402912 is a reply to message #402891] Wed, 13 May 2009 01:23 Go to previous messageGo to next message
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
Re: Increasing number of Processes [message #403127 is a reply to message #402886] Wed, 13 May 2009 19:24 Go to previous messageGo to next message
BlackSwan
Messages: 25050
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 Go to previous messageGo to next message
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;)
Re: Increasing number of Processes [message #403691 is a reply to message #403675] Mon, 18 May 2009 01:55 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
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 Go to previous messageGo to next message
BlackSwan
Messages: 25050
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.
Re: Increasing number of Processes [message #403774 is a reply to message #403760] Mon, 18 May 2009 10:12 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
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
Re: Increasing number of Processes [message #403776 is a reply to message #402886] Mon, 18 May 2009 10:24 Go to previous message
BlackSwan
Messages: 25050
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.
Previous Topic: Queries on the fly using DBMS_ADVANCED_REWRITE
Next Topic: performance Tunning
Goto Forum:
  


Current Time: Sat Dec 10 04:59:25 CST 2016

Total time taken to generate the page: 0.12006 seconds