OraFAQ Forum: Server Administration » Limit of the No. of Processes.Urgent

Home » RDBMS Server » Server Administration » Limit of the No. of Processes.Urgent

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

Limit of the No. of Processes.Urgent [message #60493]

Tue, 10 February 2004 23:28

K. Prakash babu
Messages: 46
Registered: July 2001

Member

Can anybody let me know the maximum limit to the No. of Processes in Oracle8i and oracle9i?

Report message to a moderator

Re: Limit of the No. of Processes.Urgent [message #60500 is a reply to message #60493]

Wed, 11 February 2004 04:26

Thiru
Messages: 1089
Registered: May 2002

Senior Member

You mean the maximum number of processes that can connect to a specific instance ?

SQL> select name,value from V$parameter where name='processes'; 

NAME
----------------------------------------------------------------
VALUE
--------------------------------------------------------------------------------
processes
500

Report message to a moderator

Re: Limit of the No. of Processes.Urgent [message #60502 is a reply to message #60500]

Wed, 11 February 2004 05:35

K. Prakash babu
Messages: 46
Registered: July 2001

Member

Your query will give us the total processes set for a database. But, I need what is the maximum limit(the number) we can set it at the database.

Report message to a moderator

Re: Limit of the No. of Processes.Urgent [message #60505 is a reply to message #60502]

Wed, 11 February 2004 06:02

Thiru
Messages: 1089
Registered: May 2002

Senior Member

oh you are asking for the maximum limit . Its OS dependent. For eg on Solaris, the number of maximum processes is dependent on the number of semaphores. SEMMSL determines the maximum number of semaphores in a semaphore set and SEMMNS sets the maximum limit on the system wide semaphores.

-Thiru

Report message to a moderator

Previous Topic:	weird problem about the listener
Next Topic:	row chaining

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Jan 22 18:40:13 CST 2025