/ - Diff - Munin contributed plugins - Koumbit's Redmine

Révision fa208cb6

ID	fa208cb6f212370e7d9b3e5792b1f23a9e39f7cc
Parent	b02ca514
Enfant	edb7a1f9

Ajouté par K.Cima il y a plus de 8 ans

Improve oracle_sysstat

- Change to multi-graph plugin
- Add dirtyconfig
- Add config for multi-instance databases

     =head1 NAME
       oracle_sysstat_* - Munin plugin to monitor Oracle Statistics
       oracle_sysstat - Munin multi-graph plugin to monitor Oracle Statistics
       These modules are implemented:
         execute                 - To monitor Oracle Sysstat SQL Execute Count
         parse                   - To monitor Oracle Sysstat SQL Parse Count
         tablefetch              - To monitor Oracle Sysstat SQL Table Fetch Rows
-...
     =head1 CONFIGURATION
       To get a list of symlinks that can be created, run:
         ./oracle_sysstat_ suggest
       Make symlinks:
         munin-node-configure --families=contrib --suggest --shell
       Make symlink:
         cd /path/to/munin/etc/plugins
         ln -s /path/to/munin/lib/plugins/oracle_sysstat .
         ln -s /path/to/munin/lib/plugins/oracle_sysstat oracle_sysstat_asmusage # if necessary
         ...
       The following shows example settings for this plugin:
         [oracle_sysstat_*]
         [oracle_sysstat]
           user  oracle
           env.ORACLE_SID   ORCL
           env.ORACLE_HOME  /path/to/oracle/home
           env.oracle_auth  / as SYSDBA
           env.ORACLE_HOME  /path/to/oracle/product/version
           env.ORACLE_SID   SOMESID
         [oracle_sysstat_asmusage]
           user  grid
           env.oracle_auth  / as SYSASM
           env.ORACLE_HOME  /path/to/grid/home/version
           env.ORACLE_SID   SOMESID
           env.ORACLE_SID     +ASM
           env.ORACLE_HOME    /path/to/grid/home
           env.oracle_auth    / as SYSASM
           env.include_module asmusage
           env.plugin_name    oracle_sysstat
     =head1 ENVIRONMENT VARIABLES
       env.ORACLE_SID:
         example:  env.ORACLE_SID  SOMESID
         default:  ORCL
       env.ORACLE_HOME:
         example:  env.ORACLE_HOME  /opt/oracle/...
         default:  Try to find from oratab file
       env.oracle_auth:
         example:  env.oracle_auth user/pass as SYSDBA
         default:  / as SYSDBA
       env.exclude_module:
         example:  env.exclude_module  asmusage tablespace
         default:  asmusage
         Module name(s) to exclude seperated by white-space.
         By default, asmusage module is excluded because another privilege
         is necessary to connect ASM instance.
       env.include_module:
         example:  env.include_module  asmusage
         default:  none
         Module name(s) to include seperated by white-space.
         If both include_module and exclude_module are set, exclude will be
         ignored.
       env.plugin_name:
         example:  env.plugin_name  oracle_sysstat_2
         default:  program name (usually oracle_sysstat)
         Used for internal graph name.
         It will be useful to monitor multi-instance databases.
       env.db_name:
         example:  env.db_name  dbname
         default:  none
         Used for graph title.
         It will be useful to monitor multi-instance databases.
     =head1 NOTES
-...
       GPLv2
     =cut
     =head1 MAGIC MARKERS
     # Magic markers
     #%# family=contrib
     #%# capabilities=autoconf suggest
       #%# family=contrib
       #%# capabilities=autoconf
     # Like perl 'use strict;'
     set -o nounset
     =cut
     # Include plugin.sh
     . "${MUNIN_LIBDIR:-}/plugins/plugin.sh"
     is_multigraph "$@"
     # Environments
     : "${ORACLE_HOME:=$( echo /opt/oracle/product/* )}"
     : "${ORACLE_SID:=orcl}"
     # Like perl 'use strict;'
     set -o nounset
     # Global variables
     : "${ORACLE_SID:=ORCL}"
     : "${ORACLE_HOME:=$( cat /etc/oratab /var/opt/oracle/oratab \
         | awk -F: '$1 == "'$ORACLE_SID'" { print $2 }' 2>/dev/null )}"
     : "${oracle_auth:=/ as SYSDBA}"
     : "${exclude_module:=asmusage}"
     : "${include_module:=}"
     : "${plugin_name:=${0##*/}}"
     [ -n "${db_name:=}" ] && db_name=" ($db_name)"
     PATH=$PATH:$ORACLE_HOME/bin
     export PATH ORACLE_HOME ORACLE_SID
     # Module name
     module=$( basename "$0" | sed -e 's/^.*_//' )
     # Graph settings
     declare -A global_attrs  # required
     declare -A data_attrs    # required (format: field type draw label)
     declare -A getfield_func # optional
     declare -A getvalue_func # required
     # Note: Bash 4 (or above) is required to use hash.
     key=execute
     global_attrs[$key]="
         graph_title Oracle Sysstat SQL Execute Count
         graph_title Oracle$db_name Sysstat SQL Execute Count
         graph_category db
         graph_args --base 1000 --lower-limit 0 --rigid
         graph_vlabel count per second
-...
     key=parse
     global_attrs[$key]="
         graph_title Oracle Sysstat SQL Parse Count
         graph_title Oracle$db_name Sysstat SQL Parse Count
         graph_category db
         graph_args --base 1000 --lower-limit 0 --rigid
         graph_vlabel count per second
-...
     key=tablefetch
     global_attrs[$key]="
         graph_title Oracle Sysstat SQL Table Fetch Rows
         graph_title Oracle$db_name Sysstat SQL Table Fetch Rows
         graph_category db
         graph_args --base 1000 --lower-limit 0 --rigid
         graph_vlabel count per second
-...
     key=tablescan
     global_attrs[$key]="
         graph_title Oracle Sysstat SQL Table Scans
         graph_title Oracle$db_name Sysstat SQL Table Scans
         graph_category db
         graph_args --base 1000 --lower-limit 0 --rigid
         graph_vlabel count per second
-...
     key=transaction
     global_attrs[$key]="
         graph_title Oracle Sysstat SQL Transactions
         graph_title Oracle$db_name Sysstat SQL Transactions
         graph_category db
         graph_args --base 1000 --lower-limit 0 --rigid
         graph_vlabel count per second
-...
     key=sort
     global_attrs[$key]="
         graph_title Oracle Sysstat SQL Sorts
         graph_title Oracle$db_name Sysstat SQL Sorts
         graph_category db
         graph_args --base 1000 --lower-limit 0 --rigid
         graph_vlabel count per second
-...
     key=logon
     global_attrs[$key]="
         graph_title Oracle Sysstat User Logons
         graph_title Oracle$db_name Sysstat User Logons
         graph_category db
         graph_args --base 1000 --lower-limit 0 --rigid
         graph_vlabel count per second
-...
     key=cursor
     global_attrs[$key]="
         graph_title Oracle Sysstat User Opened Cursors
         graph_title Oracle$db_name Sysstat User Opened Cursors
         graph_category db
         graph_args --base 1000 --lower-limit 0 --rigid
         graph_vlabel count
-...
     key=enqueue
     global_attrs[$key]="
         graph_title Oracle Sysstat Enqueues
         graph_title Oracle$db_name Sysstat Enqueues
         graph_category db
         graph_args --base 1000 --lower-limit 0 --rigid
         graph_vlabel count per second
-...
     key=redolog
     global_attrs[$key]="
         graph_title Oracle Sysstat Redo Entries
         graph_title Oracle$db_name Sysstat Redo Entries
         graph_category db
         graph_args --base 1000 --lower-limit 0 --rigid
         graph_vlabel count per second
-...
     key=redosize
     global_attrs[$key]="
         graph_title Oracle Sysstat Redo Size
         graph_title Oracle$db_name Sysstat Redo Size
         graph_category db
         graph_args --base 1024 --lower-limit 0 --rigid
         graph_vlabel bytes per second
-...
     key=physicaliops
     global_attrs[$key]="
         graph_title Oracle Sysstat I/O Physical Requests
         graph_title Oracle$db_name Sysstat I/O Physical Requests
         graph_category db
         graph_args --base 1000 --lower-limit 0 --rigid
         graph_vlabel iops
-...
     key=physicalrw
     global_attrs[$key]="
         graph_title Oracle Sysstat I/O Physical Bytes
         graph_title Oracle$db_name Sysstat I/O Physical Bytes
         graph_category db
         graph_args --base 1024 --lower-limit 0 --rigid
         graph_vlabel bytes per second
-...
     key=blockrw
     global_attrs[$key]="
         graph_title Oracle Sysstat I/O Blocks
         graph_title Oracle$db_name Sysstat I/O Blocks
         graph_category db
         graph_args --base 1000 --lower-limit 0 --rigid
         graph_vlabel blocks per second
-...
     key=netrw
     global_attrs[$key]="
         graph_title Oracle Sysstat I/O Network Bytes
         graph_title Oracle$db_name Sysstat I/O Network Bytes
         graph_category db
         graph_args --base 1024 --lower-limit 0 --rigid
         graph_vlabel bytes per second
-...
     key=sgainfo
     global_attrs[$key]="
         graph_title Oracle Memory SGA
         graph_title Oracle$db_name Memory SGA
         graph_category db
         graph_args --base 1024 --lower-limit 0 --rigid
         graph_vlabel bytes
         graph_info Oracle Memory SGA
+    "
     data_attrs[$key]="
         maximum_sga_size    GAUGE LINE      Maximum SGA Size
         fixed_sga_size      GAUGE AREASTACK Fixed SGA Size
         redo_buffers        GAUGE AREASTACK Redo Buffers
         shared_pool_size    GAUGE AREASTACK Shared Pool Size
-...
         shared_io_pool_size GAUGE AREASTACK Shared IO Pool Size
         buffer_cache_size   GAUGE AREASTACK Buffer Cache Size
         in_memory_area_size GAUGE AREASTACK In-Memory Area Size
         maximum_sga_size    GAUGE LINE      Maximum SGA Size
+    "
     getvalue_func[$key]=getvalue_sgainfo
     key=pgastat
     global_attrs[$key]="
         graph_title Oracle Memory PGA
         graph_title Oracle$db_name Memory PGA
         graph_category db
         graph_args --base 1024 --lower-limit 0 --rigid
         graph_vlabel bytes
         graph_info Oracle Memory PGA
+    "
     data_attrs[$key]="
         pga_inuse        GAUGE AREA total PGA inuse
         pga_allocated    GAUGE LINE total PGA allocated
         pga_target       GAUGE LINE aggregate PGA target parameter
         pga_auto_target  GAUGE LINE aggregate PGA auto target
         pga_allocated    GAUGE LINE total PGA allocated
         pga_inuse        GAUGE AREA total PGA inuse
+    "
     getvalue_func[$key]=getvalue_pgastat
     key=cputime
     global_attrs[$key]="
         graph_title Oracle CPU Time
         graph_title Oracle$db_name CPU Time
         graph_category db
         graph_args --base 1000 --lower-limit 0 --rigid
         graph_vlabel seconds
-...
        done
+    )
     global_attrs[$key]="
         graph_title Oracle Cache Hit Ratio
         graph_title Oracle$db_name Cache Hit Ratio
         graph_category db
         graph_args --base 1000 --lower-limit 0 --upper-limit 100 --rigid
         graph_vlabel %
-...
         graph_scale no
         ${field_info}
         buf_hitratio.cdef 100,1,buf_physical,buf_logical,/,-,*,FLOOR
         lib_hitratio.cdef 100,1,lib_reloads,lib_pins,/,-,*,FLOOR
         dict_hitratio.cdef 100,dict_gets,dict_getmisses,-,dict_gets,/,*,FLOOR
         buf_hitratio.cdef 100,1,buf_physical,buf_logical,/,-,*
         lib_hitratio.cdef 100,1,lib_reloads,lib_pins,/,-,*
         dict_hitratio.cdef 100,dict_gets,dict_getmisses,-,dict_gets,/,*
+    "
     data_attrs[$key]="
         buf_hitratio GAUGE LINE Buffer Cache Hit Ratio
-...
     key=sessionuser
     global_attrs[$key]="
         graph_title Oracle Session Users
         graph_title Oracle$db_name Session Users
         graph_category db
         graph_args --base 1000 --lower-limit 0 --rigid
         graph_vlabel count
-...
     key=sessionwait
     global_attrs[$key]="
         graph_title Oracle Session Wait
         graph_title Oracle$db_name Session Wait
         graph_category db
         graph_args --base 1000 --lower-limit 0 --rigid
         graph_vlabel count
-...
     key=eventwait
     global_attrs[$key]="
         graph_title Oracle Wait Events
         graph_title Oracle$db_name Wait Events
         graph_category db
         graph_args --base 1000 --lower-limit 0 --rigid
         graph_vlabel microseconds
-...
     key=eventwaitapplication
     global_attrs[$key]="
         graph_title Oracle Wait Events Application
         graph_title Oracle$db_name Wait Events Application
         graph_category db
         graph_args --base 1000 --lower-limit 0 --rigid
         graph_vlabel microseconds
-...
     key=eventwaitnetwork
     global_attrs[$key]="
         graph_title Oracle Wait Events Network
         graph_title Oracle$db_name Wait Events Network
         graph_category db
         graph_args --base 1000 --lower-limit 0 --rigid
         graph_vlabel microseconds
-...
     key=eventwaitconcurrency
     global_attrs[$key]="
         graph_title Oracle Wait Events Concurrency
         graph_title Oracle$db_name Wait Events Concurrency
         graph_category db
         graph_args --base 1000 --lower-limit 0 --rigid
         graph_vlabel microseconds
-...
     key=eventwaituserio
     global_attrs[$key]="
         graph_title Oracle Wait Events User I/O
         graph_title Oracle$db_name Wait Events User I/O
         graph_category db
         graph_args --base 1000 --lower-limit 0 --rigid
         graph_vlabel microseconds
-...
     key=eventwaitsystemio
     global_attrs[$key]="
         graph_title Oracle Wait Events System I/O
         graph_title Oracle$db_name Wait Events System I/O
         graph_category db
         graph_args --base 1000 --lower-limit 0 --rigid
         graph_vlabel microseconds
-...
     key=eventwaitcluster
     global_attrs[$key]="
         graph_title Oracle Wait Events Cluster
         graph_title Oracle$db_name Wait Events Cluster
         graph_category db
         graph_args --base 1000 --lower-limit 0 --rigid
         graph_vlabel microseconds
-...
     key=eventwaitadministrative
     global_attrs[$key]="
         graph_title Oracle Wait Events Administrative
         graph_title Oracle$db_name Wait Events Administrative
         graph_category db
         graph_args --base 1000 --lower-limit 0 --rigid
         graph_vlabel microseconds
-...
     key=eventwaitconfiguration
     global_attrs[$key]="
         graph_title Oracle Wait Events Configuration
         graph_title Oracle$db_name Wait Events Configuration
         graph_category db
         graph_args --base 1000 --lower-limit 0 --rigid
         graph_vlabel microseconds
-...
     key=tablespace
     global_attrs[$key]="
         graph_title Oracle Table Space Usage
         graph_title Oracle$db_name Table Space Usage
         graph_category db
         graph_args --base 1000 --lower-limit 0 --upper-limit 100 --rigid
         graph_vlabel %
-...
     key=asmusage
     global_attrs[$key]="
         graph_title Oracle ASM Disk Group Usage
         graph_title Oracle$db_name ASM Disk Group Usage
         graph_category db
         graph_args --base 1000 --lower-limit 0 --upper-limit 100 --rigid
         graph_vlabel %
-...
         set feed off
         set head off
         set linesize 256
         set numwidth 20
         set numwidth 30
+    "
     # functions
     # Functions
     autoconf() {
         if [ -x "$( which "${sqlplus}" )" ]; then
-...
         fi
+    }
     suggest() {
         # print hash keys as available module names
         echo "${!global_attrs[@]}" | tr ' ' '\n' | sort
     config() {
         for module in $( module_list )
         do
             do_config
         done
+    }
     fetch() {
         for module in $( module_list )
         do
             do_fetch
         done
+    }
     config() {
     do_config() {
         local label_max_length=45
         getfield
         echo "multigraph ${plugin_name}_${module}"
         # print global attributes
         sed -e 's/^  *//' -e '/^$/d' <<< "${global_attrs[$module]}"
-...
         done <<< "${data_attrs[$module]}"
         echo graph_order "$fields"
         echo
+    }
     do_fetch() {
         echo "multigraph ${plugin_name}_${module}"
         getvalue
         echo
+    }
     module_list() {
         local i
         if [ -n "$include_module" ]; then
             echo "$include_module"
         else
             for i in $exclude_module
             do
                 # remove excluded modules
                 unset -v "global_attrs[$i]"
             done
             # print hash keys as available module names
             echo "${!global_attrs[@]}"
         fi
+    }
     # wrapper for getfield_*
-...
     SELECT 'lib_reloads.value ' || SUM(reloads) FROM v\$librarycache;
     SELECT 'dict_gets.value '      || SUM(gets)      FROM v\$rowcache;
     SELECT 'dict_getmisses.value ' || SUM(getmisses) FROM v\$rowcache;
     SELECT 'buf_hitratio.value 0' FROM dual;
     SELECT 'lib_hitratio.value 0' FROM dual;
     SELECT 'dict_hitratio.value 0' FROM dual;
     EOF
+    }
-...
     EOF
+    }
     # main
     # Main
     case ${1:-} in
     autoconf)
         autoconf
         ;;
     suggest)
         suggest
         ;;
     config)
         getfield
         config
         [ "${MUNIN_CAP_DIRTYCONFIG:-}" = "1" ] && fetch
         ;;
     *)
         getvalue
         fetch
         ;;
     esac

Formats disponibles : Unified diff

Projet

Général

Profil

Munin contributed plugins

Révision fa208cb6