HP Neoview Release 2.4 Software - Manual (Page 67)

Value Field
2007-05-24 "QUERY_END_DATE_UTC"
05:30:05 "QUERY_END_TIME_UTC"
NULL "EST_COST"
2325 "QUERY_ELAPSED_TIME"
16-7 "MASTER_EXEC_EXECUTION_TIME"
0 "DISK_READS"
0 "LOCK_ESCALATIONS"
0 "LOCK_WAITS"
177744 "MESSAGE_BYTES_TO_DISK"
18 "MESSAGES_TO_DISK"
20 "ROWS_ACCESSED"
20 "ROWS_RETRIEVED"
NULL "NUM_ROWS_IUD"
1 "TOTAL_EXECUTES"
"select AVG(CPU) CPU, AVG(MEMORY) MEMORY,…" "SQL_TEXT"
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 query.
SELECT [FIRST 2] *
FROM NEO.HP_METRICS.ODBC_QUERY_STATS_V2
WHERE STATEMENT_STATE IN (’INCOMPLETE’, ’ERRTERMINATION’) ORDER BY
QUERY_START_DATETIME DESC
FOR READ UNCOMMITTED ACCESS;
Value Field
\NEO0102 “SEGMENT_NAME”
2 "SEGMENT_ID"
1 "NODE_ID"
919 "PIN"
148 "START_PRIORITY"
\NEO0102.$Z2YK “PROCESS_NAME”
“MXID01001000882212041585284557791000000000509seethadba00" "SESSION_ID"
"257 " "USER_ID"
“ROLE.DBA” “USER_NAME”
"ORDCLOVISRBTS-P2" "CLIENT_ID"
"ODBC Test (ANSI) " "APPLICATION_ID"
Retrieve Statistics for Incomplete Queries 67