Hp Neoview Release 2.3 Software Manual do Utilizador descarregar pdf (Página 23)

Table 3-2 ODBC_QUERY_STATS_V1 Field Definitions (continued)

DescriptionData TypeField Name

Repository assigned value. Used

internally.

INTEGER UNSIGNEDMETRIC_CLASS_ID

Repository assigned value. Used

internally.

INTEGER UNSIGNEDMETRIC_CLASS_VERSION

Number of rows required to

accommodate the query text, which

is provided in 3200–byte chunks.

SMALLINT UNSIGNEDSEQUENCE_SIZE

Estimated query cost.DOUBLE PRECISIONEST_COST

Cumulative number of disk reads.LARGEINTDISK_READS

Cumulative number of times record

locks were escalated to file locks.

LARGEINTLOCK_ESCALATIONS

Number of times the statement

waited for a lock request

(concurrency cost).

LARGEINTLOCK_WAITS

Size, in bytes, of the total number of

messages sent to the Encapsulated

SQL Access Manager (ESAM).

LARGEINTMESSAGE_BYTES_TO_DISK

Number of messages sent to ESAM.LARGEINTMESSAGES_TO_DISK

Cumulative number of rows accessed.LARGEINTROWS_ACCESSED

Cumulative number of rows

retrieved.

LARGEINTROWS_RETRIEVED

Number of rows inserted, updated,

deleted.

LARGEINTNUM_ROWS_IUD

Total NDCS server real time, in

microseconds, from the time the

execute or execdirect started to the

time the results were sent back.

LARGEINTQUERY_ELAPSED_TIME

Total NDCS server CPU process time,

in microseconds, from the time the

execute or execdirect started to the

time the results were sent back. Does

not include CPU time consumed by

ESP or disk processes for the query.

LARGEINTMASTER_EXEC_EXECUTION_TIME

Total number of executes performed

on this statement.

LARGEINTTOTAL_EXECUTES

Process identification number of the

NDCS server.

INTEGER UNSIGNEDPIN

START if this record contains

information collected at the start of

the query, or END if it contains

statistics collected at the end of the

query.

CHARACTER(5) or NCHAR(5)STATEMENT_STATUS

Execution priority of the NDCS

process at the time the connection

request is received.

SMALLINT UNSIGNEDSTART_PRIORITY

Prepare error code. A value of 0

indicates that the prepare was

successful.

CHARACTER(6) or NCHAR(6)ERROR_CODE

Query Statistics 23

1 2 ... 18 19 20 21 22 23 24 25 26 27 28 ... 73 74

Comentários a estes Manuais

Sem comentários

Hp Neoview Release 2.3 Software Manual do Utilizador Página 23

Comentários a estes Manuais

Manuais e produtos relacionados com Software Hp Neoview Release 2.3 Software