Control Center Jobs Description
Availability
database link check Checks database links.
Database uptime Collects database uptime statistics for all instances mounted on the database.
DBMS uptime Collects uptime statistics in database.
File status check Reacts on any changes in status of data files and/or temporary files.
Index status check Detecting indexes in status UNUSABLE
Invalid objects check Detecting invalid objects in the database.
Job scheduling check Detecting failed scheduled jobs.
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.
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.
Test alert Test alert that alerts every ‘X’ minutes on instance level
Test alert db Test alert that alerts every ‘X’ minutes on db level
Capacity
Autoextensible data files Checks all tablespaces for total disk space usage (autoextensible data files).
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.
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.
Cluster and Replication
MV Refresh Group(s) Checks refresh date of scheduled jobs in refresh group(s).
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.
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 (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.
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 Checks and collects the amount of open cursors per session.
Redo statistics Gets redolog files statistics. Based on Oracle dictionary and performance views.
Session load Records the number of active sessions over time.
SQL statement statistics Collects SQL statement statistics from v$sqlarea performance view (Oracle 11g only).
SQL waits Collects SQL wait statistics.
Table statistics check Reacts on old (or missing) statistisc in DBA_TABLES dictionary table (column LAST_ANALYZED).
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 statistics about all waits encountered by threads that executed. This task is based on the v$system_event dynamic performance view.
Maitenance
Analyze Table Analyse tables automatically
Delete SYS.AUD$ data Delete old rows from the SYS.AUD$ trail table
Rebuild Indexes Rebuild Indexes Automatically

← Control Center Jobs / For MySQL and MariaDB →

Feedback

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