dbTalk Databases Forums  

how to increase processes?

comp.databases.oracle comp.databases.oracle


Discuss how to increase processes? in the comp.databases.oracle forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
tracy
 
Posts: n/a

Default how to increase processes? - 08-12-2004 , 03:07 AM






hi,
how can i specifies the maximum number of operating system
user processes that can simultaneously connect to an Oracle
Server. Now, my processes is 350 and session is 390 and
parallel_max_server=5.

Pls let me know the command and i want to make it as permananet change
.. I am using oracle 9.2.0.2.0.

Thanz.

Regards,
Lee Cho

Reply With Quote
  #2  
Old   
sybrandb@yahoo.com
 
Posts: n/a

Default Re: how to increase processes? - 08-12-2004 , 09:36 AM






tracykim10 (AT) yahoo (DOT) com.hk (tracy) wrote in message news:<5c91cce9.0408120007.54a3d8dc (AT) posting (DOT) google.com>...
Quote:
hi,
how can i specifies the maximum number of operating system
user processes that can simultaneously connect to an Oracle
Server. Now, my processes is 350 and session is 390 and
parallel_max_server=5.

Pls let me know the command and i want to make it as permananet change
. I am using oracle 9.2.0.2.0.

Thanz.

Regards,
Lee Cho
Just increase the processes parameter. Further details in the manual
you are too lazy to read.

Sybrand Bakker
Senior Oracle DBA


Reply With Quote
  #3  
Old   
Mark D Powell
 
Posts: n/a

Default Re: how to increase processes? - 08-12-2004 , 10:18 AM



tracykim10 (AT) yahoo (DOT) com.hk (tracy) wrote in message news:<5c91cce9.0408120007.54a3d8dc (AT) posting (DOT) google.com>...
Quote:
hi,
how can i specifies the maximum number of operating system
user processes that can simultaneously connect to an Oracle
Server. Now, my processes is 350 and session is 390 and
parallel_max_server=5.

Pls let me know the command and i want to make it as permananet change
. I am using oracle 9.2.0.2.0.

Thanz.

Regards,
Lee Cho
Lee, pull the Oracle 9.2 Reference manaul and look up processes.

If you are running on UNIX you might also want to check on the ulimit
command which limits at the OS level how many processes, files, etc...
a user account may have.

By the way when a newsgroup has subgroups you should generally post to
the subgroups and not the newsgroup. Comp.database.oracle was split
several years ago into .server, .misc, .tools, and .marketplace.

HTH -- Mark D Powell --


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.