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.