06011nam 2200601Ia 450 991073538330332120200520144314.09781430249153143024915310.1007/978-1-4302-4915-3(OCoLC)831417101(MiFhGG)GVRL6VNQ(CaSebORM)9781430249146(OCoLC)844972176(OCoLC)ocn844972176(CKB)3460000000120362(MiAaPQ)EBC1204526(EXLCZ)99346000000012036220130325d2013 uy 0engurun|---uuuuatxtccrOracle exadata recipes a problem-solution approach /John Clarke1st ed. 2013.New York Apress20131 online resource (xl, 645 pages) illustrations (some color)The Expert's voice in OracleIncludes index.9781430249146 1430249145 ""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""""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""""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""""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""""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""""6-9. Completing the Configuration Worksheet""Oracle 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.Expert's voice in Oracle.SQL/ORACLE (Computer program language)Database managementSQL/ORACLE (Computer program language)Database management.005.7565Clarke John43854MiAaPQMiAaPQMiAaPQBOOK9910735383303321Oracle Exadata Recipes3413740UNINA