Hp Neoview Release 2.5 Software Manuel d'utilisateur Page 206
- Page / 284
- Table des matières
- MARQUE LIVRES
Noté. / 5. Basé sur avis des utilisateurs
DescriptionFieldGroup Box
Timestamp when the first row was returned from the root operator of
the master executor process. A value of -1 means that the first row has
not yet been returned.
First Row Returned
Processor (CPU) utilization, in seconds, by Neoview SQL for the querySQL CPU (sec)
Processor (CPU) utilization, in seconds, by the disk processProcess Busy Time (sec)
Amount of time, in seconds, spent on opensOpen (sec)
Amount of time, in seconds, to create Executor Server Processes (ESPs)Process Create (sec)
The compiler's estimated number of rows accessedEst Accessed RowsUsage
Actual number of rows accessedAccessed Rows
The compiler's estimated number of rows returned after applying
predicates
Est Used Rows
Actual number of rows returned after the predicates were applied. In
a pushed down plan, all the used rows might not be returned.
Used Rows
Number of messagesMessage Count
Number of message bytes sent while accessing the tables referenced by
the query
Message Bytes
Number of bytes returned for the statistics countersStats Bytes
Number of disk reads for accessing the tables referenced in the queryDisk I/Os
Number of rows returned from the root operator of the master executor
process
Rows Returned
Number of messages initiated from the master to ESPs or from an ESP
to ESPs
Req Message Count
Number of message bytes that are sent from the master to ESPs or from
an ESP to ESPs as part of the request messages
Req Message Bytes
Number of reply messages from the ESPs for the message requestsReply Message Count
Number of bytes sent as part of the reply messagesReply Message Bytes
Total space allocation by Neoview SQL for the querySQL Space AllocMemory (KB)
Total space used by Neoview SQL for the querySQL Space Used
Total heap allocation by Neoview SQL for the querySQL Heap Alloc
Total heap used by Neoview SQL for the querySQL Heap Used
Total space allocation by the executor in the disk processEID Space Alloc
Total space used by the executor in the disk processEID Space Used
Total heap allocation by the executor in the disk processEID Heap Alloc
Total heap used by the executor in the disk processEID Heap Used
Total memory allocated for the query, which is the sum of the SQL Space
Used and SQL Heap Used
Total Mem Alloc
Maximum memory used by the query, which is the sum of the SQL
Space Alloc, SQL Heap Alloc, EID Space Alloc, and EID Heap Alloc
Max Mem Used
Total amount of processor (CPU) time used by the query, which is the
sum of the SQL CPU time, Process Busy Time, Open time, and Process
Create time. The display is in seconds.
Total CPU (sec)Derived Time
Total amount of processor (CPU) time used by the query. The display
format is hh:mm:ss.sss for hours, minutes, and seconds.
Total Processor
206 Find Offending Processes and Queries
- HP Part Number: 613120-001 1
- Published: July 2010 1
- Table of Contents 3
- 4 Table of Contents 4
- Table of Contents 5 5
- 6 Table of Contents 6
- Table of Contents 7 7
- 8 Table of Contents 8
- Table of Contents 9 9
- Table of Contents 11 11
- About This Guide 13
- Intended Audience 14
- Related Documentation 15
- • Connectivity 16
- • Reference 16
- Resources on the Web 17
- Send Feedback to HP 17
- 1 About HPDM 19
- 20 About HPDM 20
- 2 Install and Start HPDM 23
- Exit the HP Database Manager 24
- 3 Connect and Disconnect 25
- Password Considerations 27
- Disconnect From a System 27
- Log On and Off 28
- Use the Systems Tool 28
- Add a System 29
- Use the Add System Dialog Box 30
- Edit a System 32
- Add a System Like 33
- Remove a System 33
- Test a System 33
- Set the Connection Timeout 34
- 4 Navigate HPDM 35
- Use the Navigation Tree Pane 37
- Use the Right Pane 39
- Use the My Favorites Pane 40
- See the HPDM Banner 41
- Use Menu Bar Commands 42
- Use the Tools Menu Options 43
- Use the Windows Menu Options 43
- Use the Help Menu Options 43
- Use the HPDM Toolbar 44
- Manage Multiple Open Windows 45
- Clone Tabs 46
- Expand and Collapse Panes 46
- Sort and Move Data Columns 47
- Work With Data Grids 48
- Work With Data Grids 49 49
- Copy Data-Grid Information 50
- Work With Data Grids 51 51
- Customize the Data Grid 52
- Search the Data Grid 52
- Export Data 53
- Use the System Message Tab 54
- Create a System Message 54
- Clone the System Message Tab 55
- View Event Messages 56
- 6 Display Database Objects 63
- Attributes Tab 64
- Tables Tab 64
- Materialized Views Tab 64
- Materialized View Groups Tab 64
- Views Tab 65
- Procedures Tab 65
- Synonyms Tab 65
- Privileges Tab 66
- Schema Size 66
- Columns Tab 67
- Primary Key Tab 68
- Hash Key Tab 68
- Unique Constraints Tab 68
- Foreign Keys Tab 69
- Partitions Tab 69
- Usage Tab 69
- Statistics Tab 70
- Tables Summary 71
- Table Indexes Summary 73
- 76 Display Database Objects 76
- Materialized Views Summary 80
- Members Tab 84
- Parameters Tab 86
- Show DDL 92
- Viewing Sampled Statistics 94
- 7 Manage Roles 95
- 96 Manage Roles 96
- Add a Role 97
- Delete a Role 98
- Grant a Role to a User 98
- Use the Grant Role Dialog Box 99
- Revoke a Role From a User 99
- 8 Manage Users and Passwords 103
- Add a Database User 104
- Related Topics 105
- Add Multiple Database Users 106
- Copy a Database User 107
- Use the Edit User Dialog Box 109
- Platform Users 111
- Add a Platform User 112
- Copy a Platform User 112
- Edit a Platform User 114
- Passwords for Users 115
- 9 Manage Security Policies 117
- 118 Manage Security Policies 118
- 10 Manage Certificates 125
- Use the Generate CSR Tab 128
- 11 Manage Directory Servers 131
- • LDAP directory server 136
- Example: LDAP Server 137
- Edit a Directory Server 139
- Delete a Directory Server 140
- 12 Manage Data Sources 141
- Create a Data Source 142
- Use the DEFINEs and SETs Tab 147
- FunctionButton 148
- 148 Manage Data Sources 148
- Use the Controlled Tables Tab 149
- Copy a Data Source 150
- Start a Data Source 151
- Stop a Data Source 151
- Update a Data Source 152
- Delete a Data Source 152
- Delete a Data Source 153 153
- 13 Manage Connectivity 155
- Stop an NDCS Server 157
- Display NDCS Services 157
- Start an NDCS Service 158
- Stop an NDCS Service 159
- Start and Stop Server Traces 160
- Learn About Server Traces 160
- 14 Manage NDCS Privileges 161
- Revoke NDCS Privileges 162
- 15 Manage Procedures 163
- Download a JAR File 164
- Rename a JAR File 164
- Delete a JAR File 165
- Create a Procedure 165
- 166 Manage Procedures 166
- Use a Method in a Procedure 168
- Drop a Procedure 169
- 16 Use the System Monitor 171
- About the Timeline Tab 173
- About the Hybrid Tab 174
- 176 Use the System Monitor 176
- Change a Color Option 179
- 17 Respond to Alerts 181
- Understand Alerts 182
- Get Information About Alerts 183
- Control the Refresh of Alerts 187
- Update an Alert 189
- Update Multiple Alerts 190
- Make Notes About an Alert 190
- About the Console Tab 191
- About System Offender 193
- For example: 195
- Get Pstate Information 197
- DescriptionField or Option 198
- Query Information 202
- Compiler Statistics 203
- Runtime Statistics 205
- 19 Use the SQL Whiteboard 211
- 212 Use the SQL Whiteboard 212
- Understand Parameter Prompts 214
- Understand Page Mode 214
- Execute Highlighted Text 215
- Reuse a Connection 216
- Highlight SQL Syntax 217
- Manage the Layout of Panes 217
- 20 Use Metric Miner 219
- Launch Metric Miner 220
- See the Parts of Metric Miner 220
- Use the Metric Miner Toolbar 222
- Create Report Folders 224
- Run Statements 225
- Add Parameters to Statements 226
- Resolve Out-of-Memory Errors 228
- Export Metric Miner Data 228
- Run Statements 229 229
- Create and Manage Reports 230
- Configuration dialog box 231
- Modify a Saved Report 232
- Close a Report 233
- Delete a Report 233
- Copy a Report 233
- Import Neoview Reports 234
- Link and Drill Down 235
- Link and Drill Down 237 237
- Learn About NCI 239
- Locate the NCI Program 239
- Launch NCI 239
- Set Auto Logon Options 240
- 22 Manage Disk Space 241
- 242 Manage Disk Space 242
- 244 Manage Disk Space 244
- About the Monitoring Tab 246
- View the System Overall 248
- View the System Detail 249
- 250 Manage Disk Space 250
- View SQL Objects 252
- View the SQL Objects Detail 253
- 254 Manage Disk Space 254
- View Table Growth 257
- By Table Tab 258
- 260 Manage Disk Space 260
- About the Configuration Tab 261
- About the General Tab 262
- Space Reference Settings 263
- About the Advanced Tab 264
- Inventory Options 265
- Update Space Reference Tables 265
- System Registry Table Tab 266
- Glossary 267
- 268 Glossary 268
- 270 Glossary 270
- 272 Index 272
- 274 Index 274
- 276 Index 276
- 278 Index 278
- 280 Index 280
- 282 Index 282
Produits connexes et manuels pour Logiciel Hp Neoview Release 2.5 Software
(15 pages)
(37 pages)
(120 pages)© 2020, manymanuals.fr. Tous droits réservés | 0.064 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Commentaires sur ces manuels