Database System Check 

Use

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 (Oracle) and Adding Actions to the DBA Planning Calendar.

·        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.