Re: Solaris 2.6 /etc/system settings

Hello Walter:

If you plan to have several instances you will need to increase the following parameter:

set semsys:seminfo_semmns=700

The value is determined by adding the number of processes for each instance with some overhead.
Oracle provides some documentation on this. I suggest that you check Metalink.

Laurent

"Walter Dorninger" <walter.dorninger_at_aon.at> wrote in message news:8iq5ma$1lo$1_at_wrath.news.nacamar.de...
> 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