Description of the illustration utl_spadv_html.gif
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