The illustration shows part of the main page of an HTML report generated by the SHOW_STATS_HTML
procedure.
The report includes the following links in the "Contents" section:
Legend
Event Metrics
Paths
Path Summary
Path Level Event Summary
Rate Level Stats
The "Legend" section contains a table with the following columns: "Acronym," "Component," "Throughput," and "Rate 2." The table includes the following rows:
CAPTURE, Capture Component, msgs enqueued/sec, msgs captured/sec
LMR, Log Miner Reader, n/a, n/a
LMP, Log Miner Preparer, n/a, n/a
LMB, Log Miner Builder, n/a, n/a
CP, Capture Process, n/a, n/a
Q, Queue, enqueued/sec, no of msgs in queue
PS, Propagation Sender, msgs/sec, bytes/sec
PR, Propagation Receiver, n/a, n/a
APPLY, Apply component, msgs applied/sec, txns applied/sec
APR, Apply Reader, n/a, n/a
APC, Apply Coordinator, n/a, n/a
APS, Apply Slave, n/a, n/a
The "Event Metrics" section contains a table with the following columns: "Metric" and "Description." The table includes the following rows:
IDLE%, Percent of time in the run, spent waiting on upstream component
FLWCTRL%, Percent of time in the run, spent waiting on downstream component
TOPEVENT, Non-idle, Non-flwctrl Event which occupies most of run time
TOPEVENT%, Percent of time in the run, spent on Topevent
The "Paths" section contains a "Path 1" table with the following columns: "Component," "Name," and "Database." The table includes the following rows:
CAPTURE, CAP$_XOUT_1, blank
Q, "XSTRMADMIN"."Q$_XOUT_2", blank
APPLY, XOUT, blank
The "Path Level Summary" section contains a table with the following columns: "Path Id," "Avg CAPTURE msgs/sec," "Avg CAPTURE latency," "Avg APPLY txns/sec," "Avg APPLY msgs/sec," and "Avg APPLY latency." The table includes the following row:
1, 9464.64, 1.25, 85.37, 9221.91, 1.56