Components of Healthcheck Information

The Healthcheck script generates an HTML file with JSON objects and HTML code, which you can view using a web browser.

The output of the Healthcheck script contains the following sections:

Overview
Extract
Replicat
Table Statistics and Errors
Tools
Report Map (Legacy)

Each of these sections contain menus and sub-menus depending on the type of data available.

The following table describes the sections and the data available in those sections based on the query used to generate the Healthcheck output.

Menu	Description
Overview	The Overview section contains information about the following: General Findings Database, Extract and Replicat Summary Capture Parameters Apply Parameters
Database		Main Menu (The Main menu already contains the query information)
Database Objects		This sub-menu option displays information about the following: Tables Not Supported By Oracle GoldenGate Integrated Capture Instantiation SCNs for Apply Schema and Database (DDL)
Database Details		This sub-menu has a detailed database related various connections and services along with key Oracle GoldenGate parameters and the manual or modified database parameters. The second part shows the basic information about the components, software and patch level of the database. The information is distributed amongst the following sections. Connection Information Key init.ora parameters Database dictionary and fixed table statistics Software edition Registry information including History Replication bundled patch information NLS Database parameters Registered log files for capture Current Database incarnation Standby redo longs GoldenGate Administrator User
Replication SQL Analysis		This section provides a complete log of Oracle GoldenGate related information from the session at run time of the script and active session history. This contains complete details about Waits, Events, IO, Contention and SQL.
Objects Instantiation		This sub-menu provides details about the schemas and table-level supplemental logging for Oracle GoldenGate: Schemas prepared for capture Table-level supplemental log groups enabled for capture
Extract		Main Menu
Extract Details		The Extract details covered in this sub-menu are: Capture Runtime Information Capture Transaction Processing Capture Processing Information Logminer Session Statistics Capture Rules & Rulesets
Extract Performance		This sub-menu displays information about the Extract performance depending on the type of Extract being used. It displays the progress of the Extract which includes the following details: Capture Name - Name of the Extract Client Name - Name of the client where the Extract is running Client Status - Status of the client where the Extract is running Processed Low SCN - Processed SCN value of the Extract Oldest SCN - Oldest SCN value of the Extract
Extract Logminer		This sub-menu contains information mainly used for debugging issues.
Replicat		Main Menu
Replicat Performance		The Replicat performance provides the following information: Apply Progress GoldenGate Inbound Progress Table Information about Apply Progress table Apply Network Receiver (ANR) Apply Reader Apply Reader - Dequeue Information Apply Coordinator Apply Coordinator Watermarks Open GoldenGate Apply Transactions Open GoldenGate Apply Transactions -Details Apply Server Transactions ordered by Server_id Apply Server Statstics - Summary Apply Server Statistics - Details Apply Server Statistics - Auto Tuning Apply Server Wait Events Apply Server Session Events Apply Reader Processes Apply Coordinator Processes Apply Server Processes
CDR		This sub-menu provides a detailed log of the Replicat error handlers.
Apply Handler		This sub-menu contains information about the Replicat name, DDL handler, and precommit handler.
Error Management		Main Menu
Error Management Details		This sub-menu has details about the Oracle GoldenGate table statistics sorted by table. It includes information such as server name, source table owner, source table name, destination table owner, destination table name, total operations, inserts, updates, deletes, insert/update/delete collisions, REPERROR discards, REPERROR ignores, WAIT dependencies, and CDR related updates.
Tools		Main Menu
History		This sub-menu is dependent on the type of query you have run and displays subscriber history, Extract, and Replicat history.
Report Map		Main Menu (Legacy). It provides information on all the queries, which includes details such as: Run time of the query Number of Returned Rows Information if the query has succeeded or failed Information if this is internal information that is only visible if the script is run as SYS Disabled Queries The hyperlinks directs you to the appropriate query.
Hints/Description		This sub-menu is a map of all the activities logged in the Healthcheck report.
Alerts		This sub-menu provides a log of the alerts from the general findings about the database, Extract, and Replicat along with general system information.
Truncates		This sub-menu displays the Oracle GoldenGate related information from the `V$ACTIVE_SESSSION_HISTORY` and `V$SQLAREA` database views. Note: You can view only partial results for `V$ACTIVE_SESSSION_HISTORY` , as the original size of the query exceeds the maximum limit.
Config		This sub-menu allows you to add rules to the following sections that are available on this page: Column Rules: There can be any number of rules on a single table and they will be applied one after the other in the order they appear in the rules table. It can be an expression using the values of the columns in a row. Menu Items Exclusions: This option is used to exclude any menu item from the Healthcheck output. Click Add to set the rule. Group By: This section is used to group by keys and aggregates. You can go to any statistic and click G to add a group by sorting.
JS Errors		Main Menu. This page displays debugging information for this framework. Note: It is visible only in case of errors.