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, second Edition opens up the internals of Oracle's Exadata platform for you to totally enjoy the so much performant and scalable database equipment in a position to working Oracle Database. This version 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 adjust lies within the inspiration of offloading SQL processing to the garage layer. furthermore there's Oracle's engineering attempt in making a robust platform for either consolidation and transaction processing. The ensuing price proposition within the kind of Exadata has really been a game-changer.
Expert Oracle Exadata, second Edition offers a glance on the internals and the way the combo of and software program that contain Exadata truly paintings. Authors contain Martin Bach, Andy Colvin, and Frits Hoogland, with contributions from Karl Arao, and equipped at the beginning laid via Kerry Osborne, Randy Johnson, and Tanel Poder within the first variation. They percentage their real-world event won via a very good many Exadata implementations, most likely greater than the other staff of specialists this day. constantly their aim is towards aiding you strengthen your profession via good fortune with Exadata on your personal setting. This e-book 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 vital as what it does. through being uncovered to the positive factors which are distinctive to Exadata, you'll achieve an realizing of the mechanics that would let you absolutely enjoy the merits that the platform offers.
This ebook adjustments the way you take into consideration dealing with SQL functionality and processing. It offers a roadmap to winning Exadata implementation. And it gets rid of the "black field" mystique. you are going to learn the way Exadata really works and be higher capable of deal with your Exadata engineered platforms in help of what you are promoting.
- Changes how you take into consideration dealing with SQL functionality and processing
- Provides a roadmap to profitable Exadata implementation
- Removes the "black field" mystique, exhibiting how Exadata really works
What youll learn
- Configure Exadata from the floor up
- Optimize for combined OLTP/DW workloads
- Migrate huge info units from latest platforms
- Connect Exadata to exterior structures
- Support consolidation concepts utilizing the source supervisor
- Configure high-availability gains of Exadata, together with actual program Clusters (RAC) and automated garage administration (ASM)
- Apply tuning suggestions using the original gains of Exadata
Who this ebook is for
Expert Oracle Exadata, 2d Edition is for database directors and builders who are looking to comprehend what makes Exadata special on the way to reap the benefits of the entire platform has to provide. it's also for a person who must plan and execute migrations of platforms to the Exadata platform. ultimately, the ebook could be valuable to people who help and retain such platforms.
Table of Contents
- What Is Exadata?
- Offloading / clever test
- Hybrid Columnar Compression
- Storage Indexes
- Exadata shrewdpermanent Flash Cache
- Exadata Parallel Operations
- Resource administration
- Configuring Exadata
- Recovering Exadata
- Exadata Wait occasions
- Understanding Exadata functionality Metrics
- Monitoring Exadata functionality
- Migrating to Exadata
- Storage format
- Compute Node Layout
- Unlearning a few issues We concept We Knew
- Appendix A: CELLCL and DCLI
- Appendix B: on-line Exadata Resources
- Appendix C: Diagnostic Scripts
- Appendix D: Exachk
Read or Download Expert Oracle Exadata PDF
Similar oracle books
# quick, effortless automation for each Oracle 9i and 10g DBA! # easy accessibility to real-world examples# install, database construction, administration, tracking, tuning, and backup/recovery# Oracle common Installer (OUI), Oracle web Configuration Assistant (NetCA), and Oracle Database Configuration Assistant (DBCA)
Organize to go the Oracle9i qualified expert DBA New positive factors for directors examination utilizing this Oracle Press research consultant. you will get whole insurance of all examination issues by way of perform questions and bankruptcy summaries. The CD-ROM comprises hundreds and hundreds of perform examination questions in an adaptive layout.
-Your key to reaching certification in Oracle's made over DBA song! -Contains examination necessities, real-world situation sidebars, scenario-based questions, and fill-in-the-blank questions. -The CD contains flashcards, chapter-by-chapter tests, randomly gen
This ebook is a entire and easy-to-understand advisor for utilizing the Oracle facts supplier (ODP) model 11g at the . web Framework. It additionally outlines the middle GoF (Gang of 4) layout styles and coding strategies hired to construct and installation high-impact mission-critical functions utilizing complicated Oracle database positive aspects in the course of the ODP.
- Oracle Collaboration Suite Handbook
- WS-BPEL 2.0 for SOA Composite Applications with Oracle SOA Suite 11g
- TOAD Handbook (2nd Edition)
- Troubleshooting Oracle Performance, 2nd Edition
Additional info for Expert Oracle Exadata
The high-capacity version contains 4 F160 PCIe cards for the Flash Cache; the extreme flash version contains 8 F160 PCIe cards, which are used both as Flash Cache and final disk storage. The storage servers come pre-installed with Oracle Linux 6. InfiniBand One of the more important hardware components of Exadata is the InfiniBand network. It is used for transferring data between the database tier and the storage tier. It is also used for interconnect traffic between the database servers, if they are configured in a RAC cluster.
The software is aware of whether it is accessing Exadata storage, and this “awareness” allows it to make use of the Exadata-specific optimizations when accessing Exadata storage. 11 Chapter 1 ■ What Is Exadata? Oracle Automatic Storage Management (ASM) is a key component of the software stack on the database servers. It provides file system and volume management capability for Exadata storage. It is required because the storage devices are not visible to the database servers. There is no direct mechanism for processes on the database servers to open or read a file on Exadata storage cells.
This means it is possible to end up with a rack containing X2 and X3 components. Many companies purchased Exadata V2 or X2 systems and are now in the process of upgrading those systems. Several questions naturally arise with regard to this process. One question is whether or not it is acceptable to mix the newer X5-2 servers with the older V2 or X2 components. The answer is yes, it’s OK to mix them. In the Enkitec lab environment, for example, we have a mixture of V2 (our original quarter rack) and X2-2 servers (the upgrade to a half rack).