Getting Started
      Back to home
      1. Knowledge Base | OpsLogix
      2. Oracle Management Pack
      3. Getting Started

      Oracle Management Pack Monitors , Discoveries and Rules

      The list below provides a overview of what monitors, rules and discoveries are covered by the OpsLogix Oracle management packs.

      Monitoring, Rules and Discoveries Oracle Base

      Monitors

      Name

      Target

      Enabled

      Int(s)

      Control file status

      Control File

      true

      300

      % FRA usage Monitor

      Instance

      true

      300

      Data file online status

      Data File

      true

      300

      Temp datafile status

      Data File

      true

      300

      Data file status

      Data File

      true

      300

      % Library Cache Miss Ratio

      Instance

      true

      300

      Invalid Object(s)

      Instance

      true

      300

      Database Status

      Instance

      true

      120

      Database Backup State Rollup

      Instance

      false

      300

      Max data file setting from control file

      Instance

      true

      300

      % Data Dictionary Hit Ratio

      Instance

      true

      300

      Listener connection

      Instance

      true

      60

      Redo log group

      Instance

      true

      300

      Table space

      Instance

      true

      300

      Table Space Temp

      Instance

      true

      300

      Database Read Only

      Instance

      true

      120

      % Buffer Hit Ratio

      Instance

      true

      300

      Invalid Indexes

      Instance

      true

      300

      Control file

      Instance

      true

      300

      Instance connection

      Instance

      true

      60

      % Cache Hit Ratio

      Instance

      true

      300

      Table Space Temp

      Instance

      true

      300

      Table space

      Instance

      true

      300

      Instance Uptime Monitor

      Instance

      true

      60

      Base depends on Hosts

      Monitoring Node

      true

      300

      Controlfile Backup

      Oracle Backup

      true

      3600

      Backupset

      Oracle Backup

      true

      3600

      Archivelog Backup

      Oracle Backup

      true

      3600

      SPFile Backup

      Oracle Backup

      true

      3600

      Incremental DB Backup

      Oracle Backup

      true

      3600

      Full Backup Datafile

      Oracle Backup

      true

      3600

      Full DB Backup

      Oracle Backup

      true

      3600

      Component Group Health Roll-up for type Instance

      Oracle Instances

      true

      na

      Component Group Health Roll-up for type Instance

      Oracle Instances

      false

      na

      Component Group Health Roll-up for type Instance

      Oracle Instances

      false

      na

      Component Group Health Roll-up for type Instance

      Oracle Instances

      false

      na

      Redo log file

      Redo Log Group

      true

      300

      Redo log file status

      Redo logfile

      true

      120

      Table space status

      Table Space

      true

      120

      Table Space Used %

      Table Space

      true

      300

      Table Space Used MBs

      Table Space

      false

      300

      Table Space Free MBs

      Table Space

      false

      300

      Table space Temp status

      Table Space Temp

      true

      120

      Temp Table Space Usage Pct

      Table Space Temp

      true

      300

      Rules

      Name

      Target

      Enabled

      Int(s)

      Number of Row Sorts (p/min)

      Instance

      true

      300

      Number of Disk Sorts (p/min)

      Instance

      true

      300

      Free Memory Shared Pool (MB)

      Instance

      true

      300

      Number of redo log switches per hour

      Instance

      true

      3600

      Number of commits (p/min)

      Instance

      true

      300

      10g Alert Log Messages Monitoring

      Instance

      false

      60

      Instance Inactive Session Count

      Instance

      true

      300

      Data Dictionary Hit Ratio

      Instance

      true

      300

      Total number of Rollbacks

      Instance

      true

      300

      Free Memory Large Pool (MB)

      Instance

      true

      300

      Number of Memory Sorts (p/min)

      Instance

      true

      300

      Database Size (MB)

      Instance

      true

      3600

      PGA Memory Usage (MB)

      Instance

      true

      300

      Average Data File IO Time (1/100 sec)

      Instance

      true

      300

      Library Cache Miss Ratio

      Instance

      true

      300

      Active Session Count

      Instance

      false

      300

      SQL Cache Hit Ratio

      Instance

      true

      300

      Alert Log Messages Monitoring

      Instance

      false

      60

      Number of long running operations

      Instance

      true

      300

      Redo Buffer (MB)

      Instance

      true

      300

      Buffer Hit Ratio

      Instance

      true

      300

      Number of Rollback (p/min)

      Instance

      true

      300

      Instance Active Session count

      Instance

      true

      300

      Table Space Used (Pct)

      Table Space

      true

      300

      Table Space Free (MB)

      Table Space

      true

      300

      Table Space Used (MB)

      Table Space

      true

      300

      Average Datafile I/O Write time

      Table Space

      true

      300

      Average Datafile I/O Read time

      Table Space

      true

      300

      Table Space Temp Used (Pct)

      Table Space Temp

      true

      300

      Table Space Temp Used (MB)

      Table Space Temp

      true

      300

      Table Space Temp Free (MB)

      Table Space Temp

      true

      300

       

       

       

      Discoveries

      Name

      Target

      Enabled

      Int(s)

      Populate All Oracle Instances

      All Oracle Instances

      true

      28800

      Oracle instance attribute discovery - RAC / Non-RAC

      Instance

      true

      28800

      Oracle instance attribute discovery - logical database size

      Instance

      true

      28800

      Oracle Table Space Discovery

      Instance

      true

      28800

      Oracle instance attribute discovery - Memory Max Size

      Instance

      true

      28800

      Oracle control File Discovery

      Instance

      true

      28800

      Oracle instance attribute discovery - SGA Max Size

      Instance

      true

      28800

      Oracle instance attribute discovery - Instances

      Instance

      true

      28800

      Oracle Table Space Temp Discovery

      Instance

      true

      28800

      Oracle instance attribute discovery - physical database size

      Instance

      true

      28800

      Oracle instance attribute discovery - Name - Database - Role - Log Mode - platform name

      Instance

      true

      28800

      Oracle instance attribute discovery - Up time - Version -Instance

      true

       

      28800

      Oracle Backup Discovery

      Instance

      true

      28800

      Oracle Redo Log Group Discovery

      Instance

      true

      28800

      Oracle instance attribute discovery - CPU Count

      Instance

      true

      28800

      Oracle Distributed Application Membership Discovery

      Oracle

      true

      na

      Populate Oracle 10g

      Oracle 10g Instances

      true

      na

      Populate Oracle 11g

      Oracle 11g Instances

      true

      na

      Oracle Component Membership Discovery

      Oracle Instances

      true

      na

      Populate Oracle Table Space Auto extend disabled

      Oracle Table Space Auto extend disabled

      true

      28800

      Populate Oracle Table Space Auto extend enabled

      Oracle Table Space Auto extend enabled

      true

      na

      Oracle Redo log File

      Redo Log Group

      true

      28800

      Oracle Data File Discovery

      Table Space

      true

      28800

      Oracle Temp Data File Discovery

      Temp Table Space

      true

      28800

      Monitoring, Rules and Discoverys Oracle DataGuard

      Monitors

      Name

      Target

      Enabled

      Int(s)

      DataGuard Monitor Standby Redo Log Files

      Oracle DataGuard Primary

      true

      300

      DataGuard Monitor Archive Destination Status

      Oracle DataGuard Primary

      true

      300

      DataGuard Monitor Standby Data Files

      Oracle DataGuard Primary

      true

      300

      DataGuard Monitor Apply Lag

      Oracle DataGuard Primary

      true

      300

      DataGuard Monitor Transport Lag

      Oracle DataGuard Primary

      true

      300

      DataGuard Monitor Standby Database is running in Logical Recovery

      Oracle DataGuard Primary

      true

      300

      DataGuard Monitor Archive GAP

      Oracle DataGuard Primary

      true

      300

      DataGuard Monitor Standby Database is running in media recovery

      Oracle DataGuard Primary

      true

      300

      DataGuard Monitor Apply Finish Time

      Oracle DataGuard Primary

      true

      300

         

       

       

       

       

       

       

       

       

      Rules

      Name

      Target

      Enabled

      Int(s)

      DataGuard apply lag seconds

      Oracle DataGuard Standby

      true

      900

      DataGuard transport lag seconds

      Oracle DataGuard Standby

      true

      900

      DataGuard apply finish seconds

      Oracle DataGuard Standby

      true

      900

       

       

       

      Discoveries

       

      Name

      Target

      Enabled

      Int(s)

      Oracle DataGuard Standby Discovery

      Instance

      true

      300

      Oracle DataGuard Discovery

      Instance

      true

      300

      Oracle DataGuard Standby Properties Discovery

      Oracle DataGuard Primary

      true

      300

      Oracle DataGuard Standby Properties Discovery

      Oracle DataGuard Standby

      true

      300