Re: IOWAIT time

Why are you deleting such a large number of rows to begin with? I sure hope this is not part of some highly regular routine in a very active database. C'mon, there must be other ways of "removing" those rows. More background on your requirement might help.

As for the IO waits, it all depends on a lot of things like the speed of your disks and how your data/datafiles/logfiles are spread out over them. Without oracle-specific stats/waits, we can only surmise. Get us these and we'd know more for certain. But see my 1st paragraph first.

"Linux_at_Marco" <mmueller_at_XXX3denter.com> wrote in message news:<c8ssra$4m5$1_at_newshispeed.ch>...
> Hi there,
>
> I have oracle 8i on a SUNE420R dual processor with 2GB ram, when i try to
> delete a large amount of rows (2'400'963) the iowait time goes to 70 - 90%
> and the delete time is between 4 - 5 hours. I am not a DBA but i search some
> solution in internet...without a result...the output of mpstat:
>
> CPU minf mjf xcal intr ithr csw icsw migr smtx srw syscl usr sys wt idl
> 1 0 9 289 1209 1095 574 21 45 9 13 340 5 2 61 32
> 2 0 21 149 145 113 580 31 76 13 12 2900 9 3 53 35
> CPU minf mjf xcal intr ithr csw icsw migr smtx srw syscl usr sys wt idl
> 1 0 36 305 1085 979 341 19 25 1 0 237 13 0 77 10
> 2 1 30 150 120 100 394 16 24 2 4 256 7 2 69 22
>
> As you can see the wt is between 60% and 80%.....there is a parameter to
> optimize the write i/o time for the database....
>
> TOP COMMAND:
> 169 processes: 168 sleeping, 1 on cpu
> CPU states: 23.8% idle, 0.0% user, 6.0% kernel, 70.2% iowait, 0.0% swap
> Memory: 2048M real, 273M free, 1516M swap in use, 4075M swap free
>
> Thanks...
>
> Marco
Received on Tue May 25 2004 - 04:16:02 CEST