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

Table E-5 QUERY_RUNTIME_STATS_V1_2400 Field Definitions (continued)

DescriptionData Type

Field Name (* means available only in

this view)

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*

Estimated cost (time in seconds) of the

SQL operations in the Master Executor.

The estimate occurs at the time the

query is prepared.

DOUBLE PRECISION NO DEFAULTEST_COST*

112 Pre-R2.5 Query Statistics Views

1 2 ... 107 108 109 110 111 112 113 114 115 116 117 ... 141 142

Comentarios a estos manuales

Sin comentarios

Hp Neoview Release 2.5 Software Manual de usuario Pagina 112

Comentarios a estos manuales

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