Sponsored Content
Operating Systems AIX IO queue maxtime over 1 minute Post 303009222 by veslar on Monday 11th of December 2017 06:31:25 AM
Old 12-11-2017
IO queue maxtime over 1 minute

We are experiencing around 1minute IO delays on Oracle DB including both read and write operations even for writing <1kB or reading single 8kB block. Below is the output of iostat -D -T 60 1000 for the problematic time periods
Code:
asmdata03       xfer:  %tm_act      bps      tps      bread      bwrtn      time
                         99.3    334.6K     1.4      331.1K       3.5K  20:17:10
                read:      rps  avgserv  minserv  maxserv   timeouts      fails
                          1.3      9.5      1.0     33.0           0          0
               write:      wps  avgserv  minserv  maxserv   timeouts      fails
                          0.2      0.9      0.7      1.3           0          0
               queue:  avgtime  mintime  maxtime  avgwqsz    avgsqsz     sqfull
                          8.9S     0.0      1.1M     0.0       11.0         0.0
asmdata08       xfer:  %tm_act      bps      tps      bread      bwrtn      time
                         99.5    518.4K     2.9      511.2K       7.2K  20:22:10
                read:      rps  avgserv  minserv  maxserv   timeouts      fails
                          1.9     13.7      0.9     49.2           0          0
               write:      wps  avgserv  minserv  maxserv   timeouts      fails
                          0.9      0.7      0.9      1.6           0          0
               queue:  avgtime  mintime  maxtime  avgwqsz    avgsqsz     sqfull
                          6.0S     0.0      1.1M     0.0       15.0         0.1
asmdata17       xfer:  %tm_act      bps      tps      bread      bwrtn      time
                         86.5      4.7M    18.7        4.7M       2.0K  22:25:10
                read:      rps  avgserv  minserv  maxserv   timeouts      fails
                         18.1     15.2      0.1     69.9           0          0
               write:      wps  avgserv  minserv  maxserv   timeouts      fails
                          0.6      1.3      0.7      8.4           0          0
               queue:  avgtime  mintime  maxtime  avgwqsz    avgsqsz     sqfull
                        696.0      0.0      1.1M     0.0       10.0         0.0
asmdata10       xfer:  %tm_act      bps      tps      bread      bwrtn      time
                         84.2     29.4M   113.1       29.4M     546.1   22:35:10
                read:      rps  avgserv  minserv  maxserv   timeouts      fails
                        113.0      1.5      0.1      7.7           0          0
               write:      wps  avgserv  minserv  maxserv   timeouts      fails
                          0.1      0.9      0.0      0.0           0          0
               queue:  avgtime  mintime  maxtime  avgwqsz    avgsqsz     sqfull
                         10.6      0.0      1.1M     0.0        1.0         0.0
asmdata15       xfer:  %tm_act      bps      tps      bread      bwrtn      time
                         92.2      6.4M    31.2        6.4M     136.5   22:40:10
                read:      rps  avgserv  minserv  maxserv   timeouts      fails
                         31.2     16.4      0.2     96.8           0          0
               write:      wps  avgserv  minserv  maxserv   timeouts      fails
                          0.0      1.5      1.5      1.5           0          0
               queue:  avgtime  mintime  maxtime  avgwqsz    avgsqsz     sqfull
                        530.0      0.0      1.1M     0.0       13.0         0.6
asmdata06       xfer:  %tm_act      bps      tps      bread      bwrtn      time
                         93.0      6.7M    26.4        6.7M       3.7K  22:45:10
                read:      rps  avgserv  minserv  maxserv   timeouts      fails
                         25.6     18.8      0.4     82.0           0          0
               write:      wps  avgserv  minserv  maxserv   timeouts      fails
                          0.8      1.0      0.6      6.6           0          0
               queue:  avgtime  mintime  maxtime  avgwqsz    avgsqsz     sqfull
                        632.2      0.0      1.1M     0.0       13.0         0.5
asmdata05       xfer:  %tm_act      bps      tps      bread      bwrtn      time
                         76.9     20.7M    79.0       20.7M     273.1   06:59:11
                read:      rps  avgserv  minserv  maxserv   timeouts      fails
                         79.0     14.9      0.5     65.9           0          0
               write:      wps  avgserv  minserv  maxserv   timeouts      fails
                          0.0      0.6      0.0      0.0           0          0
               queue:  avgtime  mintime  maxtime  avgwqsz    avgsqsz     sqfull
                        216.5      0.0      1.1M     0.0       11.0         1.5

Does anyone have an idea what could be wrong or what to check further?

thanks a lot
 

10 More Discussions You Might Find Interesting

1. Programming

linux 7.1 goes off every other minute

i have loaded linux 7.1 on my PC along with win98 the problem is that every other minute th system goes off please help me (1 Reply)
Discussion started by: vidya_harnal
1 Replies

2. Solaris

syslog messages every minute

Hi If we have for example a disk that is experiencing problems, ie read errors etc, a message will get generated via syslog every one minute....I come in the morning to hundreds upon hundreds of the same message. Is there anyway to change this to say 5 minutes or maybe 10 mins etc so that it... (1 Reply)
Discussion started by: hcclnoodles
1 Replies

3. Programming

how can i run a process for a whole minute?

here's the problem, i have two processes that i need to run and both process should be run at a total of 1 minute each. how do i do that? and one more here's what the processes do: the 1st process show the '+" sign infinitely while the 2nd process displays the "-" infinitely. how could i count the... (1 Reply)
Discussion started by: kelogs1347
1 Replies

4. Shell Programming and Scripting

scripting running every minute

Hi Experts, below similar thread i posted earlier. Although i wish to know ur suggestion newly. I want to run a script every 1 minute. I tried with Crontab. But the problem is cron send every 1 mins invertal- mail to the user mailbox. meanwhile, some expert telling me it is not wise to... (15 Replies)
Discussion started by: thepurple
15 Replies

5. Shell Programming and Scripting

How do i get only last 5 minute worth of data

I have a text file called 'tomcat_temp_out'. I want to get only last 5 minute worth of data from this file and redirect those data into another fule. Could you please help to work on this? (2 Replies)
Discussion started by: shivanete
2 Replies

6. Shell Programming and Scripting

Crontab for every minute or every hour

How to set crontab for every minute or every hour (1 Reply)
Discussion started by: kaushik02018
1 Replies

7. What is on Your Mind?

The 5 Minute Management Course (Six Lessons)

Lesson 1: A man is getting into the shower just as his wife is finishing up her shower, when the doorbell rings. The wife quickly wraps herself in a towel and runs downstairs. When she opens the door, there stands Bob, the next-door neighbour. Before she says a word, Bob says, 'I'll... (2 Replies)
Discussion started by: Neo
2 Replies

8. Shell Programming and Scripting

Process file every minute

Hey guy's, How can I schedule this script using AWK, what I require is it runs every minute as new data will be added to the file? And I need to capture these data and save it to the output file. I tried using sleep 1 to allow the file to be processed but is not working. awk ' ... (35 Replies)
Discussion started by: James_Owen
35 Replies

9. Shell Programming and Scripting

Take minute per minute from a log awk

Hi, I've been trying to develop a script that performs the parsing of a log every 1 minute and then generating some statistics. I'm fairly new to programming and this is why I come to ask if I can lend a hand. this is my log: xxxx 16/04/2012 17:00:52 - xxxx714 - E234 - Time= 119 ms.... (8 Replies)
Discussion started by: jockx
8 Replies

10. Shell Programming and Scripting

Minute(4) issue in teradata

I have values below for which diff field is giving error like "invalid time interval" in teradata Might be it is not doing calculation anymore after exceeding minute(4) value END_TS 2/2/2018 08:50:49.000000 START_TS 1/5/2018 17:30:02.000000 SLA_TIME 23:59:59.000000 select... (0 Replies)
Discussion started by: himanshupant
0 Replies
All times are GMT -4. The time now is 10:37 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy