beautypg.com

List of tables – HP Neoview Release 2.5 Software User Manual

Page 7

background image

List of Tables

3-1

QUERY_STATS_VW2 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..............................................................................................37

3-5

NODE_STATS_V1 Field Definitions.............................................................................................40

3-6

DISK_STATS_V1 Field Definitions................................................................................................43

3-7

EVENTS_VW1 Field Definitions...................................................................................................46

3-8

SPACE_PARTITION_DETAIL_VW1 Field Definitions................................................................48

3-9

SPACE_PARTITION_DETAIL_HISTORY_VW1 Field Definitions..............................................50

3-10

SPACE_Q_CATALOG_SIZE_VW1................................................................................................54

3-11

SPACE_Q_DISK_FULL_VW1.......................................................................................................55

3-12

SPACE_Q_NUM_GUARDIAN_FILES_VW1................................................................................55

3-13

SPACE_Q_OBJECT_GROWTH_VW1...........................................................................................55

3-14

SPACE_Q_PARTITION_FULL_VW1............................................................................................56

3-15

SPACE_Q_SYSTEM_DETAILS_VW1............................................................................................56

3-16

SPACE_Q_SYSTEM_TOTAL_SIZE_VW1.....................................................................................56

3-17

SPACE_Q_TABLES_BY_SCHEMA_VW1.....................................................................................56

3-18

SPACE_Q_TABLE_FULL_VW1....................................................................................................57

3-19

SPACE_Q_TABLE_SIZE_VW1......................................................................................................57

3-20

SPACE_Q_TOP_10_CATEGORY_SIZE_VW1...............................................................................57

3-21

SPACE_Q_TOP_10_NON_PARTITION_DETAIL_VW1..............................................................57

3-22

SPACE_Q_TOP_10_PARTITION_DETAIL_VW1.........................................................................58

3-23

SPACE_Q_TOP_10_SCHEMA_SIZE_VW1...................................................................................58

3-24

SPACE_Q_TOP_10_TABLE_SIZE_VW1.......................................................................................58

3-25

SPACE_Q_TOP_10_USER_SPACE_SIZE_VW1............................................................................58

C-1

PROCESS_STATS_V1 Field Definitions........................................................................................75

C-2

PROCESS_AGGR_LEVEL1_STATS_V1 Field Definitions............................................................78

C-3

TABLE_STATS_V2 and TABLE_STATS_DETAIL_V2 Field Definitions.......................................83

E-1

QUERY_STATS_VW1 Field Definitions........................................................................................89

E-2

Comparison of ODBC Query Statistics and Query Runtime Statistics.......................................101

E-3

ODBC_QUERY_STATS_V1_2400 Field Definitions....................................................................102

E-4

ODBC_QUERY_STATS_V2_2400 Fields......................................................................................106

E-5

QUERY_RUNTIME_STATS_V1_2400 Field Definitions.............................................................108

E-6

ODBC_QUERY_STATS_V1 Field Definitions.............................................................................117

E-7

ODBC_QUERY_STATS_V2 Fields...............................................................................................120

E-8

QUERY_RUNTIME_STATS_V1 Field Definitions......................................................................123

F-1

Fields Not Available in Repository 2.4 SP1 Views ODBC_QUERY_STATS_V1,
ODBC_QUERY_STATS_V2, and QUERY_RUNTIME_STATS_V1..............................................132

F-2

Field Definition Changes for QUERY_RUNTIME_STATS_V1 from Repository 2.2 to Repository
2.3.................................................................................................................................................134

F-3

Field Name Mapping from TABLE_STATS_V1 to TABLE_STATS_V2.......................................134

F-4

Field Name Mapping from ACCESS_ODBCMX_QUERY_STATS_V1 to
ODBC_QUERY_STATS_V1.........................................................................................................135

F-5

Field Name Mapping from ACCESS_ODBCMX_QUERY_STATS_V2 to
ODBC_QUERY_STATS_V2.........................................................................................................135

F-6

Field Name Mapping from ACCESS_ODBCMX_SESSION_DATA_V1 to
ODBC_SESSION_STATS_V1.......................................................................................................136

F-7

Field Name Mapping from ACCESS_ODBCMX_SESSION_DATA_V2 to
ODBC_SESSION_STATS_V2.......................................................................................................136

7