Oracle Database Monitoring

The Oracle Monitoring Probe constantly monitors the internal performance and space allocation throughout the Oracle database and feeds essential information based on pre-defined criteria to the Availability Manager for appropriate alert notification when required. An extensive range of pre-defined alerts are delivered with the Oracle Monitoring Probe and these can quickly be extended to meet the needs of specific monitoring requirements.

Fig. 1 The Oracle Monitoring Probe allows you to easily define monitoring intervals, prioritize alarms and set the level of logging detail.

Fig2. Status reports can be generated according to your specific requirements and assistance given to correct potential problems.

Fig3. You can easily set up or modify monitoring profiles to meet your changing needs and use the Hint editor to extend the DB assistance knowledge base.

Features:

Tablespace:
available free space
available continuous free space
tablespace fragmentation
status of tablespace
status of rollback segments and waits in them
status of data file(s)
Status of individual tables:
amount of extents
amount of chained rows
SGA (System Global Area):
buffer cache hit ratio
dictionary cache hit ratio
library cache hit ratio
available free memory
sort ratio, disk vs. memory
Oracle users sessions:
number of connected users to the database through SQL Net
amount of memory consumed by session
Oracle internal alerts through alertlogfile:
license high watermark
internal error messages
Redo log contention
Database objects state:
objects with invalid state (triggers, procedures and views)
invalid indexes
database objects that cannot expand
Oracle internal resource monitoring
Multiple Oracle server monitoring
DB knowledge base
Hint Assistance/Editor:
easy to extend the Database Assistance Knowledge Base being used by operators and administrators when retrieving/ analyzing the Oracle health report.