Q: [Oracle 8i e450 UFS] Solaris8->9 upgrade: Performance Boost?- Real World Experience ?

From: Tim Chipman (chipman@ecopiabio.com)
Date: Thu Oct 09 2003 - 12:28:19 EDT


Hi All,

I've done a bit of digging but cannot find anything other than "Sun
promo material", and ideally, I'm hoping to get some "real world
experience from the trenches" which is relevant.

We've got an Oracle8i database running on a "Solaris8 e450"
(4x400mhz/2gigs ram/solaris8 10/02 fully patched, "important data" {WRT
performance} is on a T3 and less critical data is on an A1000; using
vanilla logging UFS filesystems for the oracle data slices).

Reading the solaris9 release & feature notes, I am particularly tempted
by the "UFS Concurrent Direct I/O" features that claim to provide (in
certain circumstances) "87% performance increase over directIO alone"
[this stat quoted from the URL
http://wwws.sun.com/software/solaris/sparc/solaris9_features_scalability.html
  ]

However, being familiar with the reality that "certain circumstances"
often refers to .. conditions that will not ever be relevant to me ... I
thought I would try to get any feedback from real-world deployments
which have migrated Oracle8 DataBases from Solaris8 to Solaris9 while
staying on the same "not terribly current Sparc Hardware", and if there
were indeed any performance increases (decreases?) observed.

Ultimately, I realize the only way to be *certain* is to jump in and try
it myself -- but prior to this I thought it would be prudent to hear
(ideally) at least a couple of success stories to help sway my reluctant
stodgey "things work just fine as they are right now, thank you very
much" side of myself :-)

Many thanks, and as always, a summary will follow ..

Tim Chipman
_______________________________________________
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:27:16 EDT