Anybody seen any performance changes with going to oracle 8.1.7 (from 8.0.5) with the databases on netapp storage? (host is sun enterprise 5000, solaris 2.6).
Many batch jobs ran dramatically slower on a DB that was upgraded from 8.0 to 8.1. Fingers are getting pointed to the netapp, partly 'cause nobody wants to contemplate down-revving the database. The fact that the jobs ran fine on the netapp before the upgrade would seem to exonerate it but it's a convenient target...
A few efforts at tuning the DB seemed to reclaim much of the loss; I'm no oracle expert but it sounds to me like the DB is far from optimal, for example it's set to a 2k block size which seems questionable to me.
Anyway - anyone encountered anything similar?
Chris Moll Lawrence Berkeley Laboratory