HP Neoview Release 2.5 Software User Manual
Page 84
Description
Field
Indicates estimated total number of rows that will be used. This
is the compiler estimate of the number of rows that the Executor
returns in the disk process (EID) after applying the predicates.
Rows Usage Estimate
Indicates estimated total amount of memory.
Total Memory Estimate
Indicates estimated total resource usage.
Resource Usage Estimate
Internal error code returned to the stats collector from the
run-time statistics (RMS) infrastructure.
Stats Error Code
Number of disk reads for accessing the tables referenced in this
statement.
Disk Ios
Number of SQL processes (excluding ESAM processes) involved
in executing the query.
Num Sql Processes
Total space allocation by Neoview SQL.
Sql Space Alloc
Total space used by Neoview SQL.
Sql Space Used
Total heap allocation by Neoview SQL.
Sql Heap Alloc
Total heap used by Neoview SQL.
Sql Heap Used
Total space allocation by the Executor in the disk process.
Eid Space Alloc
Total space used by the Executor in the disk process.
Eid Space Used
Total heap allocation by the Executor in the disk process.
Eid Heap Alloc
Total heap used by the Executor in the disk process.
Eid Heap Used
Total memory allocated for the query.
Total Memory Alloc
Maximum memory used by the query.
Max Memory Usage
Count of messages that are initiated from the Master Executor
process to ESPs or ESP to ESP. This count includes both control
and data messages.
Num Sql Request Msgs
Number of message bytes sent as part of Num Sql Request Msgs.
Num Sql Request Msg Bytes
Count of reply messages from ESPs.
Num Sql Reply Msgs
Number of bytes sent as part of the replies from ESPs.
Num Sql Reply Msg Bytes
Number of rows fetched.
Num Rows Fetched
Number of disk reads performed by the Data Access Manager
to access all the tables associated with this query.
Disk Reads
Number of times row locks escalated to file lock on any tables
associated with this query during the execution of the query.
Lock Escalations
Number of times access to tables associated with this query was
delayed due to conflicting lock mode.
Lock Waits
Number of bytes exchanged between the file system and the Data
Access Manager in accessing all tables associated with this query.
Message Bytes to Disk
Number of messages sent to the Data Access Manager to access
the table.
Messages to Disk
Number of rows accessed by the query.
Rows Accessed
Number of rows retrieved.
Rows Retrieved
Total number of rows inserted, updated, or deleted in all tables
accessed by the query.
Num Rows Iud
Number of open files.
Num Open Files
84
Use the Triage Space Pane