Oracle RDBMS monitoring plugin

Verax NMS Oracle RDBMS management plugin enables easy monitoring, alerting, health check, management and performance reporting for Oracle databases. The plugin supports multiple instances (single or multiple hosts) of Oracle 9 and higher running in 32 and 64 bit environments.

General information view

The view presents complete information on configuration and current usage of an Oracle RDBMS instance, including:

  • Open mode, instance state & status, creation and startup times.
  • Charts for CPU usage and number of connecting processes.

Instance parameter view

Verax NMS: Oracle RDBMS management plugin

Provides a comprehensive parameter list obtained from Oracle v$parameters, including: name, current value, description and number of revisions with changelog history. The changelog is only available if Oracle administrative console is configured for the database and SYSMAN account present.

Tablespace view

The tablespace view provides a summary of all tablespaces in the database including name, status, file, extent management information, segment management information, size and usage statistics. Warning and critical usage levels are graphically indicated.

Datafile view

Comprehensive summary of data files including:

  • Datafile paths and names
  • Tablespace associations
  • Parameters: auto extensibility, maximum bytes allowed, number of blocks, maximum blocks allowed, status, online status
  • Usage information: bytes allocated, bytes free with graphical visualization

For each datafile, the following performance statistics are available:

  • Average read time
  • Average write time
  • Number of physical reads
  • Number of physical writes
  • Number of physical block reads
  • Number of physical block writes

SGA/PGA memory

SGA:

  • Memory management type and total size
  • Detailed pool list including: pool name, size and usage

PGA:

  • Total size, currently allocated, maximum allocation, hit ratio (%)
  • Graphical visualization of PGA area effectiveness (optimal, one pass, multi pass) indicating effectiveness of SQL queries

Performance view

Provides statistics for identifying database performance bottlenecks including:

  • Queries: top SQL queries including id, query text, number of executions, total (summarized) execution time - essential for query tuning and application optimization
  • Sessions: SID, terminal, user, program CPU usage, Disk I/O - allowing to identify top database users
  • Largest objects: name, type, owner, tablespace, size in MB occupied by an object. Excessive objects are identified and visualized

Session view

Provides active session summary including:

  • User name
  • Connecting host
  • Program name
  • State and blocking status

Diagnostics view

The view allows for automatic detection of abnormal database conditions examining the following values:

  • Redo switch log
  • TEMP space usage (%)
  • Sort area size
  • Number of commits per minute
  • Rate at which rollbacks are being generated
  • Number of invalid objects
  • Number of disabled triggers
  • Number of disabled constraints
  • Number of snapshot errors
  • Number of unanalyzed tables with detailed view
  • Alive status of background processes

Events and alarming

  • Alarms automatically generated based on current status on diagnostic parameters
  • Alarms raised on tablespace sizes
  • Performance counters with standard and baseline alarms on any kind of information provided by the plugin or SQL query results

Predefined Oracle RDBMS monitoring templates

The plugin provides predefined templates for most commonly monitored Oracle RDBMS items (listed in the table below). Other, user-defined sensors and performance counters can be added.

Oracle RDBMS monitoring templates
Oracle Servers Busy
Oracle DML Locks Usage
Oracle Cursors in Cache Usage
Oracle Get Hits Usage
Oracle Latches Hit ratio
Oracle Library Cache Misses
Oracle User Rollback Ratio
Oracle User Calls Per Parse
Oracle User Call Rate
Oracle Transaction Rate
Oracle Sort Overflow Ratio
Oracle Row Source Ratio
Oracle Redo Log Space Wait Ratio
Oracle Continued Row Ratio
Oracle Consistent Change Ratio
Oracle Changed Block Ratio
Oracle Calls Per Transaction
Oracle Cache Hit Ratio
Oracle Block Visits Per Transaction
Oracle Block Get Rate
Oracle Block Changes Per Transaction
Oracle Current OS Load
Oracle Host CPU Utilization
Oracle Library Cache Hit Ratio
Oracle Buffer Cache Hit Ratio
Oracle Active session count
Oracle Archiveed Logs Area Free Space
Oracle Availability
Oracle Average Synchronous Single-Block Read Latency
Oracle Background CPU Usage Per Sec
Oracle Consistent Read Changes Per Sec
Oracle Consistent Read Gets Per Sec
Oracle CPU Usage Per Sec
Oracle Current Logons Count
Oracle Current Open Cursors Count
Oracle Data Block Corruptions
Oracle DB Block Changes Per Sec
Oracle DB Block Gets Per Sec
Oracle Disk Sort Per Sec
Oracle Disk/Storage Free Space
Oracle Enqueue Deadlocks Per Sec
Oracle Enqueue Requests Per Sec
Oracle Enqueue Timeouts Per Sec
Oracle Enqueue Waits Per Sec
Oracle Error on execute of jobs
Oracle Executions Per Sec
Oracle Global Cache Average CR Get Time
Oracle Hard Parse Ratio
Oracle Host CPU Usage Per Sec
Oracle I/O Megabytes per Second
Oracle I/O Requests per Second
Oracle Internal errors
Oracle Logical Reads Per Sec
Oracle Logons Per Sec
Oracle Memory Errors
Oracle Memory Sort
Oracle Memory Sorts Ratio
Oracle Network Traffic Volume Per Sec
Oracle Open Cursors Per Sec
Oracle Parse Count (hard)
Oracle Parse Count (soft)
Oracle Parse Count (total)
Oracle Physical Read Bytes Per Sec
Oracle Physical Read IO Requests Per Sec
Oracle Physical Read Total Bytes Per Sec
Oracle Physical Reads Direct Per Sec
Oracle Physical Reads Per Sec
Oracle Physical Writes Direct Per Sec
Oracle Physical Writes Per Sec
Oracle Redo Generated Per Sec
Oracle Redo Writes Per Sec
Oracle Rollback Ratio User rollback ratio
Oracle Session Count
Oracle Session Limit %
Oracle Snapshot too old
Oracle Soft Parse Ratio
Oracle Sorts (disk)
Oracle Sorts (memory)
Oracle Sorts (rows)
Oracle SQL Service Response Time
Oracle System Waits By Average Time Waited
Oracle System Waits By Total Number of Waits
Oracle Tablespace Free Space
Oracle User Calls Per Sec
Oracle User Commits Per Sec
Oracle User Rollbacks Per Sec
Oracle User Transaction Per Sec

Others

  • Integration with the Enterprise Manager console

See also

Microsoft SQL Server management plugin »

IBM DB2 management plugin »

MySQL management plugin »

PostgreSQL management plugin »