LEADER 06011nam 2200601Ia 450 001 9910735383303321 005 20200520144314.0 010 $a9781430249153 010 $a1430249153 024 7 $a10.1007/978-1-4302-4915-3 035 $a(OCoLC)831417101 035 $a(MiFhGG)GVRL6VNQ 035 $a(CaSebORM)9781430249146 035 $a(OCoLC)844972176 035 $a(OCoLC)ocn844972176 035 $a(CKB)3460000000120362 035 $a(MiAaPQ)EBC1204526 035 $a(EXLCZ)993460000000120362 100 $a20130325d2013 uy 0 101 0 $aeng 135 $aurun|---uuuua 181 $ctxt 182 $cc 183 $acr 200 10$aOracle exadata recipes $ea problem-solution approach /$fJohn Clarke 205 $a1st ed. 2013. 210 $aNew York $cApress$d2013 215 $a1 online resource (xl, 645 pages) $cillustrations (some color) 225 1 $aThe Expert's voice in Oracle 300 $aIncludes index. 311 08$a9781430249146 311 08$a1430249145 327 $a""Title Page""; ""Copyright Page""; ""Contents at a Glance""; ""Table of Contents ""; ""About the Author""; ""About the Technical Reviewer""; ""Acknowledgments""; ""Introduction""; ""PART 1 Exadata Architecture""; ""CHAPTER 1 Exadata Hardware""; ""1-1. Identifying Exadata Database Machine Components""; ""1-2. Displaying Storage Server Architecture Details""; ""1-3. Displaying Compute Server Architecture Details""; ""1-4. Listing Disk Storage Details on the Exadata Storage Servers""; ""1-5. Listing Disk Storage Details on the Compute Servers"" 327 $a""1-6. Listing Flash Storage on the Exadata Storage Servers""""1-7. Gathering Configuration Information for the InfiniBandSwitches""; ""CHAPTER 2 Exadata Software""; ""2-1. Understanding the Role of Exadata Storage Server Software""; ""2-2. Validating Oracle 11gR2 Databases on Exadata""; ""2-3. Validating Oracle 11gR2 Grid Infrastructure on Exadata""; ""2-4. Locating the Oracle Cluster Registry and Voting Disks on Exadata""; ""2-5. Validating Oracle 11gR2 Real Application Clusters Installation and Database Storage on Exadata"" 327 $a""2-6. Validating Oracle 11gR2 Real Application Cluster Networking on Exadata""""CHAPTER 3 How Oracle Works on Exadata""; ""3-1. Mapping Physical Disks, LUNs, and Cell Disks on the Storage Servers""; ""3-2. Mapping ASM Disks, Grid Disks, and Cell Disks""; ""3-3. Mapping Flash Disks to Smart Flash Storage""; ""3-4. Identifying Cell Server Software Processes""; ""3-5. Tracing Oracle I/O Requests on Exadata Compute Nodes""; ""3-6. Validating That Your Oracle RAC Interconnect Is Using InfiniBand""; ""3-7. Tracing cellsrv on the Storage Servers""; ""PART 2 Preparing for Exadata"" 327 $a""CHAPTER 4 Workload Qualification""""4-1. Quantifying I/O Characteristics of Your Current Database""; ""4-2. Conducting a Smart Scan Fit Analysis Using AWR""; ""4-3. Conducting a Smart Scan Fit Analysis Using Exadata Simulation""; ""4-4. Performing a Hybrid Columnar Compression Fit Assessment""; ""CHAPTER 5 Sizing Exadata""; ""5-1. Determining CPU Requirements""; ""5-2. Determining IOPs Requirements""; ""5-3. Determining I/O Bandwidth Requirements""; ""5-4. Determining ASM Redundancy Requirements""; ""5-5. Forecasting Storage Capacity""; ""5-6. Planning for Database Growth"" 327 $a""5-7. Planning for Disaster Recovery""""5-8. Planning for Backups""; ""5-9. Determining Your Fast Recovery Area and RECO Disk Group Size Requirements""; ""CHAPTER 6 Preparing for Exadata""; ""6-1. Planning and Understanding Exadata Networking""; ""6-2. Configuring DNS""; ""6-3. Running checkip.sh""; ""6-4. Customizing Your InfiniBand Network Configuration""; ""6-5. Determining Your DATA and RECO Storage Requirements""; ""6-6. Planning for ASM Disk Group Redundancy""; ""6-7. Planning Database and ASM Extent Sizes""; ""6-8. Completing the Pre-Delivery Survey"" 327 $a""6-9. Completing the Configuration Worksheet"" 330 $aOracle Exadata Recipes takes an example-based, problem/solution approach in showing how to size, install, configure, manage, monitor, optimize, and migrate Oracle database workloads on and to the Oracle Exadata Database Machine. Whether you?re an Oracle Database administrator, Unix/Linux administrator, storage administrator, network administrator, or Oracle developer, Oracle Exadata Recipes provides effective and proven solutions to accomplish a wide variety of tasks on the Exadata Database Machine. You can feel confident using the reliable solutions that are demonstrated in this book in your enterprise Exadata environment. Managing Oracle Exadata is unlike managing a traditional Oracle database. Oracle?s Exadata Database Machine is a pre-configured engineered system comprised of hardware and software, built to deliver extreme performance for Oracle Database workloads. Exadata delivers extreme performance by offering an optimally balanced hardware infrastructure with fast components at each layer of the engineered technology stack, as well as a unique set of Oracle software features designed to leverage the high-performing hardware infrastructure by reducing I/O demands. Let Oracle Exadata Recipes help you translate your existing Oracle Database knowledge into the exciting new growth area that is Oracle Exadata. Helps extend your Oracle Database skillset to the fast-growing, Exadata platform Presents information on managing Exadata in a helpful, example-based format Clearly explains unique Exadata software and hardware features. 410 0$aExpert's voice in Oracle. 606 $aSQL/ORACLE (Computer program language) 606 $aDatabase management 615 0$aSQL/ORACLE (Computer program language) 615 0$aDatabase management. 676 $a005.7565 700 $aClarke$b John$043854 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910735383303321 996 $aOracle Exadata Recipes$93413740 997 $aUNINA