Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: 65% io wait on batch insert
Agree with all BV says, and can only add/ask: have you
considered using SQL*Loader in append mode?
Billy Verreynne wrote in message <7170tu$cm2$1_at_hermes.is.co.za>...
>Nir Dagan wrote in message <3636C972.F668509F_at_exlibris.co.il>...
>>I'm using a batch job to insert a lot of rows into a table with 1 index
>>in Oracle 7.3.3 server on SunSolaris2.5.1. It seems like all my CPU
>>resources were directed to iowait (65%). And the job itself gets only 9%
>>CPU.
>
>
>Not a lot of info to go on. Waiting for i/o can be a symptom of various
>"problems". Also waiting for i/o is a bit of a misnomer as it only
indicates
>that there are outstanding i/o requests in the kernel. There can also be an
<snip>....
Received on Thu Oct 29 1998 - 22:44:36 CST