Bryan,
 
What "tunings" did you apply to NFS, Filer, etc. ?
Check below for some recommended values.
 
Simply comparing filer ops is not a good measure of performance.
 
For example:  setting nfs mount options in /etc/vfstab to
hard, intr, suid, rsize=32738, wsize=32768, proto=udp, vers=3
(which is a known good configuration), will result in "lower" nfs ops than
say using r/wsize=8192, but your thruput will be the same or better.
 
If I read you specs right, you're using 1xFC9 shelf for 2 volumes ?
Assuming you are using the recommended spare disk, you max.
number of spindles for say vol0 would be 4. 
The WAFL filesystem improves in performance with increasing number
of spindles.  Try moving the index's over to vol0, delete vol1 and expand
vol0 by 2 or more disks.   In a small volume environment, performance will
be enhanced by placing just the online redo logs onto your local drive.
Once you have more spindles you can place them on a seperate volume
on the filer and mount them over your 2nd GbE link.
 
It is ideal to seperate sequential writes (such as redo logs) from random i/o
over a separate GbE link and separate volume.
 
To ensure your problem isn't the GbE connection, try testing for
raw thruput of data by issuing a "dd if=/dev/zero of=/toaster/test bs=32k"
command. Then umount and remount the filer mount point (to avoid local caching)
and read it back.   If the numbers are low, you may have a duplex-mismatch and need
to ensure auto-negotiation is enabled for the NICs in the E3500.
 
Needless to say, ensure Solaris 2.7 has the latest patches applied and the F840 is using
at least Data ONTAP 6.0.1R3 or better Data ONTAP 6.1 which is at FCS on
http://now.netapp.com
 
Also consult the Technical Reports below for further information:
 
http://www.netapp.com/tech_library/3047.html
http://www.netapp.com/tech_library/3105.html
 
/M/
 

Michael Lenzer
Oracle TME
Network Appliance Inc.
495 East Java Dr
Sunnyvale, CA 94089
USA

-----Original Message-----
From: brynay_cradle [mailto:bryany@cradle.com.tw]
Sent: Tuesday, April 03, 2001 11:30 PM
To: toasters
Subject: performance question ablout oracle on F840 filer

Hi ,
My customer setup oracle 8.15 on sun E3500 (Solaris.7)
and put oracle database on filer F840 , but performance is poor.
 
Hardware environment as
 
Filer 840
Giga Ethernet II  * 2
FC9 disk shelf  * 1
about 350 GB
 
Sun E3500 (Solaris.7)
Cpu 1 ~ 4
memory 1 GB
giga Ethernet * 2 ( direct to filer )
 
configuration as
oracle database        on /vol/vol0 use e6 giga ethernet channel
oracle index             on /vol/vol1 use e7 giga ethernet channel
 
load data to database table about 70000 records , filer ops 1000 ~ 2000
sun 1 cpu usage 30% ~ 40%
even add to 4 cpu (20% ~ 30%, never over 50%) ,
oracle process speed still slow , ops increase just to 2500 ~ 3000
it seems filer wait for sun process oracle data , but I can not increase cpu load
 
I tuned filer and sun , gigaethernet and nfs configurations already , but performance do
not get better.
Could you kind to provide any suggestion or solution for this case
 
Thanks a lots
 
Cradle Technology Corp.
Infrastructure Integration Department
Bryan Yuan
Tel: (886) 2 87682688 Ex: 634
bryany@cradle.com.tw