Page Comparison

The Dbvisit Standby database repository (DDR) can be queried to obtain information about the standby database process. There are three methods to report on the information contained in the DDR:

...

2. The following query will report on the log archive log gap over time. Note that the archive log gap information is only saved if the dbvisit -icommand (inspect) is scheduled on a regular basis:

SELECT oracle_sid,datestamp,archive_log_gap FROM dbvisit.dbv_sequence_log ORDER BY datestamp;