This template contains performance & statistics counters for Oracle Dataguard.
Oracle client installed on Orion APM server. This is available from the SolarWinds customer portal under Additional Downloads.
:An Oracle user name and password with read access to the Oracle tables.
:MONITORED COMPONENTS
Components without predetermined threshold values provide guidance such as "Use the lowest threshold possible" or "Use the highest threshold possible" to help you find an appropriate threshold for your application. For more information, see http://knowledgebase.solarwinds.com/kb/questions/2415
LOG APPLY GAP
This component monitors the number of logs the secondary server has not yet applied.
More the value, lower is protection. The returned value will only show the results since the last polling period.
Unit: count
Source:
- https://docs.oracle.com/cd/B14117_01/server.101/b10755/dynviews_1126.htm
- https://docs.oracle.com/cd/B14117_01/server.101/b10755/dynviews_1011.htm
- https://docs.oracle.com/cd/B13789_01/server.101/b10755/dynviews_1015.htm
- https://docs.oracle.com/cd/B13789_01/server.101/b10755/dynviews_1054.htm
Log Apply LAG
This component monitors that how long it is taking secondary to apply logs.
The returned value will only show the results since the last polling period.
Unit: seconds
Source:
- https://docs.oracle.com/cd/B14117_01/server.101/b10755/dynviews_1126.htm
- https://docs.oracle.com/cd/B14117_01/server.101/b10755/dynviews_1011.htm
- https://docs.oracle.com/cd/B13789_01/server.101/b10755/dynviews_1015.htm
- https://docs.oracle.com/cd/B13789_01/server.101/b10755/dynviews_1054.htm
Log Destination error.
This component monitors the count of error(s) that has occurred on any of the destinations while applying redo logs.
Unit: count
Source:
- https://docs.oracle.com/cd/B13789_01/server.101/b10755/dynviews_1061.htm
- https://docs.oracle.com/cd/B14117_01/server.101/b10755/dynviews_1011.htm