Checkpoints 

Definition

This submonitor in the SAP/Oracle Database Monitor displays all checkpoints found in the current alert_<SID>.log.

Use

You need to first set the init.ora parameter LOG_CHECKPOINTS_TO_ALERT to TRUE so that the information required by the monitor is written to the alert file.

You choose Detailed Analyses  ® Additional Functions  ® Checkpoints.

Then you make the following entries:

·        Select time

Enter a start date and time for the displayed checkpoints in Entries starting from or select All available to display all entries.

·        Max. lines to be displayed

Enter the maximum number of lines for the display.

You cannot view history information in this monitor.

Structure

This screen contains the following information:

Column	Description
Checkpoint Number	Number of the checkpoint
Start Date	Time the checkpoint ended
Start Time	Time the checkpoint started
End Date	Date the checkpoint ended
End Time	Time the checkpoint ended
Duration (sec)	Duration of the checkpoint in seconds
In Parallel	For parallel checkpoints, the number of checkpoints

Parallel checkpoints are indicated by:

·         A number in the in Parallel column indicating how many parallel checkpoints

·         A yellow background color