Software User guide

ValueField
"neo0102_clo""DATASOURCE"
"MXID01001000882212041585284557791000000000509seethadba00_118
_SQL_CUR_26680060
"QUERY_ID"
"SQL_CUR_26680060 ""STATEMENT_ID"
"SQL_SELECT-NON_UNIQUE""STATEMENT_TYPE"
"INCOMPLETE""STATEMENT_STATE"
"N""QUERY_TEXT_IS_MULTIROW"
“”"ERROR_CODE"
0"SEQUENCE_NUM"
0“SEQUENCE_SIZE”
2007-05-23 22:30:05.867082"QUERY_START_DATETIME"
2007-05-23"QUERY_START_DATE"
22:30:05"QUERY_START_TIME"
2007-05-24 05:30:05.867610"QUERY_START_DATETIME_UTC"
2007-05-24"QUERY_START_DATE_UTC"
05:30:05"QUERY_START_TIME_UTC"
NULL"QUERY_END_DATETIME"
NULL"QUERY_END_DATE"
NULL"QUERY_END_TIME"
NULL"QUERY_END_DATETIME_UTC"
NULL"QUERY_END_DATE_UTC"
NULL"QUERY_END_TIME_UTC"
NULL"EST_COST"
NULL"QUERY_ELAPSED_TIME"
NULL"MASTER_EXEC_EXECUTION_TIME"
NULL"DISK_READS"
NULL"LOCK_ESCALATIONS"
NULL"LOCK_WAITS"
NULL"MESSAGE_BYTES_TO_DISK"
NULL"MESSAGES_TO_DISK"
NULL"ROWS_ACCESSED"
NULL"ROWS_RETRIEVED"
NULL"NUM_ROWS_IUD"
NULL"TOTAL_EXECUTES"
"select AVG(CPU) CPU, AVG(MEMORY) MEMORY,…""SQL_TEXT"
68 Examples and Guidelines for Creating Repository Queries