HP Neoview Release 2.4 Software - Manual (Page 69)

SUM(MESSAGE_BYTES_TO_DISK) as TTL_MESSAGE_BYTES_TO_DISK,
SUM(NUM_ROWS_IUD) as TTL_NUM_ROWS_IUD,
SUM(ROWS_ACCESSED) as TTL_ROWS_ACCESSED,
SUM(ROWS_RETRIEVED) as TTL_ROWS_RETRIEVED,
SUM(LOCK_ESCALATIONS) as TTL_LOCK_ESCALATIONS,
SUM(LOCK_WAITS) as TTL_LOCK_WAITS
FROM NEO.HP_METRICS.QUERY_STATS_VW1
WHERE
(ENTRY_ID_LCT_TS) >= cast(cast(('2010-03-15') as DATE) as TIMESTAMP(0))
AND (ENTRY_ID_LCT_TS) < CURRENT_TIMESTAMP
AND QUERY_STATUS = 'COMPLETED'
GROUP BY USER_NAME
ORDER BY USER_NAME;
Value Field
joesmith USER_NAME
18853 TTL_STMTS
3/31/2010 12:01 FIRST_TIME
4/23/2010 14:51 LAST_TIME
0 ERROR_COUNT
20622351 TTL_DISK_READS
29431062 TTL_MESSAGES_TO_DISK
8.98314E+11 TTL_MESSAGE_BYTES_TO_DISK
102101892 TTL_NUM_ROWS_IUD
22718676436 TTL_ROWS_ACCESSED
10293541471 TTL_ROWS_RETRIEVED
1752 TTL_LOCK_ESCALATIONS
58 TTL_LOCK_WAITS
Count Completed Queries, According to Specified Criteria
The following queries all return the number of completed queries, but they break down the
number in different ways.
Completed Queries Executed on a System in the Last 24 Hours
SELECT DISTINCT (CAST(EXEC_START_LCT_TS AS DATE)) AS START_DATE,
COUNT(*) AS NUM_OF_QUERIES,
MAX(CAST(EXEC_START_LCT_TS AS TIME(6))) AS MAX_START_TIME,
MIN(CAST(EXEC_START_LCT_TS AS TIME(6))) AS MIN_START_TIME
FROM NEO.HP_METRICS.QUERY_STATS_VW1
WHERE EXEC_START_LCT_TS <= CURRENT
AND EXEC_START_LCT_TS >= CURRENT - INTERVAL '1' DAY
AND QUERY_STATUS = 'COMPLETED'
GROUP BY 1
FOR READ UNCOMMITTED ACCESS;
MIN_START_TIME MAX_START_TIME NUM_OF_QUERIES START_DATE
15:15:34.092368 16:16:30.572346 20 2010-04-25
04:20:09.297520 10:55:26.970168 1071 2010-04-26
Count Completed Queries, According to Specified Criteria 69