SEARCH
Disclaimer: Authors have full rights over their works. Reproduction of any part of the content is prohibited without prior authorization.
BOOK RUNNING APPLICATIONS ON ORACLE EXADATA
SUMMARY
-
Items Found: 188
- 1 Exadata Architecture 1
- 2 Exadata Hardware Features 25
- 3 Exadata Software Features 47
- 4 Leveraging Exadata Features for Applications 95
- 5 Sizing Exadata for Applications 119
- 6 Migrating Applications to Exadata 149
- 7 Application Consolidation in Exadata 197
- 8 Monitoring Exadata 237
- 9 Managing Exadata 269
- 10 Exadata Backup and Recovery 307
- Index 333
- This page intentionally left blank
- 1 Exadata Architecture 1
- A Brief History 2
- Oracle Database Machine V1 3
- Oracle Database Machine V2 3
- Oracle Exadata Database Machine X2 4
- Oracle Exadata Database Machine X3 4
- Oracle Exadata Database Machine X4 5
- Exadata Architecture 5
- Database Servers 5
- Exadata Storage Servers or Storage Cells 11
- InfiniBand 14
- Exadata Configurations 15
- Xn-2 Full Rack 15
- Xn-2 Half Rack 16
- Xn-2 Quarter Rack 16
- Xn-2 Eighth Rack 16
- Xn-8 Full Rack 17
- Exadata Storage Expansion Rack 19
- Advantages of Exadata 20
- Platinum Services for Exadata 22
- Summary 24
- 2 Exadata Hardware Features 25
- Database Servers 26
- X4-2 Servers 26
- X4-8 Servers 30
- Storage Servers 33
- Exadata Storage Server X4-2 33
- vii
- InfiniBand 36
- Ethernet Network 40
- Power Distribution Units 40
- For X4-2 Machines 40
- For X4-8 Machines 41
- Environment Information 42
- X4-2 High-Capacity Disks 43
- Exadata X4-2 High-Performance Disk 44
- Exadata X4-8 High-Performance
- and High-Capacity Drive 45
- Summary 46
- 3 Exadata Software Features 47
- Hybrid Columnar Compression (HCC) 48
- Warehouse Compression 53
- Online Archival Compression 53
- Implementing HCC 54
- Export/Import of HCC Tables 59
- Restoring an Exadata HCC Table 59
- Smart Scans 60
- Smart Scan SQL Operations 64
- Considerations that Affect Smart Scan 69
- Querying for Smart Scan 70
- Smart Scan Metrics 75
- Queries to Capture Smart Scan 76
- Exadata Smart Flash Cache 79
- Exadata Smart Flash Cache and Read Operations 80
- Exadata Smart Flash Cache and Write Operations 82
- CELL_FLASH_CACHE Setting and Cache Hint 83
- Pinning Objects in Flash Cache 84
- Exadata Smart Flash Cache and Flash Grid Disks 85
- Monitoring Flash Usage 91
- More Exadata Smart Flash Cache Features 93
- Resource Manager 93
- Summary 94
- 4 Leveraging Exadata Features for Applications 95
- Characteristics of an OLTP System 96
- Exadata Features 98
- Write-Back Flash Cache 98
- Smart Flash Logging 100
- Flash Cache Compression 105
- Database Links Over InfiniBand 108
- Exalogic-Exadata Connectivity Using InfiniBand 113
- Configuring HugePages 114
- Summary 118
- 5 Sizing Exadata for Applications 119
- Comparative Sizing 121
- Server Models 122
- Memory 125
- Comparative Sizing Attributes to Consider 134
- Predictive Sizing 135
- Users 135
- Functionalities 136
- Application Services 136
- Batch Jobs 137
- Reporting 137
- Geography 138
- Application Growth 138
- Special Throughput Needs 138
- Predictive Sizing Attributes to Consider 139
- Predictive Sizing Questionnaire Examples 140
- Disaster Recovery Environment Sizing 142
- Nonproduction Environment Sizing 143
- Production Support/QA Environment 143
- Development, Unit Test Environment 144
- Comparative Sizing Case Study 144
- Summary 146
- 6 Migrating Applications to Exadata 149
- Planning and Preparing for Migration 151
- Migration Paths 153
- Migration Using RMAN 153
- Migration Using Data Pump Export and Import 159
- Migration Using Transportable Database (TDB) 163
- Migration Using TTS or XTTS 168
- Migration Using Oracle Data Guard 182
- Migration Using GoldenGate 187
- Summary 192
- Addendum 6.1: get_bfile.sql 193
- Addendum 6.2: get_bfile_dir.sql 194
- 7 Application Consolidation in Exadata 197
- Advantages of Server Consolidation 199
- How to Consolidate in Exadata 200
- Using Consolidation Planner 200
- x Running Applications on Oracle Exadata: Tuning Tips & Techniques
- Managing Resources in Exadata
- After Consolidation 207
- Instance Caging 207
- Database Resource Manager (DBRM) 210
- I/O Resource Manager (IORM) 223
- Other Considerations/Recommendations
- for Consolidation 232
- Summary 236
- 8 Monitoring Exadata 237
- Monitoring Using Enterprise Manager 238
- Monitoring Compute Nodes 240
- Monitoring ILOM 247
- Monitoring Storage Cells 248
- Monitoring InfiniBand 252
- Monitoring the Cisco Ethernet Switch,
- KVM, and PDUs 253
- Monitoring the Databases 254
- Monitoring SQL 256
- Monitoring from the Servers Directly 259
- OS System Log 259
- CPU Utilization 259
- Memory Utilization 260
- ILOM Events 260
- Storage Cell Metric 261
- Exachk 263
- Summary 268
- 9 Managing Exadata 269
- Starting and Stopping Exadata Machine 270
- Shut Down the Machine 270
- Start Up the Machine 271
- Operational Commands 272
- Commands Related to Power Off/Reboot 272
- Commands Related to InfiniBand 273
- Tools and Commands for Managing the
- Grid Infrastructure, ASM, and Database 276
- Administering Storage Cells 285
- CellCLI 286
- Managing Disks 290
- Managing Flash 292
- Monitoring Using CellCLI 294
- Distributed Command Line Interface (DCLI) 296
- Summary 298
- Addendum 9.1: Flash Cache Metrics and Descriptions 299
- Addendum 9.2: Exadata Smart Flash Log Metrics and Descriptions 303
- Addendum 9.3: Sample Commands Related to CellCLI 304
- Sample Commands Related to ALTER 304
- Sample Commands Related to CREATE 304
- Sample Commands Related to DROP 305
- Sample Commands Related to LIST 305
- 10 Exadata Backup and Recovery 307
- Database Backup 308
- Fast Recovery Area (FRA) 309
- Physical Storage Options for Backups 310
- Recovery Manager (RMAN) 312
- Storage Cells Backup 317
- Compute Nodes Backup 320
- Snapshot-Based Backup 321
- Recovering Compute Nodes with Non-customized Partitions 323
- Recovering Oracle Linux Database Server
- with Customized Partitions 325
- InfiniBand Switch Backup 329
- Restore an InfiniBand Switch 331
- Summary 332
- Inde
- x 333
