HP Neoview Release 2.4 Software - Manual (Page 19)

3 Repository Views
Overview
You can use the following views for access to the Repository:
• “VIEW NEO.HP_METRICS.QUERY_STATS_VW1” (page 19)
• “VIEW NEO.HP_METRICS.SQL_TEXT_VW1” (page 32)
• “VIEW NEO.HP_METRICS.ODBC_SESSION_STATS_V1” (page 33)
• “VIEW NEO.HP_METRICS.ODBC_SESSION_STATS_V2” (page 36)
• “VIEW NEO.HP_METRICS.NODE_STATS_V1” (page 38)
• “VIEW NEO.HP_METRICS.PROCESS_STATS_V1” (page 40)
• “VIEW NEO.HP_METRICS.PROCESS_AGGR_LEVEL1_STATS_V1” (page 43)
• “VIEW NEO.HP_METRICS.TABLE_STATS_V2 and VIEW
NEO.HP_METRICS.TABLE_STATS_DETAIL_V2” (page 48)
• “VIEW NEO.HP_METRICS.DISK_STATS_V1” (page 50)
• “VIEW NEO.HP_METRICS.EVENTS_VW1” (page 53)
• “VIEW NEO.HP_METRICS.SPACE_PARTITION_DETAIL_VW1” (page 55)
• “VIEW NEO.HP_METRICS.SPACE_PARTITION_DETAIL_HISTORY_VW1” (page 58)
Views are reinstalled every time the Repository installation is run. Reinstalling the views picks
up any view definition changes.
Query Statistics
The Repository defines these views for retrieval of query statistics information:
• For query information as of R2.4 SP1 or later, use these views:
— QUERY_STATS_VW1
— SQL_TEXT_VW1
• For query statistics information prior to R2.4 SP2, see Appendix C (page 85) .
VIEW NEO.HP_METRICS.QUERY_STATS_VW1
Repository collects compilation and execution query statistics.
This view provides access to all query information. The SQL text for the query is also included,
up to 254 characters. If the SQL text is longer than 254 characters, the
SQL_TEXT_OVERFLOW_INDICATOR
field is set to 1 to indicate that only part of the SQL text fits
in this view, and the complete SQL text is placed in the SQL_TEXT_VW1 view. In this case,
QUERY_STATS_VW1 has the first 254 characters and SQL_TEXT_VW1 has the complete SQL
text. The QUERY_STATS_VW1 view can be joined with the SQL_TEXT_VW1 view through the
EXEC_START_LCT_TS (or EXEC_START_UTC_TS) and QUERY_ID fields to fetch the full SQL
text for the query.
Character columns use ISO88591 or UCS2 encoding, as appropriate to the Neoview platform
configuration. If the platform is UCS2 or SJIS, all character columns are created with CHARACTER
SET UCS2. If the platform is ISO88591, all CHAR columns are created with CHARACTER SET
ISO88591.
The Primary Key for QUERY_STATS_VW1 field definition is EXEC_START_UTC_TS and
QUERY_ID.
Overview 19