Database System Check (SAP Library - Computing Center Management System (BC-CCM))

Database System Check

Use

You can use the database system check to identify existing and approaching critical situations in your Oracle database system in time. The database system check can be executed with the database in the OPEN state as well as in the MOUNT 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

Oracle alert messages ( <SID>alert.log )

Oracle profile parameters (init<SID>.ora)

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 (DB13). If you have selected an action pattern in the DBA Planning Calendar, the database system check (Action Check database) is automatically planned to run daily every morning.

For more information, see Using the DBA Planning Calendar 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 and Alerts from Database System Check.