Hp Neoview Release 2.3 Software Uživatelský manuál stáhnout pdf (Strana 58)

Table 3-12 Field Name Mapping from ACCESS_ODBCMX_QUERY_STATS_V1 to

ODBC_QUERY_STATS_V1 (continued)

Field Name in ODBC_QUERY_STATS_V1Field Name in ACCESS_ODBCMX_QUERY_STATS_V1

LOCK_WAITSLOCKWAITS

MESSAGE_BYTES_TO_DISKMSGSBYTESTODISC

MESSAGES_TO_DISKMSGSTODISC

QUERY_ELAPSED_TIMEODBC_ELAPSED_TIME

MASTER_EXEC_EXECUTION_TIMEODBC_EXECUTION_TIME

Column Removed - Duplicate of

QUERY_ELAPSED_TIME

TOTAL_ODBC_ELAPSED_TIME

Column Removed - Duplicate of

MASTER_EXEC_EXECUTION_TIME

TOTAL_ODBC_EXECUTION_TIME

SEGMENT_NAMENODENAME

The following table shows how fields defined in the view ACCESS_ODBCMX_QUERY_STATS_V2

were renamed in the view ODBC_QUERY_STATS_V2.

Table 3-13 Field Name Mapping from ACCESS_ODBCMX_QUERY_STATS_V2 to

ODBC_QUERY_STATS_V2

Field Name in ODBC_QUERY_STATS_V2Field Name in ACCESS_ODBCMX_QUERY_STATS_V2

SEGMENT_NAMENODENAME

NODE_IDCPU_NUM

STATEMENT_TYPEQUERY_TYPE

STATEMENT_STATEQUERY_STATE

QUERY_START_DATETIME_UTC,

QUERY_START_DATE_UTC,

QUERY_START_TIME_UTC

START_ENTRY_ID

QUERY_START_DATETIME, QUERY_START_DATE,

QUERY_START_TIME

START_ENTRY_ID_LCT

QUERY_END_DATETIME_UTC,

QUERY_END_DATE_UTC, QUERY_END_TIME_UTC

END_ENTRY_ID

QUERY_END_DATETIME, QUERY_END_DATE,

QUERY_END_TIME

END_ENTRY_ID_LCT

EST_COSTESTIMATED_COST

QUERY_ELAPSED_TIMEODBC_ELAPSED_TIME

MASTER_EXEC_EXECUTION_TIMEODBC_EXECUTION_TIME

DISK_READSDISC_READS

LOCK_ESCALATIONSLOCKESCALATIONS

LOCK_WAITSLOCKWAITS

MESSAGE_BYTES_TO_DISKMSGSBYTESTODISC

MESSAGES_TO_DISKMSGSTODISC

The following table shows how fields defined in the view

ACCESS_ODBCMX_SESSION_DATA_V1 were renamed in the view ODBC_SESSION_STATS_V1.

58 Repository Views

1 2 ... 53 54 55 56 57 58 59 60 61 62 63 ... 73 74

Komentáře k této Příručce

Žádné komentáře

Hp Neoview Release 2.3 Software Uživatelský manuál Strana 58

Komentáře k této Příručce

Související produkty a manuály pro Software Hp Neoview Release 2.3 Software