To monitor Oracle Data Guard / Standby log apply latency, you can create a custom alert in DPA using a Custom SQL – Single Numeric Return type, as shown below. Use the attached query that returns the apply lag (number of logs behind) for the standby database. This value can then be used to configure warning and critical thresholds, helping you detect when the standby is falling too far behind the primary.
