NAME

oracle_sysstat

Example Graph Example Graph

  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
    tablescan               - To monitor Oracle Sysstat SQL Table Scans
    transaction             - To monitor Oracle Sysstat SQL Transactions
    sort                    - To monitor Oracle Sysstat SQL Sorts
    logon                   - To monitor Oracle Sysstat User Logons
    cursor                  - To monitor Oracle Sysstat User Opened Cursors
    enqueue                 - To monitor Oracle Sysstat Enqueues
    redolog                 - To monitor Oracle Sysstat Redo Entries
    redosize                - To monitor Oracle Sysstat Redo Size
    physicaliops            - To monitor Oracle Sysstat I/O Physical Requests
    physicalrw              - To monitor Oracle Sysstat I/O Physical Bytes
    blockrw                 - To monitor Oracle Sysstat I/O Blocks
    netrw                   - To monitor Oracle Sysstat I/O Network Bytes
    sgainfo                 - To monitor Oracle Memory SGA
    pgastat                 - To monitor Oracle Memory PGA
    cputime                 - To monitor Oracle CPU Time
    cachehit                - To monitor Oracle Cache Hit Ratio
    sessionuser             - To monitor Oracle Session Users
    sessionwait             - To monitor Oracle Session Wait
    eventwait               - To monitor Oracle Wait Events
    eventwaitapplication    - To monitor Oracle Wait Events Application
    eventwaitnetwork        - To monitor Oracle Wait Events Network
    eventwaitconcurrency    - To monitor Oracle Wait Events Concurrency
    eventwaituserio         - To monitor Oracle Wait Events User I/O
    eventwaitsystemio       - To monitor Oracle Wait Events System I/O
    eventwaitcluster        - To monitor Oracle Wait Events Cluster
    eventwaitadministrative - To monitor Oracle Wait Events Administrative
    eventwaitconfiguration  - To monitor Oracle Wait Events Configuration
    tablespace              - To monitor Oracle Table Space Usage
    asmusage                - To monitor Oracle ASM Disk Group Usage

CONFIGURATION

  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]
      user  oracle
      env.ORACLE_SID   ORCL
      env.ORACLE_HOME  /path/to/oracle/home
      env.oracle_auth  / as SYSDBA

    [oracle_sysstat_asmusage]
      user  grid
      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

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.

NOTES

  Uses the command "sqlplus".
  Tested with Oracle Database 12c R1.

AUTHOR

  K.Cima https://github.com/shakemid

LICENSE

  GPLv2

MAGIC MARKERS

  #%# family=contrib
  #%# capabilities=autoconf