NAME

oracle_sysstat_

Example Graph Example Graph

  oracle_sysstat_* - Munin plugin to monitor Oracle Statistics

    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

  To get a list of symlinks that can be created, run:   

    ./oracle_sysstat_ suggest

  Make symlinks:

    munin-node-configure --families=contrib --suggest --shell
    ...

  The following shows example settings for this plugin:

    [oracle_sysstat_*]
      user  oracle
      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

NOTES

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

AUTHOR

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

LICENSE

  GPLv2