Database System Check

You can use the database system check in the Computing Center Management System (CCMS) to identify existing and approaching critical situations in your Oracle database system in time. The database system check can be executed only with the database in the OPEN state. The database system check examines the following:

Space (fill level and fragmentation)
Physical consistency (availability of data files, control files, and redo log files)
Specific problems based on DBA experience
Results of database operations
Oracle alert messages: alert_<DBSID>.log
Oracle profile parameters: init<DBSID>.ora

Integration

The database system check uses BRCONNECT functionality.

Activities

To optimize the check of the Oracle database system, do the following:

Configure the database system check according to your requirements

For more information, see Configuring Database System Check.
Automate the database system check in the DBA Planning Calendar. If you have selected an action pattern in the DBA Planning Calendar, the database system check is automatically planned to run daily every morning. See entry Check database in the calendar.
For more information, see DBA Planning Calendar and Scheduling an Action.
Monitor the results and take action for all alerts from the database system check
For more information, see Displaying Alert Messages from Database System Check.