Hp Neoview Release 2.3 Software Manuel d'utilisateur télécharger pdf (Page 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

Commentaires sur ces manuels

Pas de commentaire

Hp Neoview Release 2.3 Software Manuel d'utilisateur Page 58

Commentaires sur ces manuels

Produits connexes et manuels pour Logiciel Hp Neoview Release 2.3 Software