Neoview Repository User Guide (R2.4 SP1)

ValueField
33328“MAX_MEMORY_EVER_USED”
NULL“TRANSACTION_ID”
321“NUM_REQUEST_MSGS”
733160“NUM_REQUEST_MSG_BYTES”
221“NUM_REPLY_MSGS”
445664“NUM_REPLY_MSG_BYTES”
NULL“FIRST_RESULT_RETURN_LCT_TS”
NULL“FIRST_RESULT_RETURN_UTC_TS”
11“ROWS_RETURNED_TO_MASTER”
NULL“PARENT_QUERY_ID”
2009-08-19 04:56:20.585779“EXEC_END_LCT_TS”
2009-08-19 11:56:20.585779“EXEC_END_UTC_TS”
9806“MASTER_EXECUTION_TIME”
0“ERROR_CODE”
100“SQL_ERROR_CODE”
NULL“ERROR_TEXT”
0“LAST_ERROR_BEFORE_AQR”
0“DELAY_TIME_BEFORE_AQR_SEC”
0“TOTAL_NUM_AQR_RETRIES”
0“LOCK_ESCALATIONS”
0“LOCK_WAITS”
808720“MESSAGE_BYTES_TO_DISK”
54“MESSAGES_TO_DISK”
1046“ROWS_ACCESSED”
1046“ROWS_RETRIEVED”
NULL“NUM_ROWS_IUD”
27“NUM_OPENS”
40917“OPEN_BUSY_TIME”
0.040917“OPEN_BUSY_TIME_SEC”
21“PROCESSES_CREATED”
63982“PROCESS_CREATE_BUSY_TIME”
0.063982“PROCESS_CREATE_BUSY_TIME_SEC”
“SELECT AVG(CPU) CPU, AVG(MEMORY) MEMORY,…”“SQL_TEXT”
0“SQL_TEXT_OVERFLOW_INDICATOR”
1 The USER_NAME value is not restricted for something as simple as “joesmith.” The value might take another form,
for example, it could be the user's email address or include a domain name.
78 Examples and Guidelines for Creating Repository Queries