When performing end backup on Oracle DB, lgwr has a 4000 millesecond delay. And.. Only wait and %w are high in the iostat result.

                      extended device statistics
r/s    w/s   kr/s   kw/s wait actv wsvc_t asvc_t  %w  %b device
0.0    0.0    0.0    0.0  12.0  0.0    0.0    0.0  100   0 device name

why other value is zero and wait, %w high?

  • Can you provide some more samples (ie. 10 with interval of 1 second)? The first row are statistics since boot time, have a look at next samples to see values for the specified interval. – Lambert Jun 13 at 7:20

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.