poor oracle 8 on solaris8 performance....

From: Liebster, Daniel (Daniel.Liebster@AdeccoNA.com)
Date: Thu Sep 26 2002 - 16:37:57 EDT


Hello.

We recently tried to upgrade an enterprise server running oracle 8 from sol
2.6 to sol8. Under load testing the new configuration performed terribly.
(About 5 x slower at worst!)

The performance degrades with use after a reboot. It starts out a bit faster
that the 2.6 configuration, but then steadily decays under use over a period
of hours.
Trussing oracle showed that a LOT of time is consumed by fsync.
We reverted the system back to sol 2.6, and got the good performance back.

So far we haven't gotten a solution from Sun. Has anyone seen this before?

The data files exist on vxfs filesystems on an EMC.

VRTSvxfs version = 3.4,REV=GA03
VRTSvxvm version = 3.2,REV=08.15.2001.23.27
Solaris = 2.8, mu7, latest patches.
Oracle = 8.1.7

Thanks,

Dan

Dan Liebster Adecco
Enterprise Systems 175 Broadhollow Rd
Tel: 631-844-7258 Melville, NY 11747
Fax: 631-844-7774
Email: daniel.liebster@adeccona.com
_______________________________________________
sunmanagers mailing list
sunmanagers@sunmanagers.org
http://www.sunmanagers.org/mailman/listinfo/sunmanagers



This archive was generated by hypermail 2.1.7 : Wed Apr 09 2008 - 23:24:59 EDT