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
Vierzig Sekunden können den Lauf der Welt verändern Peri Reed ist jung, sexy und tough. Doch das ist nicht das Beste an ihr! Was sie einzigartig macht, ist ihre Gabe: Peri kann vierzig Sekunden in der Zeit zurückspringen und die Vergangenheit verändern. Ein unschätzbarer Vorteil, wenn man für eine staatliche Geheimorganisation arbeitet, die Jagd auf die gefährlichsten Kriminellen der USA macht. Bis Peri eines Tages der Korruption verdächtigt wird und fliehen muss. Plötzlich zur Staatsfeindin Nummer eins geworden, ist sie fest entschlossen, ihre Unschuld zu beweisen und die Drahtzieher dieser Verschwörung ausfindig zu machen. Doch Peri kann niemandem mehr vertrauen – nicht einmal dem Mann, den sie liebt ...
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
Rick Greenwald,Robert Stackowiak,Maqsood Alam,Mans Bhuller
Author: Rick Greenwald,Robert Stackowiak,Maqsood Alam,Mans Bhuller
Publisher: McGraw Hill Professional
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
Martin Bach,Kristofferson Arao,Andy Colvin,Frits Hoogland,Kerry Osborne,Randy Johnson,Tanel Poder
Author: Martin Bach,Kristofferson Arao,Andy Colvin,Frits Hoogland,Kerry Osborne,Randy Johnson,Tanel Poder
Expert Oracle Exadata, 2nd Edition opens up the internals of Oracle's Exadata platform so that you can fully benefit from the most performant and scalable database hardware appliance capable of running Oracle Database. This edition is fully-updated to cover Exadata 5-2 and Oracle Database 12c. If you're new to Exadata, you'll soon learn that it embodies a change in how you think about and manage relational databases. A key part of that change lies in the concept of offloading SQL processing to the storage layer. In addition there is Oracle's engineering effort in creating a powerful platform for both consolidation and transaction processing. The resulting value proposition in the form of Exadata has truly been a game-changer. Expert Oracle Exadata, 2nd Edition provides a look at the internals and how the combination of hardware and software that comprise Exadata actually work. Authors include Martin Bach, Andy Colvin, and Frits Hoogland, with contributions from Karl Arao, and built on the foundation laid by Kerry Osborne, Randy Johnson, and Tanel Poder in the first edition. They share their real-world experience gained through a great many Exadata implementations, possibly more than any other group of experts today. Always their goal is toward helping you advance your career through success with Exadata in your own environment. 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. This book changes how you think about managing SQL performance and processing. It provides a roadmap to successful Exadata implementation. And it removes the "black box" mystique. You'll learn how Exadata actually works and be better able to manage your Exadata engineered systems in support of your business. This book: Changes the way you think about managing SQL performance and processing Provides a roadmap to successful Exadata implementation Removes the "black box" mystique, showing how Exadata actually works
Tariq Farooq,Mike Ault,Paulo Portugal,Mohamed Houri,Syed Jaffar Hussain,Jim Czuprynski,Guy Harrison
Author: Tariq Farooq,Mike Ault,Paulo Portugal,Mohamed Houri,Syed Jaffar Hussain,Jim Czuprynski,Guy Harrison
Publisher: Addison-Wesley Professional
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.
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
The Zero Data Loss Recovery Appliance (ZDLRA), also called the Recovery Appliance, is a brand new engineered system from Oracle Corporation, which takes a fundamentally different approach to data protection. Ramesh explores how the system can be used to back up and recover thousands of Oracle databases. The Recovery Appliance virtually eliminates data loss with its revolutionary design. This is your complete guide to the first engineered system for data protection from Oracle Corporation, the Zero Data Loss Recovery Appliance. You will find concise treatment of all the key capabilities presented in a comprehensive, all grain, no chaff format. This book is an invaluable resource for all things ZDLRA, and helps you get the most from your investment in this groundbreaking appliance for business continuity. Oracle Recovery Appliance Handbook is focused on helping to get you up to speed on protecting data in the most disaster-proof manner. Recover and Rejoice by implementing ZDLRA today in your organization using this guide!
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/
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
The book follows a tutorial-based approach, covering all the best practices for backup and recovery. The book starts by introducing readers to the world of backup and recovery, then moves on to teach them the new features offered by Oracle 12c. The book is full of useful tips and best practices that are essential for any DBA to perform backup and recovery operations in an organization.This book is designed for Oracle DBAs and system administrators. The reader will have a basic working experience of administering Oracle databases. This book is designed for Oracle DBAs and system administrators.This book will become a reference guide and will also help you to learn some new skills, and give you some new ideas you never knew about, helping you to easily find the solution to some of the most well-known problems you could encounter as DBAs.
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.
Mit APEX datenbankbasierte Webanwendungen entwickeln
Author: Ralf Beckmann
Publisher: Carl Hanser Verlag GmbH Co KG
Oracle Application Express in der Praxis // - Lernen Sie, wie APEX funktioniert und wie Sie iterativ Anwendungen für den Unternehmenseinsatz entwickeln - Erfahren Sie, wie Sie mit APEX 4.2 mobile Anwendungen erstellen - Sichern Sie Ihre APEX-Anwendungen und beugen Sie Angriffen vor - Nutzen Sie die neuen Möglichkeiten von APEX 4.2. - Modularisieren Sie Ihre Anwendungen durch die Erstellung von PlugIns Die Fähigkeiten eines Softwareentwicklers, in zunehmend kürzerer Zeit Anwendungen zu entwickeln, wird immer mehr zu einem entscheidenden Faktor für den IT-Experten. Mit ORACLE Application Express steht Ihnen eine mächtige Entwicklungsumgebung zur Verfügung, mit der Sie komplexe Unternehmensanwendungen in einer atemberaubenden Geschwindigkeit erstellen können. Dieses Buch führt leicht verständlich in die Entwicklung datenbankbasierter Webanwendungen mit APEX 4.2 ein und bietet Ihnen einen praxisnahen Überblick. Sie können alle notwendigen Entwicklungsschritte – von der Installation bis hin zur fertigen Web-Anwendung – anhand eines durchgängigen Beispiels einer „Projektmanagementplattform“ systematisch und umfänglich nachvollziehen. Neben den APEX-Grundlagen werden aber auch Themen wie die Entwicklung multilingualer Anwendungen, die Entwicklung von mobilen Web-Apps und das Deployment von APEX Anwendungen behandelt. Die Verwendung interessanter Funktionen wie z.B. Data-Load-Wizards, Plug-ins und WebSheet-Anwendungen runden dieses Werk ab. AUS DEM INHALT // Was ist APEX? // Eine Anwendung erstellen // Bestandteile einer APEX-Anwendung // Themes und Templates // Session-State // Seiten, Regionen, Items // Berechnung (computation), Prozesse, Validierungen // Wertelisten (List of Values) // Rasterlayout (Grid Layout) // Data-Load-Wizard // Registerkarten, Listen und Breadcrumps // Interaktive Grids, Diagramme, Bäume und Kalender // Dynamische Aktionen (Dynamic Actions) // Fehlersuche // Sicherheit (APEX härten, Tampering, Cross-Site Scripting, SQL-Injection, Brute Force) // Plug-ins // Mobile // Anwendungen und das Responsive Design // Websheets // Mehrsprachige APEX-Anwendungen // Deployment Systemvoraussetzungen für E-Book inside: Internet-Verbindung und Adobe-Reader
This comprehensive guide has been fully updated to cover the latest features and tools of Oracle Real Application Clusters 12c Through clear instruction and detailed examples, Oracle Database 12c Real Application Clusters Handbook: Concepts, Administration, Tuning & Troubleshooting teaches how to build, configure, and maintain a dynamic enterprise computing infrastructure. This thoroughly revised edition covers best uses for the latest tools and features—all from the practical standpoint of a working DBA. You will discover how to prepare hardware, configure the software, optimize data integrity, and integrate seamless failover protection. Brand-new flex and large cluster technologies are explained in full detail, and readers will get complete solutions for securing data and continuing business operations in the event of hardware failure. Presents all the new information needed to effectively use Oracle Real Application Clusters 12c -considered the most radical overhaul ever Offers detailed coverage of troubleshooting, performance tuning, and application development
Your ultimate guide to passing the OCP 12c Upgrade 1Z0-060 Exam About This Book This is your one-stop solution to understanding what's new in Oracle 12c and how to bring these features to your systems in a hassle-free manner A complete guide to clearing the OCP Upgrade 1Z0-060 Exam Dive deep into Oracle administration and get up to date Who This Book Is For This book is for Oracle Admins who have a working knowledge of Oracle administration and now want to upgrade their knowledge to the latest version (Oracle 12c). This book is perfect for those who wish to pass the OCP Upgrade 1Z0-060 Exam. What You Will Learn All of the new features of the Oracle 12c database that you are required to know for the OCP Upgrade Exam 1Z0-060 New multitenant architecture introduced in Oracle 12c and how it works Monitor complex database operations and use the new enhanced SQL tuning features to tune bad SQLs Manage data over time using information life cycle management Make your data more secure by implementing new enhanced auditing Learn new security features and how to implement encryption to secure your data Explore how backup and flashback works with new multitenant architecture Performance management techniques that will analyze and tune your database In Detail This guide will get Oracle admins up to date with the latest developments in Oracle 12c. It includes all the necessary information that you need to implement in your existing systems. All of the information in this book has been handpicked to help you study for the Oracle 12c upgrade exam. Each chapter has been written with the objective of helping you pass this exam with ease. Content in this book is aligned with the objectives of the exam, making it really easy to follow the course content. Every example mentioned in this book has been tried and tested in actual environment. Real-world examples will help you learn about new features such as multitenant containers database architecture, managing containers, pluggable databases, database administration enhancements, database auditing, tuning, backup, and flashback enhancements. You will also learn about storage enhancements, security updates, tuning, troubleshooting, and backup enhancements. This book also covers section 2 of the exam course making this book a complete guide for passing OCP 12c upgrade exam 1Z0-060. Style and approach This book systematically covers various aspects of Oracle administration and provides the information necessary to pass the OCP Upgrade 1Z0-060 Exam Set 1 and Set 2.