Hp Neoview Release 2.3 Software Uživatelský manuál stáhnout pdf (Strana 30)

Table 3-4 QUERY_RUNTIME_STATS_V1 Field Definitions (continued)

DescriptionData Type

Field Name (* means available only in

this view)

Numeric form of the user ID, an

integer identifying the user.

INTEGER SIGNED NO DEFAULTUSER_ID

Total number of child Executor Server

Processes busy (as busy as or busier

than BUSY_THRESHOLD) during the

last interval.

INTEGER SIGNED NO DEFAULTNUM_ESPS_GT_THRESHOLD*

Total number of child Executor Server

Processes for the query.

INTEGER SIGNED NO DEFAULTNUM_CHILD_ESPS*

Total number of child Executor Server

Processes in a suspended state.

INTEGER SIGNED NO DEFAULTNUM_SUSPENDED_ESPS*

Amount of space-type memory, in

kilobytes, allocated in master and ESPs

involved in the query.

INTEGER SIGNED NO DEFAULTSQL_SPACE_ALLOCATED*

Amount of space-type memory, in

kilobytes, used in master and ESPs

involved in the query.

INTEGER SIGNED NO DEFAULTSQL_SPACE_USED*

Amount of heap-type memory, in

kilobytes, allocated in master and ESPs

involved in the query.

INTEGER SIGNED NO DEFAULTSQL_HEAP_ALLOCATED*

Amount of heap-type memory, in

kilobytes, used in master and ESPs

involved in the query.

INTEGER SIGNED NO DEFAULTSQL_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 DEFAULTEID_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 DEFAULTEID_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 DEFAULTEID_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 DEFAULTEID_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 DEFAULTSTATS_ERROR_CODE*

Number of physical disk I/O

operations performed for this

statement.

LARGEINT SIGNED NO DEFAULTDISK_IOS*

Cumulative number of times record

locks were escalated to file locks.

LARGEINT SIGNED NO DEFAULTLOCK_ESCALATIONS

Number of times the statement waited

for a lock request (concurrency cost).

LARGEINT SIGNED NO DEFAULTLOCK_WAITS

30 Repository Views

1 2 ... 25 26 27 28 29 30 31 32 33 34 35 ... 73 74

Komentáře k této Příručce

Žádné komentáře