This discussion is archived
10 Replies Latest reply: Dec 10, 2012 11:28 AM by jgarry RSS

How to monitor performance from OS

718371 Newbie
Currently Being Moderated
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 Oracle ACE
    Currently Being Moderated
    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 Oracle ACE
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Expert
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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.... Oracle ACE
    Currently Being Moderated
    Wow, welcome back Yingkuan on the forums :) .

    Regards
    Aman....
  • 8. Re: How to monitor performance from OS
    Niket Kumar Pro
    Currently Being Moderated
    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 Newbie
    Currently Being Moderated
    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 Guru
    Currently Being Moderated
    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.

Legend

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