HP Neoview Release 2.4 Software - Manual (Page 110)

Table C-7 QUERY_RUNTIME_STATS_V1 Field Definitions (continued)
Description Data Type
Field Name (* means available only in
this view)
Amount of “heap” type (dynamic)
memory, in kilobytes, actually used in
for query processes (master executor
and ESPs) at the beginning of query
execution. As the query executes, this
value can increase or decrease.
Maximum value of SQL_HEAP_USED
reached over the life of the query. INTEGER SIGNED NO DEFAULT SQL_HEAP_USED*
1
Amount of “space” type (static)
memory, in kilobytes, allocated
(reserved) for the Executor in Disk
(EID) disk processes involved in query
execution. This process is separate
from master and ESPs, and all the EID
memory counters are in addition to the
SQL memory counters. Maximum
value of EID_SPACE_ALLOCATED
reached over the life of the query. INTEGER SIGNED NO DEFAULT EID_SPACE_ALLOCATED*
1
Amount of “space” type (static)
memory, in kilobytes, actually used
for the Executor in Disk (EID) disk
processes involved in query execution.
Maximum value of EID_SPACE_USED
reached over the life of the query. INTEGER SIGNED NO DEFAULT EID_SPACE_USED*
1
Amount of “heap” type (dynamic)
memory, in kilobytes, allocated for the
Executor in Disk (EID) disk processes
involved in query execution.
Maximum value of
EID_HEAP_ALLOCATED reached
over the life of the query. INTEGER SIGNED NO DEFAULT EID_HEAP_ALLOCATED*
1
Amount of “heap” type (dynamic)
memory, in kilobytes, actually used
for the Executor in Disk (EID)
processes involved in query execution.
As the query executes, this value can
increase or decrease. Maximum value
of EID_HEAP_USED reached over the
life of the query. INTEGER SIGNED NO DEFAULT EID_HEAP_USED*
1
Usually the warning number that is
returned to the stats collector while
obtaining statistics from RMS. A
warning of 8922 means that one or
more nodes did not report the statistics
for the given query. INTEGER SIGNED NO DEFAULT STATS_ERROR_CODE*
Number of physical disk I/O
operations performed for this
statement. LARGEINT SIGNED NO DEFAULT DISK_IOS*
Cumulative number of times record
locks were escalated to file locks. LARGEINT SIGNED NO DEFAULT LOCK_ESCALATIONS
Number of times the statement waited
for a lock request (concurrency cost). LARGEINT SIGNED NO DEFAULT LOCK_WAITS
Number of bytes written to disk. LARGEINT SIGNED NO DEFAULT MESSAGE_BYTES_TO_DISK
Number of messages sent to disk. LARGEINT SIGNED NO DEFAULT MESSAGES_TO_DISK
110 Pre-R2.4 SP2 Query Statistics Views