HP Neoview Release 2.3 Software User Manual
Page 30
Table 3-4 QUERY_RUNTIME_STATS_V1 Field Definitions (continued)
Description
Data Type
Field Name (* means available only in
this view)
Numeric form of the user ID, an
integer identifying the user.
INTEGER SIGNED NO DEFAULT
USER_ID
Total number of child Executor Server
Processes busy (as busy as or busier
than BUSY_THRESHOLD) during the
last interval.
INTEGER SIGNED NO DEFAULT
NUM_ESPS_GT_THRESHOLD*
Total number of child Executor Server
Processes for the query.
INTEGER SIGNED NO DEFAULT
NUM_CHILD_ESPS*
Total number of child Executor Server
Processes in a suspended state.
INTEGER SIGNED NO DEFAULT
NUM_SUSPENDED_ESPS*
Amount of space-type memory, in
kilobytes, allocated in master and ESPs
involved in the query.
INTEGER SIGNED NO DEFAULT
SQL_SPACE_ALLOCATED*
Amount of space-type memory, in
kilobytes, used in master and ESPs
involved in the query.
INTEGER SIGNED NO DEFAULT
SQL_SPACE_USED*
Amount of heap-type memory, in
kilobytes, allocated in master and ESPs
involved in the query.
INTEGER SIGNED NO DEFAULT
SQL_HEAP_ALLOCATED*
Amount of heap-type memory, in
kilobytes, used in master and ESPs
involved in the query.
INTEGER SIGNED NO DEFAULT
SQL_HEAP_USED*
Amount of space-type memory, in
kilobytes, allocated in Executor in Disk
(EID) of Disk processes involved in the
query.
INTEGER SIGNED NO DEFAULT
EID_SPACE_ALLOCATED*
Amount of space-type memory, in
kilobytes, used in Executor in Disk
(EID) of Disk processes involved in the
query.
INTEGER SIGNED NO DEFAULT
EID_SPACE_USED*
Amount of heap-type memory, in
kilobytes, allocated in Executor in Disk
(EID) of Disk processes involved in the
query.
INTEGER SIGNED NO DEFAULT
EID_HEAP_ALLOCATED*
Amount of heap-type memory, in
kilobytes, allocated in Executor in Disk
(EID) of Disk processes involved in the
query.
INTEGER SIGNED NO DEFAULT
EID_HEAP_USED*
Usually the warning number that is
returned to the stats collector while
obtaining statistics from RTS. 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
30
Repository Views