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

The list following the query shows values that might be returned in a single record.

select [first 10] *

from NEO.HP_METRICS.ODBC_QUERY_STATS_V2

where STATEMENT_STATE = ’COMPLETE’

ORDER BY QUERY_START_DATETIME DESC

FOR READ UNCOMMITTED ACCESS;

ValueField

\NEO0102“SEGMENT_NAME”

2"SEGMENT_ID"

1"NODE_ID"

653"PIN"

148"START_PRIORITY"

\NEO0102.$Z2YK“PROCESS_NAME”

"MXID01001000882212041585284557791000000000509SUPER.SERVICES00""SESSION_ID"

"511 ""USER_ID"

"ROLE.DBA ""USER_NAME"

"ORDCLOVISRBTS-P2""CLIENT_ID"

"ODBC Test (ANSI) ""APPLICATION_ID"

"neo0102_clo""DATASOURCE"

"MXID01001000882212041585284557791000000000509SUPER.SERVICSE00_118

_SQL_CUR_26680060

"QUERY_ID"

"SQL_CUR_26680060 ""STATEMENT_ID"

"SQL_SELECT-NON_UNIQUE""STATEMENT_TYPE"

"COMPLETE ""STATEMENT_STATE"

"N""QUERY_TEXT_IS_MULTIROW"

“<N/A>”"ERROR_CODE"

0"SEQUENCE_NUM"

2007-05-23 22:30:05.867082"QUERY_START_DATETIME"

2007-05-23"QUERY_START_DATE"

22:30:05"QUERY_START_TIME"

2007-05-24 05:30:05.867610"QUERY_START_DATETIME_UTC"

2007-05-24"QUERY_START_DATE_UTC"

05:30:05"QUERY_START_TIME_UTC"

2007-05-23 22:30:05.867647"QUERY_END_DATETIME"

2007-05-23"QUERY_END_DATE"

22:30:05"QUERY_END_TIME"

2007-05-24 05:30:05.867610"QUERY_END_DATETIME_UTC"

2007-05-24"QUERY_END_DATE_UTC"

05:30:05"QUERY_END_TIME_UTC"

NULL"EST_COST"

62 Examples and Guidelines for Creating Repository Queries

1 2 ... 57 58 59 60 61 62 63 64 65 66 67 ... 73 74

Žádné komentáře

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