Solaris9/Oracle9i interupt problem with E4500

Hardware-
8 processor E4500, 4gig memory
 A1000 disk array using raid 0+1 (although it different connfiguation doesn't solve the problem)

Symptom
Inserting a million rows, (sh.sales) into a new database the e4500 takes about 2 minutes. Different configuration of raid, SGA and so forth don't have a significant impact on the insert speed.

Note: the same insert on a PC running windows takes less than 20 seconds.

vmstat reports (in one second intervals) in = 1300-1599 (Interupts - normally this runs around 100-150) sy =1000 - 7500 (System calls)
cs = 500 -1400 (Context switches)

All of the above variables are roughly positively correlated (if in goes up so does sy and cs

Does anyone have any ideas on what is going on here?

Thanks
hvf   Received on Tue Nov 25 2003 - 16:38:18 CST