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