HP Neoview Release 2.4 Software - Manual (Page 7)

List of Tables
3-1 QUERY_STATS_VW1 Field Definitions........................................................................................20
3-2 SQL_TEXT_VW1 Field Definitions...............................................................................................32
3-3 ODBC_SESSION_STATS_V1 Field Definitions.............................................................................33
3-4 ODBC_SESSION_STATS_V2 Fields..............................................................................................36
3-5 NODE_STATS_V1 Field Definitions.............................................................................................38
3-6 PROCESS_STATS_V1 Field Definitions........................................................................................41
3-7 PROCESS_AGGR_LEVEL1_STATS_V1 Field Definitions............................................................44
3-8 TABLE_STATS_V2 and TABLE_STATS_DETAIL_V2 Field Definitions.......................................48
3-9 DISK_STATS_V1 Field Definitions................................................................................................50
3-10 EVENTS_VW1 Field Definitions...................................................................................................53
3-11 SPACE_PARTITION_DETAIL_VW1 Field Definitions................................................................55
3-12 SPACE_PARTITION_DETAIL_HISTORY_VW1 Field Definitions..............................................58
3-13 SPACE_Q_CATALOG_SIZE_VW1................................................................................................62
3-14 SPACE_Q_DISK_FULL_VW1.......................................................................................................62
3-15 SPACE_Q_NUM_GUARDIAN_FILES_VW1................................................................................62
3-16 SPACE_Q_OBJECT_GROWTH_VW1...........................................................................................63
3-17 SPACE_Q_PARTITION_FULL_VW1............................................................................................63
3-18 SPACE_Q_SYSTEM_DETAILS_VW1............................................................................................63
3-19 SPACE_Q_SYSTEM_TOTAL_SIZE_VW1.....................................................................................63
3-20 SPACE_Q_TABLES_BY_SCHEMA_VW1.....................................................................................64
3-21 SPACE_Q_TABLE_FULL_VW1....................................................................................................64
3-22 SPACE_Q_TABLE_SIZE_VW1......................................................................................................64
3-23 SPACE_Q_TOP_10_CATEGORY_SIZE_VW1...............................................................................64
3-24 SPACE_Q_TOP_10_NON_PARTITION_DETAIL_VW1..............................................................65
3-25 SPACE_Q_TOP_10_PARTITION_DETAIL_VW1.........................................................................65
3-26 SPACE_Q_TOP_10_SCHEMA_SIZE_VW1...................................................................................65
3-27 SPACE_Q_TOP_10_TABLE_SIZE_VW1.......................................................................................65
3-28 SPACE_Q_TOP_10_USER_SPACE_SIZE_VW1............................................................................66
C-1 Comparison of ODBC Query Statistics and Query Runtime Statistics.........................................85
C-2 ODBC_QUERY_STATS_V1_2400 Field Definitions......................................................................86
C-3 ODBC_QUERY_STATS_V2_2400 Fields.......................................................................................90
C-4 QUERY_RUNTIME_STATS_V1_2400 Field Definitions...............................................................92
C-5 ODBC_QUERY_STATS_V1 Field Definitions.............................................................................101
C-6 ODBC_QUERY_STATS_V2 Fields...............................................................................................104
C-7 QUERY_RUNTIME_STATS_V1 Field Definitions......................................................................107
D-1 Fields Not Available in Repository 2.4 SP1 Views ODBC_QUERY_STATS_V1,
ODBC_QUERY_STATS_V2, and QUERY_RUNTIME_STATS_V1..............................................118
D-2 Field Definition Changes for QUERY_RUNTIME_STATS_V1 from Repository 2.2 to Repository
2.3.................................................................................................................................................120
D-3 Field Name Mapping from TABLE_STATS_V1 to TABLE_STATS_V2.......................................120
D-4 Field Name Mapping from ACCESS_ODBCMX_QUERY_STATS_V1 to
ODBC_QUERY_STATS_V1.........................................................................................................121
D-5 Field Name Mapping from ACCESS_ODBCMX_QUERY_STATS_V2 to
ODBC_QUERY_STATS_V2.........................................................................................................121
D-6 Field Name Mapping from ACCESS_ODBCMX_SESSION_DATA_V1 to
ODBC_SESSION_STATS_V1.......................................................................................................122
D-7 Field Name Mapping from ACCESS_ODBCMX_SESSION_DATA_V2 to
ODBC_SESSION_STATS_V2.......................................................................................................122
7