Re: Solaris9/Oracle9i interupt problem with E4500

hfv wrote:

> 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
>

Not without the DDL and the DML.

1. How many indexes?
2. How many constraints?
3. How many are referential?
4. Any hints like /*+ APPEND */

Thanks for the hardware info but you didn't give anyone much to go on.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)