This discussion is archived
1 2 Previous Next 22 Replies Latest reply: Mar 27, 2013 11:43 PM by 947099 Go to original post RSS
  • 15. Re: How to capture load of different OS users on a single server?
    SalmanQureshi Expert
    Currently Being Moderated
    I don't see any problem in this report.
    As you say
    Yes bottleneck here is System I/O wait.That is why i want to know how to use top to extract OS user wise resources consumption.
    My question is still same, how do you know that your IO is bottlenecked?

    You still did not tell how many CPUs do you have?
    Time     %user     %system     %iowait     %Load
    0:10:02     8.22     2.3     13.42     23.94
    0:20:01     4.48     1.42     8.64     14.54
    0:30:01     4.69     1.43     8.38     14.5
    0:40:01     4.18     1.36     4.97     10.51
    0:50:01     4.54     1.44     6.13     12.11
    1:00:01     4.55     1.47     6.29     12.31
    1:10:02     4.21     1.53     14     19.74
    1:20:01     4.85     1.7     12.69     19.24
    1:30:01     4.21     1.79     12.37     18.37
    1:40:02     4.53     1.58     11.91     18.02
    1:50:02     4.34     1.62     11     16.96
    2:00:02     4.3     1.57     11.88     17.75
    2:10:01     4.76     1.64     12.85     19.25
    2:20:01     4.65     1.53     8.19     14.37
    2:30:01     4.93     1.52     7.26     13.71
    2:40:01     3.91     1.23     1.49     6.63
    2:50:01     4.45     1.37     2.09     7.91
    3:00:01     4.77     1.44     2.31     8.52
    3:10:01     12.47     3.83     26.13     42.43
    3:20:01     17.7     3.84     25.69     47.23
    3:30:01     14.48     3.07     21.14     38.69
    3:40:01     5.31     1.45     6.67     13.43
    3:50:01     5.32     1.51     5.64     12.47
    4:00:01     4.17     1.37     2.97     8.51
    4:10:01     4.75     1.45     3.35     9.55
    4:20:01     4.61     1.36     2.21     8.18
    4:30:01     3.9     1.31     3     8.21
    4:40:01     5.24     1.41     3.44     10.09
    4:50:01     3.8     1.37     6.48     11.65
    5:00:01     4.02     1.31     3.34     8.67
    5:10:01     5.46     1.46     4.75     11.67
    5:20:01     3.63     1.29     5.66     10.58
    5:30:01     4.85     1.47     3.36     9.68
    5:40:01     4.43     1.39     2.32     8.14
    5:50:01     8.12     1.39     4.03     13.54
    6:00:02     5.15     1.45     6.08     12.68
    6:10:02     5.36     1.47     6.8     13.63
    6:20:01     3.74     1.35     6.58     11.67
    6:30:01     5.11     1.44     4.52     11.07
    6:40:01     4.01     1.37     5.93     11.31
    6:50:01     4.82     1.47     9.67     15.96
    7:00:01     4.21     1.34     4.4     9.95
    7:10:01     5.05     1.45     7.14     13.64
    7:20:01     4.18     1.38     6.08     11.64
    7:30:01     3.96     1.3     2.63     7.89
    7:40:01     4.95     1.4     8.03     14.38
    7:50:01     4.74     1.45     5.04     11.23
    8:00:01     4.05     1.35     7.06     12.46
    8:10:01     5.15     1.54     10.51     17.2
    8:20:01     5.57     1.46     8.98     16.01
    8:30:02     5.83     1.55     11.32     18.7
    8:40:01     6.22     1.55     7.45     15.22
    8:50:01     6.41     1.64     12.39     20.44
    9:00:01     5.52     1.57     11.83     18.92
    9:10:01     6.98     1.71     13.75     22.44
    9:20:01     7.13     1.59     9.15     17.87
    9:30:01     5.81     1.59     10.94     18.34
    9:40:02     7.62     1.87     13.81     23.3
    9:50:02     8.33     1.77     9.76     19.86
    10:00:01     8.33     1.81     12.53     22.67
    10:10:02     7.84     1.83     17.84     27.51
    10:20:01     9.08     1.91     18.01     29
    10:30:01     12.93     2.17     20.24     35.34
    10:40:01     16.86     2.35     20.8     40.01
    10:50:01     10.64     1.79     15.97     28.4
    11:00:02     6.96     1.58     15.43     23.97
    11:10:01     9.86     1.8     18.15     29.81
    11:20:01     8.02     1.81     17.29     27.12
    11:30:02     9.09     1.63     17.85     28.57
    11:40:01     9.87     2.01     20.16     32.04
    11:50:02     10.03     2.03     23.45     35.51
    12:00:01     13     2.18     21.6     36.78
    12:10:01     10.45     1.94     20.17     32.56
    12:20:01     10.29     1.92     16.11     28.32
    12:30:02     12.51     2.41     17.69     32.61
    12:40:01     11.74     2.35     18.44     32.53
    12:50:02     9.65     1.94     17.88     29.47
    13:00:01     9     1.86     18.01     28.87
    13:10:01     9.61     1.9     17.67     29.18
    13:20:01     7.12     2.13     15.3     24.55
    13:30:01     9.49     2.16     17.25     28.9
    13:40:01     10.3     1.83     18.11     30.24
    13:50:01     10.11     1.81     17     28.92
    14:00:02     6.83     1.62     20.55     29
    14:10:01     6.22     1.75     15.83     23.8
    14:20:01     9.37     2.18     14.19     25.74
    14:30:01     11.26     2.09     15.71     29.06
    14:40:01     11.62     1.59     20.19     33.4
    14:50:01     6.75     1.75     12.25     20.75
    15:00:02     8.5     1.97     13.47     23.94
    15:10:02     8.5     1.9     15.3     25.7
    15:20:01     9.44     2.18     18.52     30.14
    15:30:01     5.37     1.79     12.74     19.9
    15:40:02     8.02     1.83     13.48     23.33
    15:50:02     6.29     1.63     10.59     18.51
    16:00:01     7.81     1.95     13.25     23.01
    16:10:01     14.11     2.54     15.21     31.86
    16:20:02     6.76     1.73     13.61     22.1
    16:30:01     6.94     1.79     14.45     23.18
    16:40:02     8.01     2.14     18.22     28.37
    16:50:01     8.4     2.11     13.32     23.83
    17:00:01     6.85     2.07     16.08     25
    17:10:02     9.77     2.35     21.85     33.97
    17:20:01     14.15     2.66     24.78     41.59
    17:30:01     8.13     1.89     17.02     27.04
    17:40:01     11.17     2.48     17.03     30.68
    17:50:01     7.2     1.78     10.56     19.54
    18:00:01     9.22     2.08     15.03     26.33
    18:10:01     13.54     2.17     17.77     33.48
    18:20:02     8.02     2.07     17.98     28.07
    18:30:01     9.77     1.93     11.74     23.44
    18:40:01     7.98     1.96     13.73     23.67
    18:50:01     8.47     2     15.84     26.31
    19:00:01     5.73     1.78     12.77     20.28
    19:10:02     7.43     1.87     14.72     24.02
    19:20:02     6.3     1.54     7.71     15.55
    19:30:01     4.44     1.58     7.87     13.89
    19:40:02     6.49     1.7     9.79     17.98
    19:50:01     6.57     1.76     9.65     17.98
    20:00:01     5.81     1.64     9.02     16.47
    20:10:01     7.17     2.3     11.16     20.63
    20:20:01     6.3     1.89     11.12     19.31
    20:30:01     5.93     2.47     11     19.4
    20:40:01     6.77     2.46     10.58     19.81
    20:50:02     6.42     1.76     9.22     17.4
    21:00:01     4.85     1.59     9.27     15.71
    21:10:02     5.96     1.65     9.68     17.29
    21:20:01     4.36     1.89     10.29     16.54
    21:30:01     4.66     1.85     11.86     18.37
    21:40:01     5.41     1.61     8.49     15.51
    21:50:01     4.6     1.5     7.48     13.58
    22:00:01     4.98     1.48     6.92     13.38
    22:10:02     2.43     4.33     22.28     29.04
    22:20:02     1.92     4.44     21.83     28.19
    22:30:02     3.56     3.36     19.36     26.28
    22:40:02     13.47     1.51     9.39     24.37
    22:50:01     10.61     1.42     5.91     17.94
    23:00:01     4.44     1.45     3.94     9.83
    23:10:01     5.27     1.56     10.07     16.9
    23:20:01     7.93     1.83     9.32     19.08
    23:30:01     5.36     1.54     8.35     15.25
    Average:     7.09     1.82     11.97     20.88
  • 16. Re: How to capture load of different OS users on a single server?
    947099 Newbie
    Currently Being Moderated
    As per my understanding, iowait shows system wait time for the processes to run. Please correct if i am worng somewhere. And sar output shows 25% iowait most of the time in last month.

    I don't have hardware details,but through command it is showing:

    [oracle ~]$ cat /proc/cpuinfo|grep "physical id"|sort|uniq|wc -l
    12
  • 17. Re: How to capture load of different OS users on a single server?
    SalmanQureshi Expert
    Currently Being Moderated
    Hi,
    This IO wait is related to CPU. It means that CPU has been waiting IO to complete before any further processing. During a process execution, CPU cycles and IO is involved. So when a processing is working on CPU and during this execution, it needs to read the data, CPU will be in IO wait untill IO is done and CPU again starts processing. If your CPU is very fast (current high end systems have very fast CPUs, and all of us know that), so it does not meant your IO us slow, it normally means that your CPU is faster than IO.
    You need to check the health of your disk storage to know whether it is IO bottleneck or not. AWR can also show you time it takes for the IO.
    See bellow do check whether your IO speed is good or not.
    http://www.dba-oracle.com/oracle10g_tuning/t_disk_i_o_reports.htm

    Salman
  • 18. Re: How to capture load of different OS users on a single server?
    947099 Newbie
    Currently Being Moderated
    This is the only root cause that we don't have awr due to licencing issue.SO please if there is any other way ,share it.
  • 19. Re: How to capture load of different OS users on a single server?
    SalmanQureshi Expert
    Currently Being Moderated
    Hi,
    1. Ask your system/storage admin to provide you with storage health report.
    2. Install OSWatcher provided by Oracle to capture IO stats and then have a look at IO stats

    Salman
  • 20. Re: How to capture load of different OS users on a single server?
    947099 Newbie
    Currently Being Moderated
    Ok thanks Salman
    And to extract OS user wise resources consumption on Linux, through TOP,Do i need to create another post?
  • 21. Re: How to capture load of different OS users on a single server?
    SalmanQureshi Expert
    Currently Being Moderated
    Hi,
    And to extract OS user wise resources consumption on Linux, through TOP,Do i need to create another post?
    TOP will not show this. how you can get it, yes you need a new post, but on some Linux forums :)

    Salman
  • 22. Re: How to capture load of different OS users on a single server?
    947099 Newbie
    Currently Being Moderated
    Thanks for sharing information.
1 2 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points