Ziad Abuqasem
asked on
Increase the processes parameter in oracle & HP-Unix kernel parameter
Dear Experts,
I want to increase the parameter in oracle processes and sessions but I have some questions and I need the complete solution
the process parameter in oracle database = 600 in each node and I have 2 nodes RAC
In HP UNIX the process parameter maxuprc = 3780
The questions :
1- how many processes used in HP unix right now included oracle processes & OS processes ?
2- If I want to increase the process parameter in oracle to 700 in each node my unix server will handle this number in each node ?
3- Is the kernel parameter maxuprc is the only parameter responsible for processes or there is any parameter I should check?
I want to increase the parameter in oracle processes and sessions but I have some questions and I need the complete solution
the process parameter in oracle database = 600 in each node and I have 2 nodes RAC
In HP UNIX the process parameter maxuprc = 3780
The questions :
1- how many processes used in HP unix right now included oracle processes & OS processes ?
2- If I want to increase the process parameter in oracle to 700 in each node my unix server will handle this number in each node ?
3- Is the kernel parameter maxuprc is the only parameter responsible for processes or there is any parameter I should check?
ASKER
Ok I want to know
- how many processes used in HP unix right now total number of processes included oracle processes & OS processes ?
- how many processes used in HP unix right now total number of processes included oracle processes & OS processes ?
ps -ef | wc -l
May be off by one or two because of headers, but should be close.
May be off by one or two because of headers, but should be close.
ASKER
The output of this command
in node 1 = 650
in node 2 = 643
I will check again in time tomorrow .
So this mean maxuprc = 3780 and used processes 650 the available processes = 3780 - 650 = 3130 in node one and approximately same in node two
Is this correct?
in node 1 = 650
in node 2 = 643
I will check again in time tomorrow .
So this mean maxuprc = 3780 and used processes 650 the available processes = 3780 - 650 = 3130 in node one and approximately same in node two
Is this correct?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
http://docs.oracle.com/cd/E11882_01/install.112/e49316/pre_install.htm#HPDBI1190
Besides maxuprc, nproc comes to mind as another parameter you would want to look at.
In addition to the number of processes, you are going to want to look at all the parameters that start with sem. These are the semaphore parameters. Each process/session needs a semaphore.