Hp Neoview Release 2.5 Software Uživatelský manuál stáhnout pdf (Strana 4)

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

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

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

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

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

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

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

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

4 Examples and Guidelines for Creating Repository Queries....................................59

Overview...............................................................................................................................................59

Get the Number of Rows in a View......................................................................................................59

Retrieve a Specified Number of Rows from a View.............................................................................59

Retrieve Statistics for Completed Queries............................................................................................60

Retrieve Statistics for Incomplete Queries............................................................................................60

List Statement Counts for a Selected Time Period................................................................................61

Count Completed Queries, According to Specified Criteria................................................................62

Completed Queries Executed on a System in the Last 24 Hours....................................................62

Completed Queries Executed on a System in the Previous Two Days...........................................62

Queries within the Past 24 Hours, Grouped by Client Name.........................................................62

Queries within the Past 24 Hours, Grouped by Data Source..........................................................63

Queries within the Past 24 Hours, Grouped by Client Name and Including Average and

Maximum Elapsed Time.................................................................................................................63

Formatting Techniques to Enhance Readability of Query Output.......................................................63

Retrieving UCS2 Columns From a Workstation Configured for ISO8859-1........................................64

A Sample Queries for Event Information.......................................................................67

Sample Query Result............................................................................................................................72

B STATEMENT_TYPE Field...............................................................................................73

C Repository Views Disabled by Default.......................................................................75

Process Statistics...................................................................................................................................75

VIEW NEO.HP_METRICS.PROCESS_STATS_V1..........................................................................75

VIEW NEO.HP_METRICS.PROCESS_AGGR_LEVEL1_STATS_V1..............................................78

Table Statistics.......................................................................................................................................82

VIEW NEO.HP_METRICS.TABLE_STATS_V2 and VIEW

NEO.HP_METRICS.TABLE_STATS_DETAIL_V2...........................................................................83

D History of New and Changed Information in Previous Releases of the

Repository.........................................................................................................................87

New and Changed Information in Previous Editions..........................................................................87

E Pre-R2.5 Query Statistics Views..................................................................................89

Query Statistics for R2.4 SP2.................................................................................................................89

VIEW NEO.HP_METRICS.QUERY_STATS_VW1..........................................................................89

Query Statistics for R2.4 SP1...............................................................................................................101

Query Statistics for Pre-R2.4 SP1........................................................................................................101

VIEW NEO.HP_METRICS.ODBC_QUERY_STATS_V1_2400......................................................102

VIEW NEO.HP_METRICS.ODBC_QUERY_STATS_V2_2400......................................................105

4 Table of Contents

1 2 3 4 5 6 7 8 9 ... 141 142

Komentáře k této Příručce

Žádné komentáře

Hp Neoview Release 2.5 Software Uživatelský manuál Strana 4

Komentáře k této Příručce

Související produkty a manuály pro Software Hp Neoview Release 2.5 Software