NMS for Oracle

The Nimsoft Monitoring Solution (NMS) for Oracle constantly monitors the internal performance and space allocation throughout the Oracle database.

Based pre-defined criteria, the solution feeds essential information to the NMS management console for appropriate alert notification when required.

An extensive range of check points can be selected and individually scheduled to meet an administrator’s specific monitoring requirements.

Comprehensive Coverage of Oracle

NMS for Oracle constantly monitors internal performance and space allocation throughout the Oracle database and generates appropriate alert notifications when required.

An extensive range of pre-defined alerts are delivered with NMS for Oracle, and these can quickly be extended to a range of specific monitoring requirements.

NMS for Oracle provides these monitoring 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 user 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.