Hp Neoview Release 2.4 Software Manual de usuario descargar pdf (Pagina 96)

Table C-4 QUERY_RUNTIME_STATS_V1_2400 Field Definitions (continued)

DescriptionData Type

Field Name (* means available only in

this view)

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*

Estimated number of rows to be

accessed from Disk Process at runtime

by EID (Executor in Disk Process). This

value is meaningful for SELECT, not

for Insert/Update/Delete. For

Insert/Update/Delete, the value is

reported as 0.0.

DOUBLE PRECISION NO DEFAULTEST_ACCESSED_ROWS*

Estimated number of rows to be

returned by EID after applying

selection predicates.

DOUBLE PRECISION NO DEFAULTEST_USED_ROWS*

96 Pre-R2.4 SP2 Query Statistics Views

1 2 ... 91 92 93 94 95 96 97 98 99 100 101 ... 127 128

Comentarios a estos manuales

Sin comentarios

Hp Neoview Release 2.4 Software Manual de usuario Pagina 96

Comentarios a estos manuales

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