Re: SUNOS 4.1.3 vs Solaris 2.3

A SPARC 10/40 can ably serve a fair number of Oracle users. Try using the SQL*DBA monitor commands to see where the bottleneck is. Watching system activity too will narrow it down. You may benefit from tuning init.ora type parameters (db buffer size etc), re-arranging your database and redo log files across separate physical disks, increasing the SunOS MAXUSERS parameter (should be at least 32), adding additional device swap and increasing maxpgio (swap rate) in the kernel. Lastly, force SunOS only to swap processes only when it needs the memory rather than just because they have been sleeping a while:

adb -w -k /vmunix /dev/mem
maxslp?W0x80
maxslp/W0x80
<ctrl-d>

Solaris 2.3 is, on the whole, a little slower than SunOS 4.1.3 on the same uniprocessor machine. One of the main reasons for this is that a 2.3 machine runs the same kernel whether it has one or many processors (a good thing) but then it has much more code-locking to deal with. Anyway, the upshot is that simply changing to 2.3 will not give enormous gains at all. I'd say you need to take a careful look at the whole arrangement.

Cheers

Gavin Received on Thu Apr 28 1994 - 09:33:26 CEST