Very Computer

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

The performance problem you're experiencing is almost certainly
nothing to do with your /etc/system parameters.  All they really do is
set limits on shared memory allocation.  They look like the defaults,
which should be OK for all but the most massive server.

You'd be better off doing standard performance tuning tasks like
checking for disk hot spots, CPU hogs, perhaps investigating whether
the SQL statement is badly written and going down that route.

Cheers,
Simon Denvers

Chello  http://www.chello.com

On Wed, 21 Jun 2000 12:32:46 +0100, "Walter Dorninger"