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
An Expert Guide to Building Oracle Database Cloud Infrastructures This is the first complete, practical guide to architecting, designing, and building Database Clouds with Oracle 12c. Written by a veteran author team of Oracle gurus and ACE Directors, Building Database Clouds in Oracle 12c combines a real-world, hands-on operations guide with an expert handbook on Oracle Database-As-A-Service (DBaaS) and Oracle Real Application Clusters (RAC). Writing for Oracle DBAs, DMAs, cloud administrators, and other Oracle professionals, the authors present authoritative technical information for database cloud build-out, management, monitoring, and day-to-day administration. The authors first explain the key concepts underlying DBaaS, describe cloud computing implementations related to it, and outline the business and technology benefits. Next, they show how the Oracle DBA’s approach changes in cloud environments. Then, building on this foundation, they offer insider advice on all key facets of database cloud deployment and operation with Oracle Enterprise Manager 12c and Oracle RAC 12c. This guide helps you Make the business case for cloud computing with DBaaS Organize DBA responsibilities in cloud environments Plan, design, and deploy Database Clouds with Oracle’s latest components Consolidate schema and databases with Oracle Enterprise Manager 12c Use best practices for management, administration metering, and chargeback Clone databases quickly and reliably Set up grid infrastructure on Oracle VM for x86 or Oracle VM VirtualBox
An Expert Guide for Solving Complex Oracle Database Problems Oracle Database Problem Solving and Troubleshooting Handbook delivers comprehensive, practical, and up-to-date advice for running the Oracle Database reliably and efficiently in complex production environments. Seven leading Oracle experts have brought together an unmatched collection of proven solutions, hands-on examples, and step-by-step tips for Oracle Database 12c, 11g, and other recent versions of Oracle Database. Every solution is crafted to help experienced Oracle DBAs and DMAs understand and fix serious problems as rapidly as possible. The authors cover LOB segments, UNDO tablespaces, high GC buffer wait events, poor query response times, latch contention, indexing, XA distributed transactions, RMAN backup/recovery, and much more. They also offer in-depth coverage of a wide range of topics, including DDL optimization, VLDB tuning, database forensics, adaptive cursor sharing, data pumps, data migration, SSDs, indexes, and how to go about fixing Oracle RAC problems. Learn how to Choose the quickest path to solve high-impact problems Use modern best practices to make your day more efficient and predictable Construct your “Call 9-1-1 plan” for future database emergencies Proactively perform maintenance to improve your environment’s stability Save time with industry-standard tools and scripts Register your product at informit.com/register for convenient access to downloads, updates, and corrections as they become available.
Throughout history, advances in technology have come in spurts. A single great idea can often spur rapid change as the idea takes hold and is propagated, often in totally unexpected directions. Exadata embodies such a change in how we think about and manage relational databases. The key change lies in the concept of offloading SQL processing to the storage layer. That concept is a huge win, and its implementation in the form of Exadata is truly a game changer. Expert Oracle Exadata will give you a look under the covers at how the combination of hardware and software that comprise Exadata actually work. Authors Kerry Osborne, Randy Johnson, and Tanel Põder share their real-world experience, gained through multiple Exadata implementations with the goal of opening up the internals of the Exadata platform. This book is intended for readers who want to understand what makes the platform tick and for whom—"how" it does what it is does is as important as what it does. By being exposed to the features that are unique to Exadata, you will gain an understanding of the mechanics that will allow you to fully benefit from the advantages that the platform provides. Changes the way you think about managing SQL performance and processing Provides a roadmap to laying out the Exadata platform to best support your existing systems Dives deeply into the internals, removing the "black box" mystique and showing how Exadata actually works
Oracle Exadata Survival Guide is a hands-on guide for busy Oracle database administrators who are migrating their skill sets to Oracle's Exadata database appliance. The book covers the concepts behind Exadata, and the available configurations for features such as smart scans, storage indexes, Smart Flash Cache, hybrid columnar compression, and more. You'll learn about performance metrics and execution plans, and how to optimize SQL running in Oracle's powerful, new environment. The authors also cover migration from other servers. Oracle Exadata is fast becoming the standard for large installations such as those running data warehouse, business intelligence, and large-scale OLTP systems. Exadata is like no other platform, and is new ground even for experienced Oracle database administrators. The Oracle Exadata Survival Guide helps you navigate the ins and outs of this new platform, de-mystifying this amazing appliance and its exceptional performance. The book takes a highly practical approach, not diving too deeply into the details, but giving you just the right depth of information to quickly transfer your skills to Oracle's important new platform. Helps transfer your skills to the platform of the future Covers the important ground without going too deep Takes a practical and hands-on approach to everyday tasks
Master Oracle Real Application Clusters Maintain a dynamic enterprise computing infrastructure with expert instruction from an Oracle ACE. Oracle Database 11g Oracle Real Application Clusters Handbook, Second Edition has been fully revised and updated to cover the latest tools and features. Find out how to prepare your hardware, deploy Oracle Real Application Clusters, optimize data integrity, and integrate seamless failover protection. Troubleshooting, performance tuning, and application development are also discussed in this comprehensive Oracle Press guide. Install and configure Oracle Real Application Clusters Configure and manage diskgroups using Oracle Automatic Storage Management Work with services, voting disks, and Oracle Clusterware Repository Look under the hood of the Cache Fusion and Global Resource Directory operations in Oracle Real Applications Clusters Explore the internal workings of backup and recovery in Oracle Real Application Clusters Employ workload balancing and the Transparent Application Failover feature of an Oracle database Get complete coverage of Stretch Clusters, also known as Metro Clusters Troubleshoot Oracle Clusterware using the most advanced diagnostics available Develop custom Oracle Real Application Clusters applications
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
Where do ideas that reach policy makers and planners as proposals for Oracle Exadata strengthening and reform actually originate? What are the top 3 things at the forefront of our Oracle Exadata agendas for the next 3 years? How much are sponsors, customers, partners, stakeholders involved in Oracle Exadata? In other words, what are the risks, if Oracle Exadata does not deliver successfully? How do we go about Comparing Oracle Exadata approaches/solutions? What may be the consequences for the performance of an organization if all stakeholders are not consulted regarding Oracle Exadata? Defining, designing, creating, and implementing a process to solve a business challenge or meet a business objective is the most valuable role... In EVERY company, organization and department. Unless you are talking a one-time, single-use project within a business, there should be a process. Whether that process is managed and implemented by humans, AI, or a combination of the two, it needs to be designed by someone with a complex enough perspective to ask the right questions. Someone capable of asking the right questions and step back and say, 'What are we really trying to accomplish here? And is there a different way to look at it?' For more than twenty years, The Art of Service's Self-Assessments empower people who can do just that - whether their title is marketer, entrepreneur, manager, salesperson, consultant, business process manager, executive assistant, IT Manager, CxO etc... - they are the people who rule the future. They are people who watch the process as it happens, and ask the right questions to make the process work better. This book is for managers, advisors, consultants, specialists, professionals and anyone interested in Oracle Exadata assessment. Featuring 608 new and updated case-based questions, organized into seven core areas of process design, this Self-Assessment will help you identify areas in which Oracle Exadata improvements can be made. In using the questions you will be better able to: - diagnose Oracle Exadata projects, initiatives, organizations, businesses and processes using accepted diagnostic standards and practices - implement evidence-based best practice strategies aligned with overall goals - integrate recent advances in Oracle Exadata and process design strategies into practice according to best practice guidelines Using a Self-Assessment tool known as the Oracle Exadata Scorecard, you will develop a clear picture of which Oracle Exadata areas need attention. Included with your purchase of the book is the Oracle Exadata Self-Assessment downloadable resource, containing all 608 questions and Self-Assessment areas of this book. This helps with ease of (re-)use and enables you to import the questions in your preferred Management or Survey Tool. Access instructions can be found in the book. You are free to use the Self-Assessment contents in your presentations and materials for customers without asking us - we are here to help. The Art of Service has helped hundreds of clients to improve execution and meet the needs of customers better by applying business process redesign. Typically, our work generates cost savings of 20 percent to 30 percent of the addressable cost base, but its real advantages are reduced cycle times and increased quality and customer satisfaction. How Can we help you? To discuss how our team can help your business achieve true results, please visit http://store.theartofservice.com/contact-us/
Quickly Get Up and Running on Oracle Database Exadata Cloud Service Quickly install, configure, and start using Oracle Database Exadata Cloud Service with the hands-on information contained in this comprehensive Oracle Press guide. Designed for easy learning, the book features real-world examples, detailed illustrations, and step-by-step instructions. Oracle Database Exadata Cloud Service: A Beginner’s Guide walks you through the basics and shows you how to provision, create, and deploy databases. Basic system administration tasks, including data backup and recovery, software patching, and system updating, are clearly explained. Advanced monitoring and data compression techniques are also covered. Inside, you’ll discover how to: •Set up and configure Oracle Database Exadata Cloud Service•Navigate the user interface•Work with tooling and CLIs•Deploy smart scans and storage indexes•Employ the latest compression techniques•Handle Oracle Exadata resource management•Administer Oracle Exadata Smart Flash Cache•Manage and monitor your Oracle Exadata Cloud Service•Migrate to Oracle Exadata Cloud Service TAG: For a complete list of Oracle Press titles, visit www.OraclePressBooks.com.