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