Neoview Repository User Guide (R2.4 SP1)

ValueField
679458816“COMPILE_AFFINITY_NUM”
12“COMPILE_DEGREE_OF_PARALLELISM”
0“COMPILE_TRANSACTION_NEEDED”
0“COMPILE_MANDATORY_CROSS_PRODUCT”
0“COMPILE_MISSING_STATS”
0“COMPILE_NUM_JOINS”
1“COMPILE_FULL_SCAN_ON_TABLE”
1046.0“COMPILE_ROWS_ACCESSED_FULL_SCAN”
1046.0“COMPILE_DISK_PROCESS_ROWS_ACCESSED”
1046.0“COMPILE_DISK_PROCESS_ROWS_USED”
0.0338225“EST_COST”
52.0“EST_CARDINALITY”
NULL“EST_ACCESSED_ROWS”
NULL“EST_USED_ROWS”
0.01144“EST_IO_TIME”
0.0146622“EST_MSG_TIME”
0.5530“EST_IDLE_TIME”
0.00772028“EST_NODE_TIME”
0.0338225“EST_TOTAL_TIME”
587.8709“EST_TOTAL_MEM”
0“EST_RESOURCE_USAGE”
“INIT”“QUERY_STATUS”
“NONE”“QUERY_SUB_STATUS”
NULL“QUERY_EXECUTION_STATE”
“LOW”“WARN_LEVEL”
NULL0“STATS_ERROR_CODE”
0“WAIT_TIME”
0“HOLD_TIME”
NULL“QUERY_ELAPSED_TIME”
NULL“QUERY_ELAPSED_TIME_SEC”
NULL“SQL_PROCESS_BUSY_TIME”
NULL“SQL_PROCESS_BUSY_TIME_SEC”
NULL“DISK_PROCESS_BUSY_TIME”
NULL“DISK_IOS”
NULL“NUM_SQL_PROCESSES”
NULL“SQL_MEMORY_SPACE_ALLOCATED”
NULL“SQL_MEMORY_SPACE_USED”
80 Examples and Guidelines for Creating Repository Queries