Hi,

new job, new environment.

I found two Solaris Database Server with IDS 9.40.FC4W2 here. The one has 32
GB RAM the other 12 GB RAM.
Server db1 (32 GB) Uname -a: SunOS db1 5.9 Generic_117171-12 sun4u sparc
SUNW,Netra-T12
Server db2 (12 GB) Uname -a: SunOS db2 5.8 Generic_108528-29 sun4us sparc
FJSV,GPUSC-M

Both systems are under heavy load. Monitoring the waitstates shows that AIO
und BUFFER waits are higher than running. onstat -p show 92 % cached reads
and only 50 % cache writes on the bigger system and 96 % to 83 % on the
smaller one.

The onconfig param BUFFER is set to 350.000 (700 MB) in both systems. In my
opinion the systems would work faster with a much higher amount of buffers
(for example 2.500.000 =5 GB).

The bigger system shows up to 1500 user sessions the smaller up 400. In both
system the SHMVIRTSIZE is 491520 and SHMADD is 98304. The bigger system
really reserves additional virtual memory segments when running. The amount
of DATA is about 1 TB for each server.

What value do you suggest for the BUFFERS (and CLEANERS, LRUS, LRU_MAX_DIRTY
and LRU_MAX_DIRTY)? Are there any restrictions with _Solaris_?

Any suggestions are welcome.

TIA
Reinhard.