Re: Memory problem while running Oracle

First, see the parameter :
processes in the init.ora file.

Then the kernel's parameters :

NPROC           200
SHMMAX          2097152

are low.

in your ps there is 81 process and 4 oraclePROD. whith 20 connexions how many proceses run on the machine ? You have one connexion for each sqlforms.

You can use sqlnet V2 and the multithreading to cut the number of processes.

Your SGA is quite litle. You have to increase the SHMMAX to get a bigger one. Heach Oracle process use some place in the SGA.

The opinion are mine and not implied my employer... Received on Fri Sep 06 1996 - 00:00:00 CEST