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 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/3047.html http://www.netapp.com/tech_library/3105.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 mailto:bryany@cradle.com.tw