| Tasks and Alerts | Description |
|---|---|
| Oracle | |
| Alert log check | This check reads and looks for errors in the database alert log. Uses embedded java to read files. |
| Alert log check 11g | This check reads and looks for errors in the database alert log. |
| Archive status Check | Checks how many redolog files that are not archived. |
| DBMS uptime | Collects uptime statistics in database. |
| Data Guard Archive Status Check | Task checks that the standby database is receiving archive files from the master database. |
| Database link check | Checks database links. |
| Database uptime | Collects database uptime statistics for all instances mounted on the database. |
| Dba Jobs check | Detecting failed scheduled jobs in old style dba_jobs. |
| Export log Check (“old style” backups) | Checks for errors in a log file (i.e. export log). |
| Extent fragmentation alert | Checks for extent fragmentation in dba_free_space |
| File status check | Task reacts on any changes on the status of data files and/or temporary files. |
| Generic log file check | This checks for errors in specified users logfile using embedded java to read. |
| Index status check | Detecting indexes in status UNUSABLE |
| Instance alert log | Reads and checks errors in the X$DBGALERTEXT performance view contained in the XML decoded version of the XML version of Alert log file. |
| Invalid objects check | Detecting invalid objects in the database. |
| Job scheduling check | Detecting failed scheduled jobs. |
| Listener log check | This checks and reads errors in database listener log. Using embedded java to read. |
| Listener log check 11g | This checks and reads errors from the database listener log. Using Oracle native code to read. |
| Listener status check | Checks listener status to verify if up and running, requires java support in the database. |
| Max datafiles check | Checks the “soft limit” and the “hard limit” of maximum number of physical OS files, that can be mapped to an Oracle instance. |
| Max process alert | Check if database reaches max processes parameter |
| Password expire | Checks for users whose password will soon expire. |
| RMAN backup status | Checks the status of RMAN backup from V$RMAN_BACKUP_JOB_DETAILS performance view. |
| TNSping check | Checks TNSping connectivity on listed targets. Task requires ‘java’ support. Supports Linux/Unix and Windows, will react with an alarm if host is unreachable. |
| ASM disk statistics check | Checks ASM disks for status and statistics. |
| ASM diskgroup check | Checks ASM diskgroups space statistics. |
| Autoextensible data files | Checks all tablespaces for total disk space usage (autoextensible data files). |
| Disk space check | Disk space check requiring java support database. (Supports Linux, Solaris, AIX, HPUX and Windows). |
| Flash Recovery Area Usage | Checks space usage in the flash recovery area. |
| Free extents check | Checks for free extents in all tablespaces. A warning or an alarm is returned if segments storage value is higher than the largest free extent chunk. |
| Max processes | Checks the maximum number of processes. |
| Monitor SYS.AUD$ table size | Checks size of the AUD$ trail table. |
| Segment size collector (all segments — aggregate) | Collects size and number totals on all segment types per segment-owner and tablespace_name. |
| Segment size collector (large segments — detail) | Collects size and extent number info for larger segments in the database. |
| Tablespace free space check | Checks level of free space for all tablespaces. |
| Temporary tablespace free space check | Checks level of free space for temporary tablespaces. |
| Blocking detector for RAC | Checks if a session is waiting on a TX (transaction) lock. (RAC only) |
| Memory session load for RAC | Records the load memory of RAC active sessions over time. |
| RAC system statistics | Collects system statistics from gv$sysstat performance view. |
| Session load Rac | Records the number of active sessions over time (RAC only). |
| Analyze tables | Analyse tables automaticly. |
| Delete SYS.AUD$ data | Deletes old rows from the SYS.AUD$ trail table. |
| Rebuild indexes | Rebuild indexs automaticly. |
| Oracle License Collector | Task collect license info on the Oracle database |
| Blocking detector | Checks if a session is waiting on a TX (transaction) lock. |
| Buffer cache statistics | Gets data cache statistics for buffer cache in SGA. |
| CPU load | Checks CPU load using Oracle performance view v$osstat. |
| DBMS waits | Collects DBMS waits statistics. |
| Database network statistics (SQL*NET) | Checks database network SQL*NET statistics. |
| Disk read statistics | Collects disk read statistics from v$system_event performance view for db file sequential and dbfile scattered read event. |
| File IO statistics | Collects I/O statistics for data files. |
| Gather statistics task | Gathers stats for historic data plotting |
| Instance memory statistics | Collects statistics on instance memory. |
| Latch statistics | Collects latch status statistics. |
| Long running queries | Checks any long running queries and then alerts. |
| Open cursors check | Checks and collects the amount of open cursors per session. |
| Redo statistics | Gets redolog files statistics. Based on Oracle dictionary and performance views. |
| SQL statement statistics 11g | Collects SQL statement statistics from v$sqlarea performance view (Oracle 11g only). |
| SQL waits | Collects SQL wait statistics. |
| Session load | Records the number of active sessions over time. |
| Table statistics check | Reacts on old (or missing) statistisc in DBA_TABLES dictionary table (column LAST_ANALYZED). |
| Test DML performance | Runs performance test. Procedure executes SELECT, INSERT, UPDATE, DELETE and TRUNCATE statements on schema test tables. |
| Top user memory usage | Check can be used to trace memory usage per server-process (session). |
| Undo statistics | Collects rollback segment statistics. |
| User memory statistics | Task collects user memory statistics. |
| Wait statistics | Collects statistics about all waits encountered by threads that executed. This task is based on the v$system_event dynamic performance view. |
| MV Refresh Group(s) Check | Checks refresh date of scheduled jobs in refresh group(s). |
| Snapshot Log(s) Size Check | Checks size of all snapshot logs. |
| Snapshot Log(s) rows count Check | Checks row count on all snapshot logs for given schema. |
Post your comment on this topic.