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

AND QUERY_START_DATETIME >= DATE_TRUNC('DAY', CURRENT - INTERVAL '1' DAY)

AND STATEMENT_STATE = 'COMPLETE'

GROUP BY 1

FOR READ UNCOMMITTED ACCESS;

MIN_START_TIMEMAX_START_TIMENUM_OF_QUERIESSTART_DATE

00:23:5912:48:46.8797744792007–05–23

13:15:1418:44:05.390777492007–05–22

Queries within the Past 24 Hours, Grouped by Client ID

This example indicates how many queries different clients ran within a 24-hour period.

SELECT client_id, COUNT(*) AS NUM_OF_QUERIES

FROM NEO.HP_METRICS.ODBC_QUERY_STATS_V2

WHERE QUERY_START_DATETIME <= CURRENT

AND QUERY_START_DATETIME >= CURRENT - INTERVAL '1' DAY

AND STATEMENT_STATE = 'COMPLETE'

GROUP BY client_id

ORDER BY client_id

FOR READ UNCOMMITTED ACCESS;

NUM_OF_QUERIESCLIENT_ID

16EXPTC082205

51ORDROBERTSC-P2

162ORDHROTHGAR-P2

28ordbantam-p2

Queries within the Past 24 Hours, Grouped by Data Source

This example indicates how many queries within the 24-hour period were associated with each

data source.

SELECT datasource, COUNT(*) AS NUM_OF_QUERIES

FROM NEO.HP_METRICS.ODBC_QUERY_STATS_V2

WHERE QUERY_START_DATETIME <= CURRENT

AND QUERY_START_DATETIME >= CURRENT - INTERVAL '1' DAY

AND STATEMENT_STATE = 'COMPLETE'

GROUP BY datasource

ORDER BY datasource

FOR READ UNCOMMITTED ACCESS;

NUM_OF_QUERIESDATASOURCE

51NEO0101_JOM

44TDM_Default_DataSource

162neodb

Queries within the Past 24 Hours, Grouped by Client ID and Including Average and

Maximum Elapsed Time

SELECT client_id,

COUNT(*) AS num_of_queries,

AVG(query_elapsed_time)/1000 AS avg_qry_elapsed_msec,

MAX(query_elapsed_time)/1000 AS max_qry_elapsed_msec

FROM NEO.HP_METRICS.ODBC_QUERY_STATS_V2

WHERE QUERY_START_DATETIME <= CURRENT

66 Examples and Guidelines for Creating Repository Queries

1 2 ... 61 62 63 64 65 66 67 68 69 70 71 72 73 74

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

Žádné komentáře

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

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

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