Tasks and Alerts Description
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.


Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.

Post your comment on this topic.

Post Comment