IOWAIT time

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Linux@Marco
    #1

    IOWAIT time

    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...with out 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



    Tags: None
    • Romeo Olympia
      #2
      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@Marc o" <mmueller@XXX3d enter.comwrote in message news:<c8ssra$4m 5$1@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...with out 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

        Comment

        Previous template Next
        Working...