Hp Neoview Release 2.4 Software Manuale Utente Pagina 96
- Pagina / 128
- Indice
- SEGNALIBRI
Valutato. / 5. Basato su recensioni clienti
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
- HP Part Number: 621366-001 1
- Published: May 2010 1
- Table of Contents 3
- 4 Table of Contents 4
- Table of Contents 5 5
- List of Figures 6
- List of Tables 7
- List of Examples 8
- About This Document 9
- Notation Conventions 10
- Notation Conventions 11 11
- Related Documentation 12
- • Connectivity 13
- • Reference 13
- Publishing History 14
- HP Encourages Your Comments 14
- 1 Introduction 15
- 16 Introduction 16
- Installation 17
- Obtaining Prepackaged Queries 17
- Starting the Repository 17
- 3 Repository Views 19
- ODBC Session Data 33
- Processing Node Statistics 38
- Process Statistics 40
- Table Statistics 47
- Disk Statistics 50
- EMS Events 53
- Management 55
- SPACE_Q_CATALOG_SIZE_VW1 62
- SPACE_Q_DISK_FULL_VW1 62
- SPACE_Q_OBJECT_GROWTH_VW1 63
- SPACE_Q_PARTITION_FULL_VW1 63
- SPACE_Q_SYSTEM_DETAILS_VW1 63
- SPACE_Q_SYSTEM_TOTAL_SIZE_VW1 63
- SPACE_Q_TABLES_BY_SCHEMA_VW1 64
- SPACE_Q_TABLE_FULL_VW1 64
- SPACE_Q_TABLE_SIZE_VW1 64
- SPACE_Q_TOP_10_TABLE_SIZE_VW1 65
- Overview 67
- 0030'; 72
- Sample Query Result 82
- Releases of the Repository 83
- Query Statistics for R2.4 SP1 85
- New Fields in QUERY_STATS_VW1 117
- New Fields in SQL_TEXT_VW1 117
- New Space Management Views 117
- Glossary 125
Prodotti e manuali riguardandi Software Hp Neoview Release 2.4 Software
Software Hp XC System 3.x Software Manuale Utente
(118 pagine)
(118 pagine)
Software Hp Insight Management Agents Manuale Utente
(175 pagine)
(175 pagine)
Software Hp Smart Update Manager Manuale Utente
(130 pagine)
(130 pagine)
Software Hp ProLiant Support Pack Manuale Utente
(44 pagine)
(44 pagine)
CDA CI330 manuali
Manuali dei proprietari e guide per l'utente per Lavatrici CDA CI330.
We fornisce 1 manuali pdf CDA CI330 per scaricare gratuitamente in base al tipo di documento: Specifiche
Commenti su questo manuale