Neoview Repository User Guide (R2.4 SP2)

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;
ValueField
joesmithUSER_NAME
18853TTL_STMTS
3/31/2010 12:01FIRST_TIME
4/23/2010 14:51LAST_TIME
0ERROR_COUNT
20622351TTL_DISK_READS
29431062TTL_MESSAGES_TO_DISK
8.98314E+11TTL_MESSAGE_BYTES_TO_DISK
102101892TTL_NUM_ROWS_IUD
22718676436TTL_ROWS_ACCESSED
10293541471TTL_ROWS_RETRIEVED
1752TTL_LOCK_ESCALATIONS
58TTL_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_TIMEMAX_START_TIMENUM_OF_QUERIESSTART_DATE
15:15:34.09236816:16:30.572346202010-04-25
04:20:09.29752010:55:26.97016810712010-04-26
Count Completed Queries, According to Specified Criteria 69