In-depth understanding of Oracle exadata
Basic Information
Original Title: Expert Oracle exadata
Author: (US) ossborne (K.) [Translator's introduction]
Translator: Huang kaiyao Zhang leyi Zhang Rui
Press: Electronic Industry Press
ISBN: 9787121174896
Mounting time:
Published on: February 1, July 2012
Start: 16
Page number: 1
Version: 1-1
Category: computer more about, in-depth understanding of Oracle exadata
Introduction
Books
Computer books
An in-depth understanding of Oracle exadata deeply explains the features of exadata, such as intelligent scanning, hybrid columnar storage, storage indexing, smart flash memory, and IO resource management; it systematically introduces how to install, configure, and manage exadata. It perfectly describes the wait events, performance monitoring, and optimization methods of exadata; analyzes the Internal principles of computing and storage nodes in detail, and shares valuable experience gained by the authors in practical projects, for example, how to efficiently transplant big data, some common mistakes in exadata, and database resource management. This book is a summary and sublimation of practical experience. It is highly readable. It not only has in-depth research on exadata, but also shows them elegantly. It will lead readers to the exadata Hall.
Go back to the top of the catalog to learn more about Oracle exadata
The author introduces XXXI
Technical Reviewer XXXIII
Thank you XXXV
Preface XXXVII
Chapter 1 What is exadata? 1
1.1 exadata Overview 2
1.2 exadata history 3
1.3 different perspectives 4
1.3.1 Data Warehouse Device 4
1.3.2 online transaction processing machine 5
1.3.3 merge platform 5
1.4 optional configuration 6
1.4.1 exadata database machine x2-2 6
1.4.2 exadata database machine x2-8 7
1.5 hardware component 8
1.5.1 operating system 9
1.5.2 Database Server 9
1.5.3 Storage Server 9
1.5.4 InfiniBand 10
1.5.5 flash 10
1.5.6 disk 10
1.5.7 miscellaneous 10
1.6 software components 11
1.6.1 database server software 11
1.6.2 storage server software 14
1.7 Software Architecture 16
1.8 conclusion 20
Chapter 21 uninstall/smart scan 21
2.1 Why uninstall is so important 21
2.2 uninstall what 25 contains
2.2.1 field projection 25
2.2.2 predicate filter 30
2.2.3 storage index 32
2.2.4 simple connection (Bloom filtering) 33
2.2.5 function uninstall 36
2.2.6 compression/Decompression 38
2.2.7 encryption/Decryption 40
2.2.8 virtual column 40
2.2.9 Data Mining Model score 43
2.2.10 uninstalling non-intelligent scanning 44
2.3 prerequisites for smart scanning 45
2.3.1 full scan 45
2.3.2 direct path read 45
2.3.3 exadata storage 46
2.4 inability to use smart scanning 49
2.4.1 unimplemented functions 49
2.4.2 switch to block transport mode 49
2.4.3 skip some detach operations 50
2.5 how to verify that smart scanning does happen 50
2.5.1 10046 tracking 52
2.5.2 Performance Statistics (V $ sessstat) 53
2.5.3 uninstall applicable byte 55
2.5.4 SQL Monitoring 60
2.6 parameter 63
2.7 conclusion 67
Chapter 2 hybrid column compression 69
3.1 Oracle storage overview 69
3.2 Oracle compression mechanism 72
3.2.1 basic 72
3.2.2 OLTP 72
3.2.3 HCC 72
3.3 mechanism of operation of HCC 76
3.4 performance 77
3.4.1 loading performance 77
3.4.2 query performance 82
3.4.3 DML performance 88
3.5 expected compression rate 98
3.5.1 compression assistant 98
3.5.2 real case 101
3.6 restrictions and challenges 107
3.6.1 migrate data to non-exadata platform 107
3.6.2 disable serial direct path read 108
3.6.3 lock issue 108
3.6.4 single-row access 109
3.7 common use cases 110
3.8 Conclusion 111
Chapter 2 Storage index 4th
4.1 structure 113
4.2 monitoring storage index 114
4.2.1 database statistics 115
4.2.2 tracking 116
4.2.3 conclusion 119
4.3 Control Storage index 119
4.3.1 _ kcfis_storageidx_disabled 120
4.3.2 _ kcfis_storageidx_diag_mode 120
4.3.3 _ cell_storidx_mode 120
4.3.4 storage software parameters 121
4.4 million behaviors 121
4.5 performance 122
4.5.1 special optimization 124 for null values
4.5.2 physical distribution of Field Values 125
4.6 potential problems 127
4.6.1 incorrect results 127
4.6.2 type conversion 128
4.6.3 partition size 131
4.6.4 incompatible programming techniques 131
4.7 conclusion 133
Chapter 2 exadata smart flash 5th
5.1 hardware 135
5.2 cache vs. Flash Disk 136
5.2.1 use flash memory as cache 137
5.2.2 how to create esfc 142
5.2.3 use of esfc 144
5.3 Monitoring 145
5.3.1 storage monitoring 145
5.3.2 database monitoring 148
5.4 performance 149
5.5 conclusion 151
Chapter 2 Concurrent exadata operations 6th
6.1 parameter 153
6.2 parallel storage layer 154
6.3 automatic concurrency 155
6.3.1 operation and configuration 155
6.3.2 I/O Benchmark Test 158
6.3.3 automatic concurrency adjustment summary 162
6.4 parallel statement queue 162
6.4.1 old method 162
6.4.2 New Method 163
6.4.3 control parallel queue 167
6.4.4 parallel statement queue summary 175
6.5 memory parallel execution 176
6.6 conclusion 186
Chapter 4 Resource Management 7th
7.1 database resource manager 188
7.1.1 User Group 189
7.1.2 plan Directive 193
7.1.3 resource plan 194
7.1.4 explorer 195
7.1.5 wait event: resmgr: CPU quantum 196
7.1.6 example of a dbrm 197
7.1.7 test resource plan 202
7.2 instance isolation 210
7.2.1 configure and test instance isolation 211
7.2.2 Excessive allocation: 215
7.3 I/O Resource Manager 216
7.3.1 how Iorm works 218
7.3.2 method for managing I/O using exadata 221
7.3.3 put all together 227
7.3.4 Iorm monitoring and metrics 230
7.4 conclusion 244
Chapter 2 exadata configuration 8th
8.1 exadata network component 245
8.1.1 Management Network 246
8.1.2 Client Access Network 246
8.1.3 private network 247
8.2 configuration process 248
8.3 configure exadata 250
8.3.1 step 1st: configuration work 250
8.3.2 step 2nd: dBm configurator 259
8.3.3 step 3rd: Upload parameters and deployment files 260
8.3.4 step 4th: checkip (checkip. Sh) 263
8.3.5 step 5th: first boot firstboot 265
8.3.6 step 6th: Prepare the installation media 268
8.3.7 step 7th: Run onecommand 269
8.4 upgrade exadata 273
8.4.1 create a new RAC cluster 273
8.4.2 upgrade existing cluster 275
8.5 conclusion 278
Chapter 2 restoration of exadata 9th
9.1 exadata diagnostic tool 279
9.1.1 sun diagnostics: sundiag. Sh 280
9.1.2 health check 282
9.1.3. cellcli 283
9.2 exadata backup 287
9.2.1 Database Server backup 288
9.2.2 storage node backup 292
9.3 Database Backup 298
9.3.1 disk-based backup 298
9.3.2 tape-based backup 298
9.3.3 back up from the standby database 299
9.3.4 exadata Optimization for RMAN 300
9.4 restore exadata 301
9.4.1 Database Server recovery 301
9.4.2 restoration of storage nodes: 305
9.5 conclusion 325
Chapter 2 exadata wait event 10th
10.1 exadata-specific event 327
10.1.1 node event 328
10.1.2 execution plan for event triggering step 329
10.2 exadata wait event in user I/O category 331
10.2.1 cell smart table scan 332
10.2.2 cell SMART index scan 335
10.2.3 cell single block physical read 337
10.2.4 cell multiblock physical read 339
10.2.5 cell list of blocks physical read 340
10.2.6 cell smart file creation341
10.2.7 cell statistics gather 342
10.3 exadata wait event in system I/O category 343
10.3.1 cell smart Incremental Backup 343
10.3.2 cell smart restore from backup 344
10.4 exadata wait event in other and idle categories 346
10.4.1 cell smart flash unkeep 346
10.5 old event 347
10.5.1 direct path read 347
10.5.2 Enq: Ko-fast object checkpoint 348
10.5.3 reliable message 349
10.6 Resource Management event 350
10.6.1 resmgr: CPU quantum 350
10.6.2 resmgr: PQ queued 351
10.7 conclusion 352
Chapter 4 understanding the performance indicators of exadata 11th
11.1 exadata performance indicator measurement 353
11.2 review prerequisites for exadata smart scanning 354
11.2.1 exadata smart scan performance: 354
11.2.2 understand exadata smart scanning indicators and performance counters 358
11.3 exadata dynamic performance counter 359
11.3.1 when and how to use performance counter 359
11.3.2 meaning and description of the exadata performance counter 363
11.3.3 for the performance counters of exadata, refer to 366.
11.4 understand SQL statement performance 383
11.5 conclusion 386
Chapter 2 exadata performance monitoring 12th
12.1 system methodology 387
12.2 SQL statement Response Time Monitoring 388
12.2.1 monitor SQL statements using real-time SQL Monitoring Reports 389
12.2.2 use v $ SQL and V $ sqlstats to monitor SQL statement 400
12.3 monitoring storage node 403
12.3.1 access performance indicator 403 using cellcli on the storage Node
12.3.2 use the exadata storage server plug-in of Grid Control to access performance metric 404
12.3.3 performance indicators used 413
12.3.4 monitor the OS PERFORMANCE OF THE exadata storage node by 414
12.4 conclusion 427
Chapter 1 migration to exadata 13th
13.1 migration policy 430
13.2 logical migration 430
13.2.1 431 extraction and Loading
13.2.2 copy data through the database chain 437
13.2.3 migration based on synchronous replication: 454
13.2.4 Summary of logical migration 461
13.3 physical migration 461
13.4 backup and recovery 462
13.4.1 full backup and recovery 462
13.4.2 Incremental Backup 464
13.4.3 transfer tablespace (and cross-platform transfer tablespace xtts) 465
13.4.4 physical standby 468
13.4.5 ASM rebalancing 470
13.4.6 migration task 473
13.4.7 Summary of physical migration 474
13.5 conclusion 475
Chapter 1 storage design 14th
14.1 exadata disk architecture 477
14.1.1 failure group 478
14.1.2 grid disk 480
14.1.3 Storage Distribution 482
14.2 create a grid disk 486
14.2.1 create a grid disk 487
14.2.2 488 grid disk size
14.2.3 create a flash drive-based grid disk 491
14.3 Storage Policy 493
14.3.1 configuration option 493
14.3.2 isolated storage node access 494
14.4 node Security Policy 496
14.4.1 node security policy terms 496
14.4.2 best practices for node Security Policy 497
14.4.3 configure ASM range security policy 497
14.4.4 configure the database security policy 499
14.4.5 delete node Security Policy 501
14.5 conclusion 503
Chapter 2 computing node design 15th
15.1 configuration considerations 505
15.2 non-RAC environment configuration 507
15.3 RAC cluster 511
15.4 typical exadata configuration 514
15.5 exadata cluster 515
15.6 conclusion 516
Chapter 4 forgetting to know 16th
16.1 dual system note 517
16.2 type load 517
16.2.1 exadata smart flash cache (esfc) 518
16.2.2 scalability 519
16.2.3 write-intensive OLTP load 519
16.3 DW type load 519
16.3.1 enable smart scan 520
16.3.2 factors hindering smart scanning: 522
16.3.3 other precautions 533
16.4 hybrid load 535
16.4.1 Do You Want To index or not? 535
16.4.2 optimizer limitations 536
16.4.3 use resource manager 540
16.5 conclusion 540
Appendix A cellcli and dcli 541
Appendix B exadata online resource 553
Appendix C diagnostic script 555
This book is from: China Interactive publishing network
