10 Replies Latest reply: Dec 10, 2012 11:28 AM by jgarry RSS

    How to monitor performance from OS

    718371
      Hi,

      DB : 10g R2
      OS : AIX 5.3

      I have more than 10 instances with 10 seprate databases on a Sigle Sever. Due to any database performance issue whole databases suffer due to single culprit DB . Is there any quick way from OS we see that which database is causing performance issue.

      Quick help will be apprecaited.

      Regards,
        • 1. Re: How to monitor performance from OS
          Osama_Mustafa
          10 Instance in single Server WOW and Why ??

          Oracle provide you with Grid Control to monitor and mange your databases
          • 2. Re: How to monitor performance from OS
            Satishbabu Gunukula
            There are many tools available..did you tried "topas" just like "top" in REHL

            Also you can check below link
            http://ramses.smeyers.be/varia/aix/performance/

            Defineatly grild control will help.

            Regards,
            http://www.oracleracexpert.com
            Oracle Recovery Manager(RMAN) New features in 11g
            http://www.oracleracexpert.com/2011/12/oracle-recovery-managerrman-new.html
            RMAN Incrementally updated backups
            http://www.oracleracexpert.com/2011/12/rman-incrementally-updated-backups.html
            • 3. Re: How to monitor performance from OS
              sb92075
              apps_dba wrote:
              Hi,

              DB : 10g R2
              OS : AIX 5.3

              I have more than 10 instances with 10 seprate databases on a Sigle Sever. Due to any database performance issue whole databases suffer due to single culprit DB . Is there any quick way from OS we see that which database is causing performance issue.
              No, there is no quick & easy to know which s the culprit DB.
              • 4. Re: How to monitor performance from OS
                user3266490
                Hi,

                Thanks for your reply.

                where to start first? then next..... until conclusion?
                I read awr report.I didn't understand the values.

                Load Profile
                 <                      Per Second       Per Transaction  Per Exec Per Call  
                 *DB Time(s):           143.5               1.7                 0.19       0.13* 
                 DB CPU(s):              5.3                 0.1                 0.01       0.00 
                 Redo size:           29,998,607.4     355,473.0     
                 Logical reads:        334,161.0         3,959.7     
                Block changes:       62,463.2          740.2     
                Physical reads:          5,678.0           67.3     
                Physical writes:          1,805.5          21.4     
                User calls:                  1,086.4         12.9     
                Parses:                         343.0          4.1     
                Hard parses:                  1.6              0.0     
                W/A MB processed:        17.0             0.2     
                Logons:                        8.4               0.1     
                Executes:                    742.0             8.8     
                Rollbacks:                     0.0                    0.0     
                Transactions:                84.4     
                For Ex:

                What is maximun threshold value for DB time Per Second and per transacation?
                I unable to understand these numbers?
                Anyone help me.

                Thanks & Regards,
                VN
                • 5. Re: How to monitor performance from OS
                  247514
                  For AIX you can first use topas to find out which process taking most CPU if system is CPU bond.
                  Also check the Memory and Paging section see if host is swapping.

                  Also check networking etc.

                  nmon is also very useful tool on AIX
                  • 6. Re: How to monitor performance from OS
                    Girish Sharma
                    WOW.... Yingkaun, you are back to forum. I am really glad to see your post after a vary long break.

                    Kindly keep posting continue...

                    Regards
                    Girish Sharma
                    • 7. Re: How to monitor performance from OS
                      Aman....
                      Wow, welcome back Yingkuan on the forums :) .

                      Regards
                      Aman....
                      • 8. Re: How to monitor performance from OS
                        Niket Kumar
                        you can check which instance taking more cpu and work on that instance.

                        http://applicationsdba.blogspot.in/2010/03/monitoring-cpu-usage-of-multiple-oracle.html
                        • 9. Re: How to monitor performance from OS
                          718371
                          Hi Niket Kumar,

                          Thanks for update. You 100% understand my requirement. I have tried your script on AIX but not succeeded. Kindly can you or any one change this scripts for AIX 5.3

                          {#!/bin/ksh
                          echo "CPU usage at 'date '+DATE: %m/%d/%y TIME:%H:%M:%S'' on host 'hostname'"
                          echo "--------------------------------------------------------------"

                          for dbname in 'ps -ef|grep pmon|awk '{print $8}'|grep -v grep|grep pmon|sed s/ora_pmon_//'
                          do
                          echo "$dbname usage= " 'ps -eo pcpu,args|grep -i $dbname|awk '{ sum+=$1} END {print sum}''
                          done

                          }

                          Regards,
                          • 10. Re: How to monitor performance from OS
                            jgarry
                            You need to look at your AIX man page for ps to figure out the translation. You could just print the tcpu usage and process name, and grep for pmon to find out just those.