Achieving Extreme Performance With Oracle Exadata

Maximize Oracle Exadata Capabilities Leverage all of the powerful features available in the Oracle Exadata Database Machine using the proven techniques inside this Oracle Press guide. Written by Oracle experts, Achieving Extreme Performance with Oracle Exadata shows you how to take full advantage of this complete, optimized package of software, servers, and storage. Best practices for enterprise deployments, high availability, administration, backup and recovery, data warehousing, online transaction processing, consolidation, and migration are included in this authoritative resource. Take advantage of the tightly integrated hardware and software in the Oracle Exadata Database Machine Work with Oracle Exadata software features, including Smart Scans, Oracle Exadata Hybrid Columnar Compression, storage indexes, Oracle Exadata Smart Flash Cache, and I/O Resource Manager Understand Oracle Exadata Database Machine balanced hardware architecture Architect, administer, and monitor Oracle Exadata Storage Servers Deploy data warehouses on the Oracle Exadata Database Machine Run online transaction processing (OLTP) workloads on the Oracle Exadata Database Machine Consolidate databases with and migrate databases to the Oracle Exadata Database Machine

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 What you’ll learn Install and configure Exadata Manage your Exadata hardware infrastructure Monitor and troubleshoot performance issues Manage smart scan and cell offload processing Take advantage of Hybrid Columnar Compression Deploy Smart Flash Cache and Smart Flash Logging Ensure the health of your Exadata environment Who this book is for Oracle Exadata Recipes is for Oracle Database administrators, Unix/Linux administrators, storage administrators, backup administrators, network administrators, and Oracle developers who want to quickly learn to develop effective and proven solutions without reading through a lengthy manual scrubbing for techniques. Readers in a hurry will appreciate the recipe format that sets up solutions to common tasks as the centerpiece of the book. Table of Contents Exadata Hardware Exadata Software How Oracle Works on Exadata Workload Qualification Sizing Exadata Preparing for Exadata Administration and Diagnostics Utilities Backup and Recovery Storage Administration Network Administration Patching and Upgrades Security Monitoring Exadata Storage Cells Host and Database Performance Monitoring Smart Scan and Cell Offload Hybrid Columnar Compression I/O Resource Management and Instance Caging Smart Flash Cache and Smart Flash Logging Storage Indexes Post-Installation Monitoring Tasks Post-Install Database Tasks

"Geoff Ingram has met the challenge of presenting the complex process of managing Oracle performance. This book can support every technical person looking to resolve Oracle8i and Oracle9i performance issues." -Aki Ratner, President, Precise Software Solutions Ensuring high-performance and continuous availability of Oracle software is a key focus of database managers. At least a dozen books address the subject of "performance tuning"-- that is, how to fine-tune the Oracle database for its greatest processing efficiency. Geoff Ingram argues that this approach simply isn't enough. He believes that performance needs to be addressed right from the design stage, and it needs to cover the entire system--not just the database. High-Performance Oracle is a hands-on book, loaded with tips and techniques for ensuring that the entire Oracle database system runs efficiently and doesn't break down. Written for Oracle developers and DBAs, and covering both Oracle8i and Oracle9i, the book goes beyond traditional performance-tuning books and covers the key techniques for ensuring 24/7 performance and availability of the complete Oracle system. The book provides practical solutions for: * Choosing physical layout for ease of administration and efficient use of space * Managing indexes, including detecting unused indexes and automating rebuilds * SQL and system tuning using the powerful new features in Oracle9i Release 2 * Improving SQL performance without modifying code * Running Oracle Real Application Clusters (RAC) for performance and availability * Protecting data using Recover Manager (RMAN), and physical and logical standby databases The companion Web site provides the complete source code for examples in the book, updates on techniques, and additional documentation for optimizing your Oracle system.

Written by Oracle insiders, this indispensable guide distills an enormous amount of information about the Oracle Database into one compact volume. Ideal for novice and experienced DBAs, developers, managers, and users, Oracle Essentials walks you through technologies and features in Oracle’s product line, including its architecture, data structures, networking, concurrency, and tuning. Complete with illustrations and helpful hints, this fifth edition provides a valuable one-stop overview of Oracle Database 12c, including an introduction to Oracle and cloud computing. Oracle Essentials provides the conceptual background you need to understand how Oracle truly works. Topics include: A complete overview of Oracle databases and data stores, and Fusion Middleware products and features Core concepts and structures in Oracle’s architecture, including pluggable databases Oracle objects and the various datatypes Oracle supports System and database management, including Oracle Enterprise Manager 12c Security options, basic auditing capabilities, and options for meeting compliance needs Performance characteristics of disk, memory, and CPU tuning Basic principles of multiuser concurrency Oracle’s online transaction processing (OLTP) Data warehouses, Big Data, and Oracle’s business intelligence tools Backup and recovery, and high availability and failover solutions

Private clouds allow for managing multiple databases under one roof, avoiding unnecessary resource management. Private cloud solutions can be applied in sectors such as healthcare, retail, and software. The Introduction to Private Cloud using Oracle Exadata and Oracle Database will explore the general architecture of private cloud databases with a focus on Oracle’s Exadata database machine. The book describes the private cloud using fundamental-level Exadata and database. Exadata has been Oracle’s pioneer product for almost a decade. In the last few years, Oracle has positioned Exadata for customers to consume as a cloud service. This book will provide a timely introduction to Exadata for current and potential Oracle customers and other IT professionals.

Netezza focuses on technology designed to query and analyze big data. The company's innovative data warehouse appliances are disrupting the market. Wishing to exploit data at lower costs of operation and ownership, many of our customers have moved their data warehouses from Oracle. Oracle has now brought Exadata to market; a machine which apparently does everything TwinFin does, and also processes online transactions. This examination of Exadata and TwinFin as data warehouse platforms is written from an unashamedly Netezza viewpoint, however to ensure credibility we have taken advice from Philip Howard, Research Director of Bloor Research and Curt Monash, President, Monash Research. To innovate requires us to think and do things differently, solving a problem using new approaches. Netezza focuses exclusively on customers needs and wants for data warehousing. TwinFin delivers excellent performance for our customers' warehouse queries. TwinFin offers customers simplicity; anyone with basic knowledge of SQL and Linux has the skills needed to perform the few administrative tasks required to maintain consistent service levels through dynamically changing workloads. TwinFin's performance with simplicity reduces their costs of owning and running their data warehouses. More important, our customers create new business value by deploying analytic applications which previously they considered beyond their reach. "Netezza was part of the inspiration for Exadata. Teradata was part of the inspiration for Exadata," acknowledged Larry Ellison on January 27, 2010. We'd like to thank them for forcing our hand and forcing us go into the hardware business. While delivered with Larry Ellison's customary pizzazz, there is a serious point to his comment: only the best catch Oracle's attention. Exadata represents a strategic direction for Oracle; adapting their OLTP database management system, partnering it with a massively parallel storage system from Sun. Oracle launched Exadata V2 with the promise of extreme performance for processing both online transactions and analytic queries. That Oracle excels at OLTP is a given. But data warehousing and analytics make very different demands of their software and hardware than OLTP. Exadata's data warehousing credentials demand scrutiny, particularly with respect to simplicity and value. This eReport opens by reviewing differences between processing online transactions and processing queries and analyses in a data warehouse. It then discusses Exadata and TwinFin from perspectives of their query performance, simplicity of operation and value. All we ask of readers is that they do as our customers and partners have done: put aside notions of how a database management system should work, be open to new ways of thinking and be prepared to do less, not more, to achieve a better result. One caveat: Netezza has no direct access to an Exadata machine. We are fortunate in the detailed feedback we receive from many organizations that have evaluated both technologies and selected TwinFin. Given Oracle's size and their focus on Exadata, publicly available information on Exadata is surprisingly scarce. The use cases quoted by Oracle provide little input to the discussion, which in itself is of concern to several industry followers, e.g. Information Week. The information shared in this paper is made available in the spirit of openness. Any inaccuracies result from our mistakes, not an intent to mislead.

Enterprise Information Architecture for a New Age: Big Data and The Internet of Things, provides guidance in designing an information architecture to accommodate increasingly large amounts of data, massively large amounts of data, not only from traditional sources, but also from novel sources such everyday objects that are fast becoming wired into global Internet. No business can afford to be caught out by missing the value to be mined from the increasingly large amounts of available data generated by everyday devices. The text provides background as to how analytical solutions and enterprise architecture methodologies and concepts have evolved (including the roles of data warehouses, business intelligence tools, predictive analytics, data discovery, Big Data, and the impact of the Internet of Things). Then you’re taken through a series of steps by which to define a future state architecture and create a plan for how to reach that future state. Enterprise Information Architecture for a New Age: Big Data and The Internet of Things helps you gain an understanding of the following: Implications of Big Data from a variety of new data sources (including data from sensors that are part of the Internet of Things) upon an information architecture How establishing a vision for data usage by defining a roadmap that aligns IT with line-of-business needs is a key early step The importance and details of taking a step-by-step approach when dealing with shifting business challenges and changing technology capabilities How to mitigate risk when evaluating existing infrastructure and designing and deploying new infrastructure Enterprise Information Architecture for a New Age: Big Data and The Internet of Things combines practical advice with technical considerations. Author Robert Stackowiak and his team are recognized worldwide for their expertise in large data solutions, including analytics. Don’t miss your chance to read this book and gain the benefit of their advice as you look forward in thinking through your own choices and designing your own architecture to accommodate the burgeoning explosion in data that can be analyzed and converted into valuable information to drive your business forward toward success.

The Practical, Authoritative, 360-Degree Technical Guide to Oracle Exadata: From Setup to Administration, Optimization, Tuning, and Troubleshooting The blazingly fast Oracle Exadata Database Machine is being embraced by thousands of large-scale users worldwide: by governments, the military, enterprise organizations, cloud service providers, and anyone who needs extreme performance. Now, Oracle Exadata Expert’s Handbook provides authoritative guidance to running Oracle Exadata with maximum reliability, effectiveness, performance, and efficiency. Six renowned Oracle technology experts have brought together core technical information, experience, best practices, and insider tips in a concise reference. Covering both 11g and 12c versions of Oracle Exadata software, they deliver hands-on coverage of best practices, setup, migration, monitoring, administration, performance tuning, and troubleshooting. Whether you’re an Oracle Exadata DBA, DMA, architect, or manager, you need these insights. Get a 360-degree overview of the Oracle Exadata Database Machine Efficiently deploy RAC within the Oracle Exadata ecosystem Fully leverage Storage Cell’s extraordinary performance, via Offloading, Smart Scans, and Hybrid Columnar Compression Manage Exadata with OEM 12c: perform setup, configuration, asset/target discovery, and day-to-day administration Tune Oracle Exadata for even better performance Perform Exadata Backup/Recovery/DR with RMAN and Data Guard Migrate to Oracle Exadata from other platforms Use Oracle Exadata with the ZFS Storage Appliance Consolidate within the Exadata Database Cloud