Hp Neoview Release 2.5 Software Manual de usuario descargar pdf (Pagina 126)

Table E-8 QUERY_RUNTIME_STATS_V1 Field Definitions (continued)

DescriptionData Type

Field Name (* means available only in

this view)

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 DEFAULTEID_HEAP_USED*

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 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

Number of bytes written to disk.LARGEINT SIGNED NO DEFAULTMESSAGE_BYTES_TO_DISK

Number of messages sent to disk.LARGEINT SIGNED NO DEFAULTMESSAGES_TO_DISK

Number of records accessed by the

disk process or the file system to

evaluate the statement.

LARGEINT SIGNED NO DEFAULTROWS_ACCESSED

Cumulative number of rows retrieved.LARGEINT SIGNED NO DEFAULTROWS_RETRIEVED

Number of rows

updated/inserted/deleted. This value

is NULL for queries in process or for

which the Repository did not receive

end statistics. It is 0 for SELECT

queries for which the Repository

received end statistics and >0 for UID

queries for which the Repository

received end statistics.

LARGEINT SIGNED NO DEFAULTNUM_ROWS_UID

Time, in microseconds, that the query

spent in the Workload Management

queue before it started executing.

INTERVAL SECOND(12,6) NO

DEFAULT

QUE_TIME*

Number of OPEN calls performed by

the Executor on behalf of this query.

LARGEINT SIGNED NO DEFAULTOPENS*

An approximation of the total node

time spend in master and ESPs

involved in the query. The node time

is expressed in microseconds.

INTERVAL SECOND(12,6) NO

DEFAULT

SQL_PROCESS_BUSY_TIME*

Number of new processes created by

the Executor on behalf of this process.

INTEGER SIGNED NO DEFAULTNUM_PROCESSES_CREATED*

126 Pre-R2.5 Query Statistics Views

1 2 ... 121 122 123 124 125 126 127 128 129 130 131 ... 141 142

Comentarios a estos manuales

Sin comentarios

Hp Neoview Release 2.5 Software Manual de usuario Pagina 126

Comentarios a estos manuales

Relacionado con productos y manuales para Software Hp Neoview Release 2.5 Software