Re: Q: Performance probs SC2000/Sol 2.3/Oracle7.0.16

Joe.Ammann_at_svusenet.ubs.ch wrote:
: Hi all,
 

: we have set up a rather large DB machine and experience heavy
: performance problems. Maybe someone has helpful suggestions. Here the
: configuration:
 

: Sun SC 2000:
: - 12 processors (currently 11, one blew up ;-)
: - 1.8 GB RAM
: - 6 x 2.9 GB F/W differential SCSI for OS uses
: - 10 x SparcStorageArray with 30 GB (30 x 1GB) for DB
: 2 way mirrored, so 150 GB are there
 

: - Solaris 2.3 w/ patches (101318-54)
: - Online Disk Suite 2.01
: - Oracle 7.0.16

.
.
.

: --
: Joe

Joe,

I'm replying from home...have the week off; but we had the same problems and had one helluva time getting sun to solve the problem. There's a few things that they finally came up with:

1. don't use the 2.9 drives; they're way to big. use 1gb drives instead (yeah, real nice to know after you put up a lot of $ for them).
2. there's a paper out (not sure if it's white) that sun uses internally for optimizing oracle to run on sun...it contains a lot of info for setting parameters in the /etc/system file. Some of the paramaters have to do with mouse/monitor interaction...important on a sparc 5 or 20, but a moot point on a 1000 or 2000.

		set slowscan=100
		set fastscan=16000
		set autoup=120

	Here are some other recommendations that they also made:

		set lotsfree=512
		set desfree=256
		set minfree=128
		set ncsize=10000
		set ufs_ninode=20000

3. Amdahl has a package called A+ Edition, certified by Sun, that
	changes a lot of different parts of Solaris 2.3.  It really
	won't show much improvement unless you're in the 10-12+ CPU
	range...we only have 4 on our 2000.  Anyways, it did fix
	some our problems (like the nasty telnet timeout bug) and
	gave us a small performance boost.

good luck,
richard

deal_at_cs.fsu.edu Received on Thu Dec 29 1994 - 04:01:05 CET