I would like to display the average time Oracle is taking to perform a check point. I have filtered out the following from the log file which show the timestamp for the beginning of the check point as well as the end. Note the common link is the SCN number. So this example below would yeild 5 seconds. Mon Oct 24 15:06:58 2011 Completed checkpoint up to RBA [0x1cbf.2.10], SCN: 8494298653192 Mon Oct 24 15:06:53 2011 Beginning log switch checkpoint up to RBA [0x1cbf.2.10], SCN: 8494298653192 How would one go about calculating this? Thanks! ... View more