The following tabs show real-time monitoring information and historical data to use for troubleshooting and tuning the Oracle GoldenGate replication solution. Anyone with any security role can view these tabs.

• The Metrics and Alerts tab is the main monitoring console of Oracle GoldenGate Monitor. It focuses on objects that are not in a normal state, such as those that have an error status. See Monitoring the Oracle GoldenGate System.

• The History tab focuses on historical and logged data for the attributes that are associated with a selected Oracle GoldenGate object. Working with History Information.

1. Expand the Navigation Tree nodes to navigate to the Oracle GoldenGate object or group of objects that you want to monitor. See About the Objects.
2. On the tree nodes, check for alerts and status indicators that indicate whether there is a potential problem or state change that applies to the selected node. An alert or status indicator on any container node or Oracle GoldenGate Instance node indicates that you should drill down further to locate the object that is affected. See About the Status Indicators.
3. Select any object in the tree for which you want more information. The Navigation Tree works with the Diagram View to show the selected object along with other objects to which it has a logical relationship. For example, if you selected a Host node, you will see all of the Oracle GoldenGate components on that system, in their correct context. You can use the toolbar to navigate the diagram, if needed. See About the Diagram View.
4. In the diagram, check for alerts and status indicators, and evaluate the summary attributes, not only for the selected object but also for the other objects. Those objects might be the cause of, or might also be affected by, the condition that you are observing.

   Note:

   You can click any area of the Overview panel to focus on a specific part of the diagram.

5. Select any object in the diagram (or tree) and then view the Metrics Panel to get detailed data for all of the attributes that are associated with the object. See About the Metrics.

   Note:

   You can sort the attributes by the Name column. You can double-click the header area, or click the embedded arrow, to expand or collapse the panel.

6. (Optional) In the Metrics Panel, click the history icon () next to any attribute. This will open the History tab and show historical data for that attribute. See Working with History Information.
7. Select any object in the diagram (or tree) and then view the Alerts Panel to get details about any active alerts that were triggered for the object, including the text of the alert, the time that it occurred, and the condition that triggered it. See About Alerts.

   Note:

   You might have to double-click the Alerts header area to expand the panel to view it. You can double-click the header area, or click the embedded arrow, to expand or collapse the panel.

8. (Optional) Focus on objects that have warning or error conditions. See Viewing Warning or Error Conditions.

1. Select any object in the diagram. You can click any area of the Overview panel to focus on a specific part of the diagram. Use the diagram tools in the toolbar to interact with the diagram. See About the Diagram View.
2. View the Metrics Panel to get detailed data for all of the attributes that are associated with the object. See About the Metrics.

   Note:

   You can sort the attributes by the Name column. You can double-click the header area, or click the embedded arrow, to expand or collapse the panel.

3. (Optional) In the Metrics Panel, click the history icon next to any metric for which you want to view historical data on the History tab. See Working with History Information.
4. View the Alerts Panel to get details about any active alerts that were triggered for the object, including the text of the alert, the time that it occurred, and the condition that triggered it. See About Alerts.

   Note:

   You might have to double-click the Alerts header area to expand the panel to view it. You can double-click the header area, or click the embedded arrow, to expand or collapse the panel.

2014-04-15 05:42:08 INFO OGG-01738 Oracle GoldenGate Capture for Oracle, extaa.prm: BOUNDED RECOVERY: CHECKPOINT: for object pool 1: p31714_extr: start=SeqNo: 263, RBA: 29534736, SCN: 0.6146203 (6146203), Timestamp: 2014-04-15 05:41:09.000000, Thread: 1, end=SeqNo: 263, RBA: 29536256, SCN: 0.6146203 (6146203), Timestamp: 2014-04-15 05:41:09.000000, Thread: 1.
2014-04-15 01:42:00 INFO OGG-01738 Oracle GoldenGate Capture for Oracle, extaa.prm: BOUNDED RECOVERY: CHECKPOINT: for object pool 1: p31714_extr: start=SeqNo: 263, RBA: 23313936, SCN: 0.6138834 (6138834), Timestamp: 2014-04-15 01:40:11.000000, Thread: 1, end=SeqNo: 263, RBA: 23316480, SCN: 0.6138834 (6138834), Timestamp: 2014-04-15 01:40:11.000000, Thread: 1.
2014-04-14 21:41:54 INFO OGG-01738 Oracle GoldenGate Capture for Oracle, extaa.prm: BOUNDED RECOVERY: CHECKPOINT: for object pool 1: p31714_extr: start=SeqNo: 262, RBA: 23449104, SCN: 0.6123109 (6123109), Timestamp: 2014-04-14 21:40:57.000000, Thread: 1, end=SeqNo: 262, RBA: 23450112, SCN: 0.6123109 (6123109), Timestamp: 2014-04-14 21:40:57.000000, Thread: 1.
2014-04-14 17:54:50 INFO OGG-00987 Oracle GoldenGate Command Interpreter for Oracle: GGSCI command (espear): info repaa detail.
2014-04-14 17:52:24 INFO OGG-03522 Oracle GoldenGate Delivery for Oracle, repaa.prm: Setting session time zone to source database time zone 'GMT'.

The History tab contains the Metrics and Alerts subtabs that enable you to view performance statistics, event messages, lag, and other information that occurred over a specific time period. You can analyze this data to identify persistent trouble spots or processes that need performance tuning.

Historical data can be obtained for any metric of an Oracle GoldenGate component. See About the Metrics.

The historical data of an metric can be represented either as a chart, as a table, or both, depending on the type of metric.

• The table view displays the selected metric data in a tabular format. The column names vary, depending on the metric that was selected.

• The chart view has two independent charts to allow comparison between different date ranges for the given metric. The tools on the tool bar control the navigation in this view and the display format of the historical data. See History Tab Toolbar.

You can use the following icons, located at the top right-hand corner of the tab, to toggle between chart and table view (if valid for the metric).

1. Log in with at least the Power User role.
2. On the Utility Bar, click Purge Data.

   The Purge Data dialog box appears.

   
   Description of the illustration purge_data.gif
3. Select the kind of data to purge: Historical Data, Alert Notices, or both.
4. For Purge Before Date, enter a date that represents the oldest data that you want to keep (using the date-time format shown), or click the calendar icon to select the date from a calendar. All of the selected data before that date will be deleted permanently. You can purge just one kind of data the first time, and then you can purge the other kind using a different purge date.
5. Click Purge. You are not prompted to confirm this action.
6. Click OK on the confirmation. You are returned to the Purge Data dialog box to do additional purging, if desired.

1. Select an object in the Navigation Tree. The closer to the root level of the tree that you go, the more alerts that will be displayed, because the selection encompasses alerts for all of the objects within the sub-nodes.
2. View the alerts on the Alerts subtab. This table displays the name of the alert (as specified in the alert definition), the actual notification message (which is the same as that which is sent to email, SNMP, or CLI clients if active), and the time that the alert was generated. You can sort the Alert Name column in ascending or descending order.