Link to home
Start Free TrialLog in
Avatar of Ziad Abuqasem
Ziad AbuqasemFlag for Saudi Arabia

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?
Avatar of johnsone
johnsone
Flag of United States of America image

For the list of parameters that Oracle cares about, I suggest looking at the installation guide.  It gives a pretty comprehensive list.

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.
Avatar of Ziad Abuqasem

ASKER

Ok I want to know
- 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.
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?
ASKER CERTIFIED SOLUTION
Avatar of johnsone
johnsone
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial