Chris,
I have experience with SUN E3500s going over 100MBit to a NetApp F760. We run pretty much only the latest release of 8.1.7 in various compatibility modes. Listener problems....intermedia problems....etc in earlier versions.
Yes, we use 8K blocks. Has anyone run snoop to see if there is excessive calling to DNS for a lookup of the filer. That is something I saw recently.
Is the Network dedicated to the NetApp? Are you on Gigabit Ethernet?
Also, I think that 8.1.7 is better on Solaris 2.8.
Anyway, as far as the NetApp goes, I have seen close to local (SUN) RAID 0 performance over 100MBit and twice that fast over Gig.
I have done a bit of tuning on an E5000 also. I would be interested in continuing this thread with you.
I think some IT folks from my group were up in Livermore a couple of weeks ago.
Joe
At 04:46 PM 5/10/02 -0700, Chris Moll wrote:
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