beautypg.com

6 use the system monitor – HP Neoview Release 2.4 Software User Manual

Page 5

background image

Usage Tab.........................................................................................................................................53
DDL Tab...........................................................................................................................................54
Statistics Tab....................................................................................................................................54
Privileges Tab...................................................................................................................................54
Tables Summary..............................................................................................................................55

Display Table Indexes and Their Properties.........................................................................................55

Columns Tab....................................................................................................................................56
Attributes Tab..................................................................................................................................56
DDL Tab...........................................................................................................................................57
Partitions Tab...................................................................................................................................57
Table Indexes Summary..................................................................................................................57

Display Views and Their Properties.....................................................................................................58

Columns Tab....................................................................................................................................58
Usage Tab.........................................................................................................................................59
DDL Tab...........................................................................................................................................59
Privileges Tab...................................................................................................................................59

Display Materialized Views and Their Properties................................................................................60

Attributes Tab..................................................................................................................................61
Partitions Tab...................................................................................................................................62
Usage Tab.........................................................................................................................................62
DDL Tab...........................................................................................................................................62
Privileges Tab...................................................................................................................................63
Materialized Views Summary.........................................................................................................63

Display Materialized View Indexes and Their Properties....................................................................63

Columns Tab....................................................................................................................................64
Attributes Tab..................................................................................................................................64
DDL Tab...........................................................................................................................................64
Partitions Tab...................................................................................................................................65
Materialized View Indexes Summary.............................................................................................65

Display Materialized View Groups and Their Properties....................................................................65

Attributes Tab..................................................................................................................................66
Members Tab ...................................................................................................................................66
DDL Tab...........................................................................................................................................67

Display Procedures and Their Properties.............................................................................................67

Attributes Tab..................................................................................................................................68
Parameters Tab.................................................................................................................................69
Privileges Tab...................................................................................................................................69

Display Synonyms and Their Properties..............................................................................................69

Attributes Tab..................................................................................................................................70
Usage Tab.........................................................................................................................................70
DDL Tab...........................................................................................................................................71

Display Triggers and Their Properties..................................................................................................71

Attributes Tab..................................................................................................................................72
Usage Tab.........................................................................................................................................73
DDL Tab...........................................................................................................................................73

Display Schema DDL and Their Properties..........................................................................................73

DDL Tab...........................................................................................................................................73
Show DDL .......................................................................................................................................74

Display Table Statistics and Their Properties.......................................................................................75

Display Table Column Statistics......................................................................................................75
Viewing Sampled Statistics.............................................................................................................76

6 Use the System Monitor...............................................................................................77

Display the System Monitor.................................................................................................................77

Table of Contents

5