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.
How would one go about calculating this?
asked 24 Oct '11, 12:31
There are several ways. First, you need to make sure SCN is extracted as a field (I call it
Less efficiently, but more intuitively:
answered 24 Oct '11, 12:57