first timer here ... just discovered the place ..:)
I have an oracle performance problem , which I think it mught come
from an sun hardware configuration.
sunfire v240 , two scsi disks .
runnign o.s. + oracle 9i
when I am testing , I am the only user logged to hte oracle instance.
doing a loop insert of about 1000000 rows ,
I noticed very slow performance.
oracle statistics show waits on log write.
iostat shows k/w - no more (at picks) of 5000
when I try to copy a 1 gb file between disks I get k/w around 30000.
when I run same loop on a windows ( Iknow ... I know...) machine (
just a "normal" pc )
I get much bette rperformance.
any idea ??