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