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