Best Practice

Oracle recommends that you:

  • Use the same heartbeat frequency on all the databases to makes diagnosis easier.

  • Adjust the retention period if space is an issue.

  • Retain the default heartbeat table frequency; the frequency set to be 30 to 60 seconds gives the best results for most workloads.

  • Use lag history statistics to collect lag and age information.