1 2 Previous Next 22 Replies Latest reply: Mar 28, 2013 1:43 AM by 947099 RSS

    How to capture load of different OS users on a single server?

    947099
      I am using Database version -11.1.0.7 64-bit , I have three different instances on a single server and therefore have 3 different OS users.
      When I run Top command , it shows overall load.
      Is there any way to capture load statistics user wise?
        • 1. Re: How to capture load of different OS users on a single server?
          Salman Qureshi
          Hi,
          I am using Database version -11.1.0.7 64-bit , I have three different instances on a single server and therefore have 3 different OS users.
          How 3 instances means 3 OS users? Did you run 3 instances whiled logged on 3 different users? Why can't you use a single user if all are running from same Oracle home to keep the things simple
          When I run Top command , it shows overall load.
          What do you mean by overload? Please paste here output of you "top" command.

          I belive "top" command should show you top users and to Os processes, hence top consumers.
          Salman
          • 2. Re: How to capture load of different OS users on a single server?
            947099
            I mean to say 3 instances means three different testing database on the same server.UAT ,test and dev
            And i want to know which database is creating how much load during peak hours.


            top output:

            top - 14:46:49 up 57 days, 23:07, 6 users, load average: 7.08, 7.97, 6.92
            Tasks: 855 total, 5 running, 850 sleeping, 0 stopped, 0 zombie
            Cpu(s): 4.0%us, 2.0%sy, 0.0%ni, 77.5%id, 16.4%wa, 0.0%hi, 0.0%si, 0.0%st
            Mem: 24265728k total, 24235848k used, 29880k free, 88864k buffers
            Swap: 25165812k total, 959980k used, 24205832k free, 16029216k cached

            PID USER PR NI VIRT RES SHR S %CPU %MEM TIME+ COMMAND
            2013 oracle 15 0 6403m 1.6g 1.5g S 10.2 6.8 353:17.70 oracle
            31010 oracle 17 0 6345m 103m 95m D 10.2 0.4 0:00.23 oracle
            26359 oracle 16 0 6361m 594m 578m R 4.9 2.5 0:03.33 oracle
            19725 oradev 16 0 1247m 368m 358m R 4.0 1.6 0:06.70 oracle
            8432 oracle 18 0 6449m 861m 821m R 3.6 3.6 1:12.01 oracle
            9496 oradev 15 0 1217m 196m 192m S 3.1 0.8 3:49.92 oracle
            12194 oracle 18 0 6371m 476m 449m R 2.7 2.0 0:02.73 oracle
            30309 oracle 15 0 13272 1712 820 R 2.2 0.0 0:00.32 top
            30319 oradev 15 0 1225m 97m 88m S 1.8 0.4 0:00.46 oracle
            25704 oracle 16 0 6361m 310m 294m S 1.3 1.3 0:02.43 oracle
            9902 oradev 15 0 1223m 382m 376m S 0.9 1.6 0:34.60 oracle
            12590 orauat 15 0 3292m 180m 168m S 0.9 0.8 0:01.88 oracle
            17069 oracle 16 0 6353m 2.0g 2.0g D 0.9 8.7 0:28.17 oracle
            28103 oracle 15 0 6341m 78m 72m S 0.9 0.3 0:00.11 oracle
            • 3. Re: How to capture load of different OS users on a single server?
              EdStevens
              944096 wrote:
              I mean to say 3 instances means three different testing database on the same server.UAT ,test and dev
              OK, but what is the relationship between those three instances/databases and "and therefore have 3 different OS users"
              <snip>
              • 4. Re: How to capture load of different OS users on a single server?
                sb92075
                944096 wrote:
                I mean to say 3 instances means three different testing database on the same server.UAT ,test and dev
                And i want to know which database is creating how much load during peak hours.


                top output:

                top - 14:46:49 up 57 days, 23:07, 6 users, load average: 7.08, 7.97, 6.92
                Tasks: 855 total, 5 running, 850 sleeping, 0 stopped, 0 zombie
                Cpu(s): 4.0%us, 2.0%sy, 0.0%ni, 77.5%id, 16.4%wa, 0.0%hi, 0.0%si, 0.0%st
                please NOTE that line above shows system is 77.5% IDLE
                so what ever maybe the system bottleneck; it is NOT the CPU!

                It appears that this system has disk or I/O bottleneck.
                • 5. Re: How to capture load of different OS users on a single server?
                  Salman Qureshi
                  Please enclose your code/output in
                   tag for readability.
                  
                  What is yoru OS, I think it is Linux? How many CPUs you hae on your system?
                  
                  
                  top - 14:46:49 up 57 days, 23:07, 6 users, load average: 7.08, 7.97, 6.92
                  Here I see load average of 7 which seems a bit high (but depends on number of CPUs). If you have less than 8 CPUs, this load average is high and your CPUs are bottlenecked. You ave 24G RAM? What is SGHA settings for all of your 3 instances? From the output of TOP command, I see that top consumer is user "oracle", which is probably production instance runner, but, for detailed information at OS level, probably you need to put question in some Linux forum about how to extract OS user wise resources consumption on Linux Salman                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                   
                  • 6. Re: How to capture load of different OS users on a single server?
                    sb92075
                    Salman Qureshi wrote:
                    Please enclose your code/output in
                     tag for readability.
                    
                    What is yoru OS, I think it is Linux? How many CPUs you hae on your system?
                    
                    
                    top - 14:46:49 up 57 days, 23:07, 6 users, load average: 7.08, 7.97, 6.92
                    Here I see load average of 7 which seems a bit high (but depends on number of CPUs). If you have less than 8 CPUs, this load average is high and your CPUs are bottlenecked.
                    what about the 77.5% IDLE measurement?
                    How can system be CPU bottlenecked with 77.5% idle time?
                    • 7. Re: How to capture load of different OS users on a single server?
                      Salman Qureshi
                      Hi,
                      what about the 77.5% IDLE measurement?
                      How can system be CPU bottlenecked with 77.5% idle time?
                      Here it means a lot of runnable processes in the queue waiting for the CPUs. Runnable processes run in very short time, hence CPU % busy is quite smalle.

                      CPU % busy and Idle does not show you how much CPU requirement is on the system, but load average does. If you have 4 CPUs, a load average of 7 means that 7 processes are in the queue to acquire the CPU and waiting. If you have 8 CPUs, this does not mean a bottleneck.
                      CPU busy% and idle% is really a different thing and calculated differently (theoritically a CPU is either 100% busy, "1" (in binary) or 0% busy "0" (in binary).

                      So, for CPU bottleneck, we need to look at the load average.

                      http://www.linuxjournal.com/article/9001

                      For more, just google about comparision between load average and percentage usage, to find out more.

                      Salman
                      • 8. Re: How to capture load of different OS users on a single server?
                        947099
                        I am using Linux x86-64 ,rhel -5 ,24-Gb RAM ,3gb SGA
                        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.
                        • 9. Re: How to capture load of different OS users on a single server?
                          Salman Qureshi
                          Hi,
                          I am using Linux x86-64 ,rhel -5 ,24-Gb RAM ,3gb SGA
                          3G for all 3 instances or each is having 3G?
                          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.
                          How do you know IO is bottleneck? Please show any report which shows that IO is bottleneck.

                          Salman
                          • 10. Re: How to capture load of different OS users on a single server?
                            947099
                            Hi Salman,

                            Production has 3g of sga and other two have 2G of SGA being test instance.

                            Sar output :

                            Time     %user     %system     %iowait
                            00:10:02     8.22     2.3     13.42
                            00:20:01     4.48     1.42     8.64
                            00:30:01     4.69     1.43     8.38
                            00:40:01     4.18     1.36     4.97
                            00:50:01     4.54     1.44     6.13
                            01:00:01     4.55     1.47     6.29
                            01:10:02     4.21     1.53     14
                            01:20:01     4.85     1.7     12.69
                            01:30:01     4.21     1.79     12.37
                            01:40:02     4.53     1.58     11.91
                            01:50:02     4.34     1.62     11
                            02:00:02     4.3     1.57     11.88
                            02:10:01     4.76     1.64     12.85
                            02:20:01     4.65     1.53     8.19
                            02:30:01     4.93     1.52     7.26
                            02:40:01     3.91     1.23     1.49
                            02:50:01     4.45     1.37     2.09
                            03:00:01     4.77     1.44     2.31
                            03:10:01     12.47     3.83     26.13
                            03:20:01     17.7     3.84     25.69
                            03:30:01     14.48     3.07     21.14
                            03:40:01     5.31     1.45     6.67
                            03:50:01     5.32     1.51     5.64
                            04:00:01     4.17     1.37     2.97
                            04:10:01     4.75     1.45     3.35
                            04:20:01     4.61     1.36     2.21
                            04:30:01     3.9     1.31     3
                            04:40:01     5.24     1.41     3.44
                            04:50:01     3.8     1.37     6.48
                            05:00:01     4.02     1.31     3.34
                            05:10:01     5.46     1.46     4.75
                            05:20:01     3.63     1.29     5.66
                            05:30:01     4.85     1.47     3.36
                            05:40:01     4.43     1.39     2.32
                            05:50:01     8.12     1.39     4.03
                            06:00:02     5.15     1.45     6.08
                            06:10:02     5.36     1.47     6.8
                            06:20:01     3.74     1.35     6.58
                            06:30:01     5.11     1.44     4.52
                            06:40:01     4.01     1.37     5.93
                            06:50:01     4.82     1.47     9.67
                            07:00:01     4.21     1.34     4.4
                            07:10:01     5.05     1.45     7.14
                            07:20:01     4.18     1.38     6.08
                            07:30:01     3.96     1.3     2.63
                            07:40:01     4.95     1.4     8.03
                            07:50:01     4.74     1.45     5.04
                            08:00:01     4.05     1.35     7.06
                            08:10:01     5.15     1.54     10.51
                            08:20:01     5.57     1.46     8.98
                            08:30:02     5.83     1.55     11.32
                            08:40:01     6.22     1.55     7.45
                            08:50:01     6.41     1.64     12.39
                            09:00:01     5.52     1.57     11.83
                            09:10:01     6.98     1.71     13.75
                            09:20:01     7.13     1.59     9.15
                            09:30:01     5.81     1.59     10.94
                            09:40:02     7.62     1.87     13.81
                            09:50:02     8.33     1.77     9.76
                            10:00:01     8.33     1.81     12.53
                            10:10:02     7.84     1.83     17.84
                            10:20:01     9.08     1.91     18.01
                            10:30:01     12.93     2.17     20.24
                            10:40:01     16.86     2.35     20.8
                            10:50:01     10.64     1.79     15.97
                            11:00:02     6.96     1.58     15.43
                            11:10:01     9.86     1.8     18.15
                            11:20:01     8.02     1.81     17.29
                            11:30:02     9.09     1.63     17.85
                            11:40:01     9.87     2.01     20.16
                            11:50:02     10.03     2.03     23.45
                            12:00:01     13     2.18     21.6
                            12:10:01     10.45     1.94     20.17
                            12:20:01     10.29     1.92     16.11
                            12:30:02     12.51     2.41     17.69
                            12:40:01     11.74     2.35     18.44
                            12:50:02     9.65     1.94     17.88
                            13:00:01     9     1.86     18.01
                            13:10:01     9.61     1.9     17.67
                            13:20:01     7.12     2.13     15.3
                            13:30:01     9.49     2.16     17.25
                            13:40:01     10.3     1.83     18.11
                            13:50:01     10.11     1.81     17
                            14:00:02     6.83     1.62     20.55
                            14:10:01     6.22     1.75     15.83
                            14:20:01     9.37     2.18     14.19
                            14:30:01     11.26     2.09     15.71
                            14:40:01     11.62     1.59     20.19
                            14:50:01     6.75     1.75     12.25
                            15:00:02     8.5     1.97     13.47
                            15:10:02     8.5     1.9     15.3
                            15:20:01     9.44     2.18     18.52
                            15:30:01     5.37     1.79     12.74
                            15:40:02     8.02     1.83     13.48
                            15:50:02     6.29     1.63     10.59
                            16:00:01     7.81     1.95     13.25
                            16:10:01     14.11     2.54     15.21
                            16:20:02     6.76     1.73     13.61
                            16:30:01     6.94     1.79     14.45
                            16:40:02     8.01     2.14     18.22
                            16:50:01     8.4     2.11     13.32
                            17:00:01     6.85     2.07     16.08
                            17:10:02     9.77     2.35     21.85
                            17:20:01     14.15     2.66     24.78
                            17:30:01     8.13     1.89     17.02
                            17:40:01     11.17     2.48     17.03
                            17:50:01     7.2     1.78     10.56
                            18:00:01     9.22     2.08     15.03
                            18:10:01     13.54     2.17     17.77
                            18:20:02     8.02     2.07     17.98
                            18:30:01     9.77     1.93     11.74
                            18:40:01     7.98     1.96     13.73
                            18:50:01     8.47     2     15.84
                            19:00:01     5.73     1.78     12.77
                            19:10:02     7.43     1.87     14.72
                            19:20:02     6.3     1.54     7.71
                            19:30:01     4.44     1.58     7.87
                            19:40:02     6.49     1.7     9.79
                            19:50:01     6.57     1.76     9.65
                            20:00:01     5.81     1.64     9.02
                            20:10:01     7.17     2.3     11.16
                            20:20:01     6.3     1.89     11.12
                            20:30:01     5.93     2.47     11
                            20:40:01     6.77     2.46     10.58
                            20:50:02     6.42     1.76     9.22
                            21:00:01     4.85     1.59     9.27
                            21:10:02     5.96     1.65     9.68
                            21:20:01     4.36     1.89     10.29
                            21:30:01     4.66     1.85     11.86
                            21:40:01     5.41     1.61     8.49
                            21:50:01     4.6     1.5     7.48
                            22:00:01     4.98     1.48     6.92
                            22:10:02     2.43     4.33     22.28
                            22:20:02     1.92     4.44     21.83
                            22:30:02     3.56     3.36     19.36
                            22:40:02     13.47     1.51     9.39
                            22:50:01     10.61     1.42     5.91
                            23:00:01     4.44     1.45     3.94
                            23:10:01     5.27     1.56     10.07
                            23:20:01     7.93     1.83     9.32
                            23:30:01     5.36     1.54     8.35
                            Average:     7.09     1.82     11.97
                            • 11. Re: How to capture load of different OS users on a single server?
                              Salman Qureshi
                              Enclose your output in
                               tag to make it readable
                              
                              Salman                                                                                                                                                                                                    
                              • 12. Re: How to capture load of different OS users on a single server?
                                947099
                                Salman Qureshi wrote:
                                Enclose your output in
                                 tag to make it readable
                                
                                Salman
                                Time     %usr %systm %iowait
                                00:10:02     8.22     2.3     13.42
                                00:20:01     4.48     1.42     8.64
                                00:30:01     4.69     1.43     8.38
                                00:40:01     4.18     1.36     4.97
                                00:50:01     4.54     1.44     6.13
                                01:00:01     4.55     1.47     6.29
                                01:10:02     4.21     1.53     14
                                01:20:01     4.85     1.7     12.69
                                01:30:01     4.21     1.79     12.37
                                01:40:02     4.53     1.58     11.91
                                01:50:02     4.34     1.62     11
                                02:00:02     4.3     1.57     11.88
                                02:10:01     4.76     1.64     12.85
                                02:20:01     4.65     1.53     8.19
                                02:30:01     4.93     1.52     7.26
                                02:40:01     3.91     1.23     1.49
                                02:50:01     4.45     1.37     2.09
                                03:00:01     4.77     1.44     2.31
                                03:10:01     12.47 3.83     26.13
                                03:20:01     17.7     3.84     25.69
                                03:30:01     14.48 3.07     21.14
                                03:40:01     5.31     1.45     6.67
                                03:50:01     5.32     1.51     5.64
                                04:00:01     4.17     1.37     2.97
                                04:10:01     4.75     1.45     3.35
                                04:20:01     4.61     1.36     2.21
                                04:30:01     3.9     1.31     3
                                04:40:01     5.24     1.41     3.44
                                04:50:01     3.8     1.37     6.48
                                05:00:01     4.02     1.31     3.34
                                05:10:01     5.46     1.46     4.75
                                05:20:01     3.63     1.29     5.66
                                05:30:01     4.85     1.47     3.36
                                05:40:01     4.43     1.39     2.32
                                05:50:01     8.12     1.39     4.03
                                06:00:02     5.15     1.45     6.08
                                06:10:02     5.36     1.47     6.8
                                06:20:01     3.74     1.35     6.58
                                06:30:01     5.11     1.44     4.52
                                06:40:01     4.01     1.37     5.93
                                06:50:01     4.82     1.47     9.67
                                07:00:01     4.21     1.34     4.4
                                07:10:01     5.05     1.45     7.14
                                07:20:01     4.18     1.38     6.08
                                07:30:01     3.96     1.3     2.63
                                07:40:01     4.95     1.4     8.03
                                07:50:01     4.74     1.45     5.04
                                08:00:01     4.05     1.35     7.06
                                08:10:01     5.15     1.54     10.51
                                08:20:01     5.57     1.46     8.98
                                08:30:02     5.83     1.55     11.32
                                08:40:01     6.22     1.55     7.45
                                08:50:01     6.41     1.64     12.39
                                09:00:01     5.52     1.57     11.83
                                09:10:01     6.98     1.71     13.75
                                09:20:01     7.13     1.59     9.15
                                09:30:01     5.81     1.59     10.94
                                09:40:02     7.62     1.87     13.81
                                09:50:02     8.33     1.77     9.76
                                10:00:01     8.33     1.81     12.53
                                10:10:02     7.84     1.83     17.84
                                10:20:01     9.08     1.91     18.01
                                10:30:01     12.93 2.17     20.24
                                10:40:01     16.86 2.35     20.8
                                10:50:01     10.64 1.79     15.97
                                11:00:02     6.96     1.58     15.43
                                11:10:01     9.86     1.8     18.15
                                11:20:01     8.02     1.81     17.29
                                11:30:02     9.09     1.63     17.85
                                11:40:01     9.87     2.01     20.16
                                11:50:02     10.03 2.03     23.45
                                12:00:01     13     2.18     21.6
                                12:10:01     10.45 1.94     20.17
                                12:20:01     10.29 1.92     16.11
                                12:30:02     12.51 2.41     17.69
                                12:40:01     11.74 2.35     18.44
                                12:50:02     9.65     1.94     17.88
                                13:00:01     9     1.86     18.01
                                13:10:01     9.61     1.9     17.67
                                13:20:01     7.12     2.13     15.3
                                13:30:01     9.49     2.16     17.25
                                13:40:01     10.3     1.83     18.11
                                13:50:01     10.11 1.81     17
                                14:00:02     6.83     1.62     20.55
                                14:10:01     6.22     1.75     15.83
                                14:20:01     9.37     2.18     14.19
                                14:30:01     11.26 2.09     15.71
                                14:40:01     11.62 1.59     20.19
                                14:50:01     6.75     1.75     12.25
                                15:00:02     8.5     1.97     13.47
                                15:10:02     8.5     1.9     15.3
                                15:20:01     9.44     2.18     18.52
                                15:30:01     5.37     1.79     12.74
                                15:40:02     8.02     1.83     13.48
                                15:50:02     6.29     1.63     10.59
                                16:00:01     7.81     1.95     13.25
                                16:10:01     14.11 2.54     15.21
                                16:20:02     6.76     1.73     13.61
                                16:30:01     6.94     1.79     14.45
                                16:40:02     8.01     2.14     18.22
                                16:50:01     8.4     2.11     13.32
                                17:00:01     6.85     2.07     16.08
                                17:10:02     9.77     2.35     21.85
                                17:20:01     14.15 2.66     24.78
                                17:30:01     8.13     1.89     17.02
                                17:40:01     11.17 2.48     17.03
                                17:50:01     7.2     1.78     10.56
                                18:00:01     9.22     2.08     15.03
                                18:10:01     13.54 2.17     17.77
                                18:20:02     8.02     2.07     17.98
                                18:30:01     9.77     1.93     11.74
                                18:40:01     7.98     1.96     13.73
                                18:50:01     8.47     2     15.84
                                19:00:01     5.73     1.78     12.77
                                19:10:02     7.43     1.87     14.72
                                19:20:02     6.3     1.54     7.71
                                19:30:01     4.44     1.58     7.87
                                19:40:02     6.49     1.7     9.79
                                19:50:01     6.57     1.76     9.65
                                20:00:01     5.81     1.64     9.02
                                20:10:01     7.17     2.3     11.16
                                20:20:01     6.3     1.89     11.12
                                20:30:01     5.93     2.47     11
                                20:40:01     6.77     2.46     10.58
                                20:50:02     6.42     1.76     9.22
                                21:00:01     4.85     1.59     9.27
                                21:10:02     5.96     1.65     9.68
                                21:20:01     4.36     1.89     10.29
                                21:30:01     4.66     1.85     11.86
                                21:40:01     5.41     1.61     8.49
                                21:50:01     4.6     1.5     7.48
                                22:00:01     4.98     1.48     6.92
                                22:10:02     2.43     4.33     22.28
                                22:20:02     1.92     4.44     21.83
                                22:30:02     3.56     3.36     19.36
                                22:40:02     13.47 1.51     9.39
                                22:50:01     10.61 1.42     5.91
                                23:00:01     4.44     1.45     3.94
                                23:10:01     5.27     1.56     10.07
                                23:20:01     7.93     1.83     9.32
                                23:30:01     5.36     1.54     8.35
                                Average:     7.09     1.82     11.97

                                Regards,
                                Radhika
                                • 13. Re: How to capture load of different OS users on a single server?
                                  Salman Qureshi
                                  Enclose your output in
                                   tag to make it readable
                                  
                                  <write "CODE" word within curly braces>
                                  
                                  Then here write our code
                                  
                                  <write "CODE" word within curly braces>
                                  
                                  
                                  Salman
                                  
                                  Edited by: Salman Qureshi on Mar 22, 2013 2:53 PM
                                  
                                  Edited by: Salman Qureshi on Mar 22, 2013 2:53 PM                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        
                                  • 14. Re: How to capture load of different OS users on a single server?
                                    947099
                                    Hi Salman ,

                                    I am not getting how to send the output in readable format.
                                    Please give me some contact ID so that i can attach u excel file showin graph also.
                                    My contact: radhikamittal20@gmail.com
                                    1 2 Previous Next