Differences

This shows you the differences between two versions of the page.

--- monitors:db_cpu.ksh [2013/04/23 02:46] – external edit 127.0.0.1
+++ monitors:db_cpu.ksh [2014/02/27 04:37] (current) – [Changelog] vernon
@@ Line 2: / Line 2: @@
 ^ Author | [[ everett.vernon@gmail.com | Vernon Everett ]] |
-^ Compatibility | Tested on Xymon 4.3.10, Solaris 9 & 10, Xymon 4.2.3 (stack graph doesn't work)|
+^ Compatibility | Tested on Xymon 4.3.10, Solaris 9, 10 & 11. On Xymon 4.2.3 the stack graph doesn't work|
 ^ Requirements | Perl, Oracle Database, Solaris |
 ^ Download | None |
-^ Last Update | 2013-04-23 |
+^ Last Update | <del>2013-04-23</del> 2014-02-27 |
 ===== Description =====
@@ Line 882: / Line 882: @@
 #!/usr/bin/ksh
 COLOUR=green
-TOP=/usr/local/bin/top
+type top >> /dev/null
+ERR=$?
+if [ $ERR -eq 0 ]
+then
+   TOP=$(type top| cut -d\( -f2 | cut -d\) -f1)
+else
+   [ -x /usr/local/bin/top ] && TOP=/usr/local/bin/top
+fi
 CPU_tmp=$XYMONTMP/db_cpu_list
 TEMPFILE=$XYMONTMP/db_cpu
@@ Line 911: / Line 919: @@
 # Get the idle figure. Run top -d4, and take the last value to prevent
 # a possible skewed result from the other xymon tasks that have just kicked off.
-IDLE=$($TOP -n -d4 | grep "^CPU states" | cut -d"%" -f1 | sed "s/CPU states: //g" | tail -1)
+if [ -x $TOP ]
-IDLE="${IDLE}000"
+then
+   # We have a working version of top
+   IDLE=$($TOP -n -d4 | grep "^CPU states" | cut -d"%" -f1 | sed "s/CPU states: //g" | tail -1)
+   IDLE="${IDLE}000"
+else
+  # No working top. We will have to resort to iostat.
+  # Pity. Top is at least accurate to 1 decimal place.
+  IDLE=$(iostat -p 2 5 | awk '{ print $NF }' | tail -1)
+  IDLE="${IDLE}.0000"
+fi
 # Set DBID to your oracle identifier. You can use the userID or the username
 # or any value that will identify your oracle processes in a ps | grep
-DBID="oracle"
+DBID="^ 0000100"
 # Get a list of all Databases running on the system
-DBLIST=$(ps -efa | grep $DBID | grep pmon | cut -d"_" -f3 | sort | uniq)
+DBLIST=$(ps -efa | grep "$DBID" | grep pmon | cut -d"_" -f3 | sort | uniq)
 if [ -z "$DBLIST" ]
 then
     echo "No databases found!" >> $TEMPFILE
     [ "$NO_DB_ALERT" = "true" ] && COLOUR=$NO_DB_COLOUR
-    DB_USED="0.0000" # A reasonable assumption if there are no databases
+    DB_USED="0.0000" # A reasonable assumtion if there are no databases
 else
    # Get a list of all the processes and their CPU utilisation.
@@ Line 956: / Line 973: @@
       fi
       DB_USED=$(echo "$DB_USED+$USAGE" | bc)
+      USAGE=$(echo $USAGE | sed 's/ \./0\./g')
       echo "$DB $USAGE" >> $TEMPFILE.2
    done
 fi
 if [ $SHOW_IDLE -eq 1 ]
 then
@@ Line 968: / Line 985: @@
    # We only change the IDLE and OTHER values though, not the database values.
    # Those are real data.
-   if [ $OTHER -le 0 ]
+   if [ $OTHER -lt 0 ]
    then
       IDLE=$(echo ${IDLE}+${OTHER} | bc)
@@ Line 977: / Line 994: @@
    DB="Other          "
    USAGE=$OTHER
+   USAGE=$(echo "$USAGE" |  sed "s/ \./0\./g")
    echo "$DB $USAGE" >> $TEMPFILE.2
    DB="Idle"
    USAGE=$IDLE
+   USAGE=$(echo "$USAGE" |  sed "s/ \./0\./g")
    echo "$DB $USAGE" >> $TEMPFILE.2
 fi
@@ Line 996: / Line 1015: @@
 rm $CPU_tmp
 rm $TEMPFILE $TEMPFILE.2
 </code>
@@ Line 1055: / Line 1073: @@
   * **2013-04-23**
     * Updated to handle the case of no databases running. Previously, it just didn't bother doing anything, but now it will report there are no databases, and can trigger a colour change if there are no databases found.
+  * **2014-02-27**
+    * Updated to run with Solaris 11.
+    * If top isn't available, (Solaris 10 and earlier) will use iostat to get idle stats.
+    * Fixed a few display bugs.