Oracle RDBMS monitoring and management plugin

play

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

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 contains predefined templates for most commonly monitored Oracle RDBMS server items. Most important, selected templates are provided in the table below (other, additional sensors and performance counters can be added by the user):

Others

• Integration with the Enterprise Manager console

See also

Microsoft SQL Server management plugin 

MySQL management plugin 

PostgreSQL management plugin