Expert Oracle Exadata by Martin Bach, Kristofferson Arao, Andy Colvin, Frits

By Martin Bach, Kristofferson Arao, Andy Colvin, Frits Hoogland, Visit Amazon's Kerry Osborne Page, search results, Learn about Author Central, Kerry Osborne, , Randy Johnson, Tanel Poder

Expert Oracle Exadata, 2d Edition opens up the internals of Oracle's Exadata platform that you can absolutely enjoy the so much performant and scalable database equipment in a position to working Oracle Database. This variation is fully-updated to hide Exadata 5-2 and Oracle Database 12c. in case you are new to Exadata, you will soon study that it embodies a metamorphosis in the way you take into consideration and deal with relational databases. A key a part of that vary lies within the notion of offloading SQL processing to the garage layer. furthermore there's Oracle's engineering attempt in making a strong platform for either consolidation and transaction processing. The ensuing price proposition within the type of Exadata has actually been a game-changer.

Expert Oracle Exadata, second Edition presents a glance on the internals and the way the combo of and software program that contain Exadata really paintings. Authors contain Martin Bach, Andy Colvin, and Frits Hoogland, with contributions from Karl Arao, and equipped at the origin laid through Kerry Osborne, Randy Johnson, and Tanel Poder within the first version. They percentage their real-world adventure received via a very good many Exadata implementations, in all probability greater than the other staff of specialists this day. regularly their aim is towards aiding you develop your occupation via good fortune with Exadata on your personal setting. This publication is meant for readers who are looking to comprehend what makes the platform tick and for whom—"how" it does what it really is does is as very important as what it does. by way of being uncovered to the good points which are specific to Exadata, you are going to achieve an knowing of the mechanics that would let you totally enjoy the benefits that the platform offers.

This ebook adjustments the way you take into consideration dealing with SQL functionality and processing. It presents a roadmap to profitable Exadata implementation. And it eliminates the "black field" mystique. you are going to find out how Exadata truly works and be greater capable of deal with your Exadata engineered platforms in help of your small business.

This book:

  • Changes how you take into consideration dealing with SQL functionality and processing
  • Provides a roadmap to winning Exadata implementation
  • Removes the "black field" mystique, displaying how Exadata truly works

What you’ll learn

  • Configure Exadata from the floor up
  • Optimize for combined OLTP/DW workloads
  • Migrate huge facts units from present platforms
  • Connect Exadata to exterior platforms
  • Support consolidation recommendations utilizing the source supervisor
  • Configure high-availability beneficial properties of Exadata, together with actual software Clusters (RAC) and automated garage administration (ASM)
  • Apply tuning ideas using the original positive factors of Exadata

Who this e-book is for

Expert Oracle Exadata, 2d Edition is for database directors and builders who are looking to comprehend what makes Exadata exact on the way to reap the benefits of the entire platform has to supply. it's also for a person who must plan and execute migrations of platforms to the Exadata platform. ultimately, the booklet should be beneficial to those that aid and hold such platforms.

Table of Contents

  1. What Is Exadata?
  2. Offloading / shrewdpermanent experiment
  3. Hybrid Columnar Compression
  4. Storage Indexes
  5. Exadata clever Flash Cache
  6. Exadata Parallel Operations
  7. Resource administration
  8. Configuring Exadata
  9. Recovering Exadata
  10. Exadata Wait occasions
  11. Understanding Exadata functionality Metrics
  12. Monitoring Exadata functionality
  13. Migrating to Exadata
  14. Storage structure
  15. Compute Node Layout
  16. Unlearning a few issues We inspiration We Knew
  17. Patching
  18. Appendix A: CELLCL and DCLI
  19. Appendix B: on-line Exadata Resources
  20. Appendix C: Diagnostic Scripts
  21. Appendix D: Exachk

Show description

Read Online or Download Expert Oracle Exadata PDF

Similar oracle books

Oracle PL/SQL Programming 4Th Edition

За последние 10 лет книга Oracle PL/SQL Programming издательства O'Reilly's стала бестселлером среди книг по PL/SQL, процедурному языку базы данных Oracle. Снабженная примерами и полезными рекомендациями книнга является незаменимой как новичкам, так и гуру, как разработчикам на Oracle varieties, так и администраторам - используйте PL/SQL на полную мощь.

Oracle Streams 11g Data Replication

Grasp Oracle Streams 11g Replication let real-time info entry and information sharing throughout your disbursed framework utilizing the specialist details during this Oracle Press consultant. Oracle Streams 11g facts Replication explains the right way to organize and administer a unified company info sharing infrastructure.

Oracle Application Express 4 Recipes

Oracle software convey four Recipes offers an example-based method of studying program exhibit - the ground-breaking, speedy software improvement platform integrated with each Oracle Database license. The recipes layout is perfect for the quick-study who simply wishes a very good instance or to kick commence their pondering and get pointed within the correct path.

Additional resources for Expert Oracle Exadata

Sample text

Offloading has three design goals, although the primary goal far outweighs the others in importance: • Reduce the volume of data transferred from disk systems to the database servers • Reduce CPU usage on database servers • Reduce/eliminate disk access times at the storage layer Reducing the volume was the main focus and primary goal. The majority of the optimizations introduced by offloading contribute to this goal. Reducing CPU load is important as well, but it is not the primary benefit provided by Exadata and, therefore, takes a back seat to reducing the volume of data transferred.

Although it is not the perfect OLTP Machine, the Flash Cache feature provides a mechanism for ensuring low latency for OLTP-oriented workloads. The Smart Scan optimizations provide exceptional performance for high-throughput, DW-oriented workloads. Resource Management options built into the platform provide the ability for these somewhat conflicting requirements to be satisfied on the same platform. In fact, one of the biggest upsides to this ability is the possibility of totally eliminating a huge amount of work that is currently performed in many shops to move data from an OLTP system to a DW system so that long-running queries do not negatively affect the latency-sensitive workload.

Chapter 1 ■ What Is Exadata? three storage servers. Beyond that, any combination of compute and storage servers can be used within the rack. This removed discussions around Exadata configurations being “balanced” based on the workload. As was seen by many deployments before the X5, every workload is a little bit different and has different needs for compute and storage. Alternative Views of What Exadata Is We have already given you a rather bland description of how we view Exadata. However, like the well-known tale of the blind men describing an elephant, there are many conflicting perceptions about the nature of Exadata.

Download PDF sample

Rated 4.44 of 5 – based on 35 votes