Solaris 2.6 /etc/system settings

Hi,

I have a question concerning the settings of shared memory on a E450 running Solaris 2.6 with 2GB RAM and 2 CPUs. Could anyone point me out the common settings for the parameters listed below ?

I'm running Oracle 8.1.5 on this machine and have some problems with the performance of "ORDER BY" and shared memory and I think it has to do with the settings in /etc/system.

The current settings are listed below. I'm not sure if the settings are correct, so can anyone give me a hint what the correct/better values could/would be ?

set shmsys:shminfo_shmmax=4294967295
set shmsys:shminfo_shmmin=1
set shmsys:shminfo_shmmni=100
set shmsys:shminfo_shmseg=10
set semsys:seminfo_semmni=100
set semsys:seminfo_semmsl=100
set semsys:seminfo_semmns=200
set semsys:seminfo_semopm=100
set semsys:seminfo_semvmx=32767

Thanks a lot
Walter Received on Wed Jun 21 2000 - 00:00:00 CDT