Miscellanous facts, Rule warnings, Per-table statistics – HP Neoview Release 2.4 Software User Manual
Page 43
Description
Metric
Total heap used by the Executor in the disk process.
EID Heap Used
Total memory allocated for the query.
Total Memory Allocated
Miscellanous Facts
This “catch-all” bucket contains other facts about the query. Depending on the version of the
platform to which you are connected, the information displayed will vary. This document provides
a short description about the metrics:
Description
Metric
Query identifier.
Query ID
State of the query.
State
Role name associated with the query (role of the user running the
query).
Role Name
Name of the application that initiated this query.
Application ID
Client machine name.
Client ID
The Neoview WMS service under which the query is running.
Service
Name of the master process of the query.
Process Info
Type of SQL statement.
SQL Type
Statement ID of the query (part of the Query ID).
Statement ID
Type of DML statement.
Statement Type
The substate of the query.
Substate
Warning levels triggered by this query (rules violations).
Warning Level
Neoview WMS internal field containing the concatenated client and
application information.
Query Name
Rule Warnings
Rule warnings display any warnings of Neoview WMS rule violations. The query’s WARN_LEVEL
(Warning Level) state is an indicator of rule warnings that were generated. The warning levels
currently supported and generated are Low, Medium, and High. This information is only available
for platforms enabled with Neoview WMS support for rules (that is, R2.4 and higher).
Per-Table Statistics
Per-table statistics displays the runtime view of individual statistics for all tables involved in the
query. This document provides a short description about the columns in the Per-Table Statistics
table:
Description
Metric
Name of the table.
TableName
Compiler's estimated number of rows accessed.
EstAccessedRows
Compiler's estimated number of rows returned after applying the
predicates.
EstUsedRows
Actual number of rows accessed.
AccessedRows
Configuring Neoview WMS Services and Rules With Live View
43