Jobs for Oracle

Control Center Jobs	Description
Agresso
Agresso reports queue	Monitors and checks pending or running reports. Returns warning or alarm if the elapsed time exceeds defined threshold.
Agresso CON$ system table	Checks the size of all indexes defined on SYS.CON$ system table.
Agresso help and temp tables	Collects information about objects (temporary tables and help tables) created in the agresso application schema.
Audit
AUDIT TABLE	Checks the AUD$ trail table for CREATE TABLE, DROP TABLE and TRUNCATE TABLE audit records for audited users (DCL used: ‘AUDIT TABLE BY username’)
Audit basic login anomalies detector	Check that looks for anomalies in new sessions logging on the database
Audit local repository framework	Task that installs and upgrades the procedure for retrieving audit data in an audit repository when repository and source is on same schema(For test).
Audit login anomalies detector	Check that looks for anomalies in new sessions logging on the database
Audit remote repository framework	Task that installs and upgrades the procedure for retrieving audit data in an audit repository.
Audit source framework	Task that installs and upgrades the procedure for retrieving audit data in a audit source.
Availability
Alert log check	This check reads and looks for errors in the database alert log.
Alert log check	This check reads and looks for errors in the database alert log.
Alert log check	This check reads and looks for errors in the database alert log.
Alert log check	This check reads and looks for errors in the database alert log.
Alert log check	This check reads and looks for errors in the database alert log. Uses embedded java to read files.
Alert log check	This check reads and looks for errors in the database alert log. Uses embedded java to read files.
Archive status Check	Checks how many redolog files that are not archived.
Backup log Check 10g	Checks for errors in a log file (e.i. backup log). For backups not using RMAN.
Backup log Check 8i	Checks for errors in a log file (e.i. backup log). For backups not using RMAN.
Backup log Check 9i	Checks for errors in a log file (e.i. backup log). For backups not using RMAN.
Data Guard Archive Status	Checks that the standby database is receiving archive files from master database.
Data Guard Archive Status Check	Checks that the standby database is receiving archive files from master database.
Database link check	Checks database links.
Instance alert log	Reads and checks errors in the V$DIAG_ALERT_EXT performance view contained in the XML decoded version of the XML version of Alert log file.
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.
DBMS uptime	Collects uptime statistics in database.
Export log Check	Checks for errors in a log file (i.e. export log).
File status check	Reacts on any changes in status of data files and/or temporary files.
Job scheduling check	Detecting failed scheduled jobs. The STATUS column in the Oracle dictionary view DBA_SCHEDULER_JOB_RUN_DETAILS is used to detect scheduled jobs that have failed.
Listener log check	This checks and reads errors from the database listener log. Using Oracle native code to read.
Listener log check	This checks and reads errors from the database listener log. Using Oracle native code to read.
Listener log check	This checks and reads errors from the database listener log. Using Oracle native code to read.
Listener log check	This checks and reads errors from the database listener log. Using Oracle native code to read.
Listener log check	This checks and reads errors from the database listener log. Using Oracle native code to read.
Listener log check	This checks and reads errors in database listener log. Using embedded java to read.
Listener log check	This checks and reads errors in database listener log. Using embedded java 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 the maximum number of physical OS files, that can be mapped to an Oracle instance.
Database mount state	Checks the ‘soft limit’ and the ‘hard limit’ of the maximum number of physical OS files, that can be mapped to an Oracle instance.
Datafile status	Checks the ‘soft limit’ and the ‘hard limit’ of the maximum number of physical OS files, that can be mapped to an Oracle instance.
Max datafiles	Checks the ‘soft limit’ and the ‘hard limit’ of the maximum number of physical OS files, that can be mapped to an Oracle instance.
RMAN ARCHIVELOG backup status alert	Checks the ‘soft limit’ and the ‘hard limit’ of the maximum number of physical OS files, that can be mapped to an Oracle instance.
RMAN backup status alert	Checks the ‘soft limit’ and the ‘hard limit’ of the maximum number of physical OS files, that can be mapped to an Oracle instance.
Password expire	Checks for users whose password will soon expire.
PDB status	Alerts if PDB is not in correct state
RMAN backup status	Checks the status of RMAN backup from V$RMAN_BACKUP_JOB_DETAILS performance view.
RMAN backup status	Checks the status of RMAN backup from V$RMAN_BACKUP_JOB_DETAILS performance view.
RMAN backup status	Checks the status of RMAN backup from V$RMAN_BACKUP_JOB_DETAILS performance view.
RMAN backup status	Checks status of RMAN backup from V$RMAN_BACKUP_JOB_DETAILS performance view.
RMAN backup status	Checks the status of RMAN backup from V$RMAN_BACKUP_JOB_DETAILS performance view.
RMAN archivelog backup status	Checks the status of RMAN archivelog backup from V$RMAN_BACKUP_JOB_DETAILS performance view.
RMAN backup status	Checks the status of RMAN full backup from V$RMAN_BACKUP_JOB_DETAILS performance view for input_type ‘DB FULL‘. The procedure can also check incremental (input_type ‘DB INCR‘) level 0 backup (equivalent to full backup) by checking V$BACKUP_DATAFILE performance view (column INCREMENTAL_LEVEL=0).
RMAN incremental backup status	Checks the status of RMAN incremental backup (input_type ‘DB INCR‘) from V$RMAN_BACKUP_JOB_DETAILS performance view.
RMAN recovery area backup status	Checks the status of RMAN recovery area backup (input_type ‘RECVR AREA‘) from V$RMAN_BACKUP_JOB_DETAILS performance view.
Tablespace in BEGIN BACKUP mode	Checks if any of the tablespaces are in ‘BEGIN BACKUP‘ mode (caused by DDL ‘alter tablespace
Test alert db	Test alert that alerts every ‘X’ minutes.
Test alert	Test alert that alerts every ‘X’ minutes.
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.
Capacity
ASM disk statistics	Checks ASM disks for status and statistics.
ASM diskgroup space	Checks ASM diskgroups space statistics.
Monitor SYS.AUD$ table size	Checks size of the AUD$ trail table.
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.
Flash Recovery Area Usage	Checks space usage in the flash recovery area.
Free extents	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.
ASM diskgroup space	Checks the maximum number of processes.
Flash recovery space usage	Checks the maximum number of processes.
Max processes	Checks the maximum number of processes.
SYS.AUD$ size	Checks the maximum number of processes.
Tablespace free space	Checks the maximum number of processes.
Segment size collector	Collects size and number totals on all segment types per segment-owner and tablespace_name.
Segment size collector	Collects size and number totals on all segment types per segment-owner and tablespace_name.
Segment size collector	Collects size and extent number info for larger segments in the database.
Segment size status for old style tablespaces	Checks segment storage definitions in tablespaces where extent management is not set to local.
Temporary tablespace free space check	Checks level of free space for temporary tablespaces.
Tablespace free space check	Checks level of free space for all tablespaces.
Tablespace free space	Checks level of free space for all tablespaces.
Cluster
Applied archive log gap status	Reacts on applied archived log gaps and errors.
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.
MV Refresh Group	Checks refresh date of scheduled jobs in refresh group(s).
Dataguard apply time	Checks refresh date of scheduled jobs in refresh group(s).
Dataguard archive sequence apply lag	Checks refresh date of scheduled jobs in refresh group(s).
Dataguard standby archivelog gap	Checks refresh date of scheduled jobs in refresh group(s).
Dataguard startup time	Checks refresh date of scheduled jobs in refresh group(s).
Dataguard transport time	Checks refresh date of scheduled jobs in refresh group(s).
RAC instances status	Reacts if one or more RAC instances are not available.
Session load Rac	Records the number of active sessions over time (RAC only).
Snapshot Log(s) rows count	Checks row count on all snapshot logs for given schema.
Snapshot Log(s) size	Checks size of all snapshot logs.
Data Guard role switch	Checks size of all snapshot logs.
Compliance_licenced
Consolidation_licenced
Internal
Restore uptodate status	Checks size of all snapshot logs.
Maintenance
Framework	Engine framework is used when upgrading earlier versions of dbWatch. Ensures the dbWatch Engine and dbWatch Server run compatible codes.
Framework	Engine framework is used when upgrading earlier versions of dbWatch. Ensures the dbWatch Engine and dbWatch Server run compatible codes.
Index status check	Detecting indexes in status UNUSABLE
Index status check	Detecting indexes in status UNUSABLE
Invalid objects check	Detecting invalid objects in the database.
Extent fragmentation	Detecting invalid objects in the database.
Table statistics check	Reacts on old (or missing) statistics in DBA_TABLES dictionary table (column LAST_ANALYZED).
Maintenance_licenced
Analyze tables	Analyse tables automatically.
Delete SYS.AUD$ data	Deletes old rows from the SYS.AUD$ trail table.
Index fragmentation	Checks the index fragmentation in all database schemas. If DELETED LEAF ROWS is high, you will get low block density.
Rebuild indexes	Rebuild indexes automatically.
Table fragmentation	Checks the Table fragmentation in all database schemas.
Table fragmentation	Checks the Table fragmentation in all database schemas.
Migration_licenced
Statistics migration	Migrates statistics from a number of tasks from dbWatch version 12 to dbWatch CC.
Performance
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.
Database network statistics	Checks database network SQL*NET statistics.
Test DML performance	Runs performance test. Procedure executes SELECT, INSERT, UPDATE, DELETE and TRUNCATE statements on schema test tables.
File IO statistics	Collects I/O statistics for data files.
Instance memory statistics	Collects statistics on instance memory.
Latch statistics	Collects latch status statistics.
Long running queries	Checks for long running queries.
Open cursors	Checks and collects the amount of open cursors per session.
Disk read statistics	Collects disk read statistics from v$system_event performance view for db file sequential and dbfile scattered read event.
Disk read statistics	Collects disk read statistics from v$system_event performance view for db file sequential and dbfile scattered read event.
Redo statistics	Gets redolog files statistics. Based on Oracle dictionary and performance views.
Redo statistics	Gets redolog files statistics. Based on Oracle dictionary and performance views.
Session load	Records the number of active and inactive sessions over time.
Session load	Records the number of active sessions over time.
SQL statement statistics	Collects SQL statement statistics from v$sqlarea performance view (Oracle 18c and newer).
SQL statement statistics	Collects SQL statement statistics from v$sqlarea performance view (Oracle 10g only).
SQL statement statistics	Collects SQL statement statistics from v$sqlarea performance view (Oracle 11g only).
SQL statement statistics	Collects SQL statement statistics from v$sqlarea performance view (Oracle 12c only).
SQL waits	Collects SQL wait statistics.
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	Collects user memory statistics.
Wait statistics	Collects waits statistics encountered by threads that executed. This task is based on the v$system_event dynamic performance view.
Performance_licenced
SQL statistics	Collects SQL statements statistics from V$SQLAREA and V$SQL_PLAN dynamic performance views..
SQL statistics	Collects SQL statements statistics (for container database) from V$SQLAREA and V$SQL_PLAN dynamic performance views.
SQL statistics	Collects SQL statements statistics (for pluggable database) from V$SQLAREA and V$SQL_PLAN dynamic performance views.
SQL statistics	Collects SQL statements statistics from V$SQLAREA and V$SQL_PLAN dynamic performance views..