Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Solaris9/Oracle9i interupt problem with E4500
"hfv" <wwcorigan_at_yahoo.com> wrote in message
news:in67svkf79gp1v8s43ilsrd1rb9kbh1jso_at_4ax.com...
> 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
>
What do the io waits look like when you are doing the load. Is the A1000 OK? Have you tried creating a tablespace on one of the E4500 internal drives and reading from / loading into it. Received on Wed Nov 26 2003 - 03:30:26 CST