IOWAIT time
Date: Mon, 24 May 2004 15:20:41 +0200
Message-ID: <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 Mon May 24 2004 - 15:20:41 CEST