HP Neoview Release 2.5 Software - Manual (Page 60)

from NEO.HP_METRICS.QUERY_STATS_VW2
ORDER BY EXEC_START_LCT_TS DESC FOR READ UNCOMMITTED ACCESS;
Retrieve Statistics for Completed Queries
This query lists information for the ten most recent queries that completed normally. You could
enhance this query to filter for time ranges, user IDs, or other attributes.
The list following the query shows values that might be returned in a single record.
SELECT [first 10] (EXEC_START_LCT_TS) AS EXEC_START_LCT_TS
,(SEGMENT_ID) AS SEGMENT_ID
,(QUERY_STATUS) AS QUERY_STATUS
,(QUERY_ELAPSED_TIME) AS QUERY_ELAPSED_TIME
,(cLIENT_NAME) AS CLIENT_NAME
from NEO.HP_METRICS.QUERY_STATS_VW2
where QUERY_STATUS='COMPLETED'
ORDER BY EXEC_START_LCT_TS DESC FOR READ UNCOMMITTED ACCESS;
Retrieve Statistics for Incomplete Queries
This query lists information about queries that have started but not ended. The result set is
ordered in descending chronological order (most recent first). The result set represents queries
that are active, queries that terminated abnormally, or queries where the user chose not to finish
fetching the data. If a query did not complete, fields that are not populated unless the query
completes have the value NULL.
The list following the query shows the values that might be associated with a specific row.
60 Examples and Guidelines for Creating Repository Queries