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.