From operating systems to the cloud, Oracle's products and services are everywhere, and it has the market share to prove it. Given the share diversity of the Oracle product line, and the level of complexity of integration, management can be quite a daunting task. The CIO's Guide to Oracle Products and Solutions is the go-to guide for all things Oracle. It provides management-level guidance on how to successfully navigate and manage the full range of Oracle products. The book presents management best practices and user/developer lessons learned in the use of Oracle products and services. Supplying both conceptual and technical views, the text focuses on what CIOs need to do to orient, or reorient, their organization toward the use of Oracle products and services. It describes how to develop a strategic framework for the use of these products and services rather than the specific product or service itself. This strategic framework will help you to prepare, educate, keep up with change, mitigate risk, and implement with the confidence needed to succeed. Providing an overview of the suite of Oracle technologies and solutions, the book covers the heart of the Oracle products set, including Oracle analytics, enterprise performance management, Oracle cloud, data management, application development, social business, and fusion. It examines compliance and security issues and includes metrics to help you evaluate potential solutions. The book also provides readers with access to a set of helpful resources on the book's page at www.crcpress.com, including cloud procurement best practices, cloud migration tips, a sample project procurement plan template, and various glossaries.

"Pro Oracle Spatial for Oracle Database 11g"shows how to take advantage of Oracle Databases builtin feature set for working with locationbased data. A great deal of the information used in business today is associated with location in some way, and analysis of that data is becoming ever more important in today's mobile and highly connected world. In "Pro Oracle Spatial for Oracle Database 11g," authors Ravi Kothuri and Albert Godfrind address: The special nature of spatial data and its role in professional and consumer applications Issues in spatial data management such as modeling, storing, accessing, and analyzing spatial data The Oracle Spatial solution and the integration of spatial data into enterprise databases How spatial information is used to understand business and support decisions, to manage customer relations, and to better serve private and corporate users

When you read "Pro Oracle Spatial for Oracle Database 11g," you're learning from the very best. Ravi Kothuri is a key member of Oracle's Spatial development team. Albert Godfrind consults widely with Oracle clients on the implementation of Oracle Spatial, develops training courses, and presents frequently at conferences. Together they have crafted a technically sound and authoritative fountain of information on working with spatial data in the Oracle database. What you'll learn About new Oracle Spatial features in Oracle Database 11g, including support for the European Petroleum Standards Group (EPSG) data model, the ability to publish to Google Earth, integration with Google Maps, and much more The use of Oracles built-in SDO_GEOMETRY data type for storing locationbased data How to geocode your data, beginning with postal addresses and ending with SDO_GEOMETRY objects that enable future analysis as well as forming the foundation of working with spatial data within Oracle How to create and display maps to help you visualize and analyze your geocoded data About network modeling, which is useful in computing routes, travel distances, and proximity based upon travel time How to optimize analysis of your spatial data by creating spatial indexes and custom operators Who this book is for

"Pro Oracle Spatial for Oracle Database 11g" is aimed at software developers who wish to develop applications using Oracles extensive and strong support for working with spatial, or geocoded, data.

PeopleSoft for the Oracle DBA, Second Edition stands on the boundary between the PeopleSoft application and the Oracle database. This new edition of David Kurtz's book is freshly revised, showing how to tame the beast and manage Oracle successfully in a PeopleSoft environment. You'll learn about PeopleSoft's Internet architecture and its use of Oracle's Tuxedo Application Server. You'll find full coverage of key database issues such as indexing, connectivity, and tablespace usage as they apply to PeopleSoft. Kurtz also provides some of the best advice and information to be found anywhere on managing and troubleshooting performance issues in a PeopleSoft environment. The solid coverage of performance troubleshooting is enough by itself to make PeopleSoft for the Oracle DBA a must-have book for any Oracle Database administrator working in support of a PeopleSoft environment. * Explains PeopleSoft's technical architecture as it relates to Oracle Database * Demonstrates how to instrument and measure the performance of PeopleSoft * Provides techniques to troubleshoot and resolve performance problems What you'll learn * Understand PeopleSoft's technical architecture and the structure of a PeopleSoft database * Measure performance of the various tiers in the application * Pinpoint and resolve performance problems within the code * Configure server processes for optimal performance * Monitor and manage your PeopleSoft installation using Oracle Enterprise Manager * Take full advantage of the PeopleTools Performance Monitor that is new in version 8.44 Who this book is for PeopleSoft for the Oracle DBA is written for database administrators charged with supporting a PeopleSoft system, and especially those administrators responsible for troubleshooting and resolving PeopleSoft performance issues. PeopleSoft for the Oracle DBA also appeals to PeopleSoft administrators and developers who desire a better understanding of how PeopleSoft functions in an Oracle Database environment.

Now available in paperback-- What do you do when your database application isn't running fast enough? You troubleshoot, of course. Finding the slow part of an application is often the easy part of the battle. It's finding a solution that's difficult. Troubleshooting Oracle Performance helps by providing a systematic approach to addressing the underlying causes of poor database application performance.* Written for developers by an application developer who has learned by doing * Gives a systematic approach to solving database application performance problems * Helps you plan for performance as you would for any other application requirement What you'll learn * See how to treat and plan for performance as a basic application requirement * Identify performance problems using a systematic and repeatable approach * Configure your query optimizer to meet your application performance goals * Optimize table accesses, joins, and physical table layout * Read and recognize inefficient SQL execution plans * Reduce inefficiencies from too much procedural code Who this book is for For application developers and database administrators involved in troubleshooting performance problems of Oracle-based applications.

Using PL/SQL for Oracle Database 12c, you can build solutions that deliver unprecedented performance and efficiency in any environment, including the cloud. Oracle (R) PL/SQL by Example, Fifth Edition, teaches all the PL/SQL skills you'll need, through real-world labs, extensive examples, exercises, and projects. Now fully updated for the newest version of PL/SQL, it covers everything from basic syntax and program control through the latest optimization and security enhancements. Step by step, you'll walk through every key task, mastering today's most valuable Oracle 12cPL/SQL programming techniques on your own. Start by downloading projects and exercises from informit.com/title/0133796787. Once you've done an exercise, the authors don't just present the answer: They offer an in-depth discussion introducing deeper insights and modern best practices. This book's approach fully reflects the authors' award-winning experience teaching PL/SQL to professionals at Columbia University. New database developers and DBAs can use it to get productive fast; experienced PL/SQL programmers will find it to be a superb Oracle Database 12csolutions reference. New in This Edition Updated code examples throughout Result-caching of invoker's right functions for better performance Extended support for PL/SQL-only data types in dynamic SQL, OCI, and JDBC Security enhancements, including ACCESSIBLE BY whitelists, improved privilege control, and Invisible Columns Other topics covered Mastering basic PL/SQL concepts and language fundamentals, and understanding SQL's role in PL/SQL Using conditional and iterative program control, including CONTINUE and CONTINUE WHEN Efficiently handling errors and exceptions Working with cursors and triggers, including compound triggers Using stored procedures, functions, and packages to write modular code that other programs can run Working with collections, object-relational features, native dynamic SQL, bulk SQL, and other advanced features

From operating systems to the cloud, Oracle's products and services are everywhere, and it has the market share to prove it. Given the share diversity of the Oracle product line, and the level of complexity of integration, management can be quite a daunting task. The CIO's Guide to Oracle Products and Solutions is the go-to guide for all things Oracle. It provides management-level guidance on how to successfully navigate and manage the full range of Oracle products. The book presents management best practices and user/developer lessons learned in the use of Oracle products and services. Supplying both conceptual and technical views, the text focuses on what CIOs need to do to orient, or reorient, their organization toward the use of Oracle products and services. It describes how to develop a strategic framework for the use of these products and services rather than the specific product or service itself. This strategic framework will help you to prepare, educate, keep up with change, mitigate risk, and implement with the confidence needed to succeed. Providing an overview of the suite of Oracle technologies and solutions, the book covers the heart of the Oracle products set, including Oracle analytics, enterprise performance management, Oracle cloud, data management, application development, social business, and fusion. It examines compliance and security issues and includes metrics to help you evaluate potential solutions. The book also provides readers with access to a set of helpful resources on the book's page at www.crcpress.com, including cloud procurement best practices, cloud migration tips, a sample project procurement plan template, and various glossaries.

This book shows Oracle Application Express (APEX) developers how to take advantage of Oracle Cloud Infrastructure (OCI) features for APEX that might otherwise go missed. You will learn how to use OCI features for data science tasks such as detecting anomalies in your data, training machine learning models, and much more. The book provides an in-depth look at Oracle Cloud features and demonstrates how they can be easily integrated into an APEX application. While the book focuses on developing for APEX, the approaches covered in the book are also applicable to any other modern web developer framework for applications running on the OCI platform. For many organizations, the database is the heart of operations. Those who opt to invest in the Oracle Database can learn from this book how to maximize their return on investment. The book begins with an introduction to OCI and help on setting up your OCI developer environment. From there you'll begin with security by learning to provide single sign-on via the Oracle Identity Cloud Service. Subsequent chapters take you through cloud-focused features such as Object Storage, Oracle Function, Oracle Machine Learning REST Services, and Oracle Cloud Anomaly Detection. You'll even learn to troubleshoot email delivery services. What You Will Learn Be aware of Oracle Cloud Infrastructure features for developers Integrate with cloud native services such as cloud-based object storage and serverless functions Enhance APEX applications with machine learning features Implement Natural Language Processing and Anomaly Detection Algorithms Troubleshoot email delivery services when sending emails using the APEX_MAIL package Design and implement an APEX environment that is secure Who This Book Is For APEX developers who are looking to extend their application's capabilities using features and resources available through the Oracle Cloud, and cloud solutions architects who support development teams and help design and implement architectures that benefit business operations

Now in its fourth edition and covering Oracle Database 21c, this best-selling book continues to bring you some of the best thinking on how to apply Oracle Database to produce scalable applications that perform well and deliver correct results. Tom Kyte and Darl Kuhn share a simple philosophy: "you can treat Oracle as a black box and just stick data into it, or you can understand how it works and exploit it as a powerful computing environment." If you choose the latter, then you'll find that there are few information management problems that you cannot solve quickly and elegantly. This fully revised fourth edition covers the developments and new features up to Oracle Database 21c. Up-to-date features are covered for tables, indexes, data types, sequences, partitioning, data loading, temporary tables, and more. All the examples are demonstrated using modern techniques and are executed in container and pluggable databases. The book's proof-by-example approach encourages you to let evidence be your guide. Try something. See the result. Understand why the result is what it is. Apply your newfound knowledge with confidence. The book covers features by explaining how each one works, how to implement software using it, and the common pitfalls associated with it. Don't treat Oracle Database as a black box. Get this book. Dive deeply into Oracle Database's most powerful features that many do not invest the time to learn about. Set yourself apart from your competition and turbo-charge your career. What You Will Learn Identify and effectively resolve application performance issues and bottlenecks Architect systems to leverage the full power and feature set of Oracle's database engine Configure a database to maximize the use of memory structures and background processes Understand internal locking and latching technology and how it impacts your system Proactively recommend best practices around performance for table and index structures Take advantage of advanced features such as table partitioning and parallel execution Who This Book Is For Oracle developers and Oracle DBAs. If you're a developer and want a stronger understanding of Oracle features and architecture that will enable your applications to scale regardless of the workload, this book is for you. If you're a DBA and want to intelligently work with developers to design applications that effectively leverage Oracle technology, then look no further.

A concise reference to the enormous store of information Oracle8 or Oracle7 DBAs need every day, Oracle Database Administration covers DBA tasks like installation, tuning, backups, networking, auditing, and query optimization. It's also a set of quick references on initialization parameters, SQL statements, data dictionary tables, system privileges, roles, and syntax for SQL*Plus, Export, Import, and SQL*Loader.

Oracle Application Express 4 Recipes provides an example-based approach to learning Application Expressthe ground-breaking, rapid application development platform included with every Oracle Database license. The recipes format is ideal for the quick-study who just wants a good example or two to kick start their thinking and get pointed in the right direction. The recipes cover the gamut of Application Express development. Author and Application Express expert Edmund Zehoo shows how to create data entry screens, visualize data in the form of reports and charts, implement validation and back-end logic, and much more. Solutions are presented in an easy problem/solution format, which you can copy and adapt for your own use. Detailed discussion for each solution deepens your understanding and aids in customizing the solutions to fit your particular development challenges. Teaches Application Express via an example-based format Takes you from beginner to intermediate level Shows how to build a fully-functional web store in just one hour What you'll learn Create web application forms and tables Customize application look and feel Visualize data via reports, calendars, maps, and charts Globalize applications in support of language and regional differences Implement complex business logic Optimize the performance of Application Express Protect applications from security threats Who this book is for

Oracle Application Express 4 Recipes is aimed at web application developers, PL/SQL developers, and database administrators wishing to learn and use Oracle's groundbreaking tool for rapid developmentApplication Express. The book is a quick-study and is perfect for the reader who wants only a good example to work from, customize, and adapt. Table of Contents Introducing Oracle APEX Application Data Entry WiringupApplication Logic Customizing Look and Feel Visualizing Your Data Globalizing the Application Improving Application Performance Securing the Application Deploying the Application A Mini Book Catalog Site

Learn all of the available upgrade and migration methods in detail to move to Oracle Database version 12c. You will become familiar with database upgrade best practices to complete the upgrade in an effective manner and understand the Oracle Database 12c patching process. So it's time to upgrade Oracle Database to version 12c and you need to choose the appropriate method while considering issues such as downtime. This book explains all of the available upgrade and migration methods so you can choose the one that suits your environment. You will be aware of the practical issues and proactive measures to take to upgrade successfully and reduce unexpected issues. With every release of Oracle Database there are new features and fixes to bugs identified in previous versions. As each release becomes obsolete, existing databases need to be upgraded. Oracle Database Upgrade and Migration Methods explains each method along with its strategy, requirements, steps, and known issues that have been seen so far. This book also compares the methods to help you choose the proper method according to your constraints. Also included in this book: Pre-requisite patches and pre-upgrade steps Patching to perform changes at the binary and database level to apply bug fixes What You Will Learn: Understand the need and importance of database upgrading and migration Be aware of the challenges associated with database upgrade decision making Compare all upgrade/migration methods Become familiar with database upgrade best practices and recommendations Understand database upgrade concepts in high availability and multi-tenant environments Know the database downgrade steps in case the upgraded database isn't compatible with the environment Discover the features and benefits to the organization when it moves from the old database version to the latest database version Understand Oracle 12c patching concepts Who This Book Is For: Core database administrators, solution architects, business consultants, and database architects

Use this fast-paced and comprehensive guide to build cloud-based solutions on Oracle Cloud Infrastructure. You will understand cloud infrastructure, and learn how to launch new applications and move existing applications to Oracle Cloud. Emerging trends in software architecture are covered such as autonomous platforms, infrastructure as code, containerized applications, cloud-based container orchestration with managed Kubernetes, and running serverless workloads using open-source tools. Practical examples are provided. This book teaches you how to self-provision the cloud resources you require to run and scale your custom cloud-based applications using a convenient web console and programmable APIs, and you will learn how to manage your infrastructure as code with Terraform. You will be able to plan, design, implement, deploy, run, and monitor your production-grade and fault-tolerant cloud software solutions in Oracle's data centers across the world, paying only for the resources you actually use. Oracle Cloud Infrastructure is part of Oracle's new generation cloud that delivers a complete and well-integrated set of Infrastructure as a Service (IaaS) capabilities (compute, storage, networking), edge services (DNS, web application firewall), and Platform as a Service (PaaS) capabilities (such as Oracle Autonomous Database which supports both transactional and analytical workloads, the certified and fully managed Oracle Kubernetes Engine, and a serverless platform based on an open-source Fn Project). What You Will Learn Build software solutions on Oracle Cloud Automate cloud infrastructure with CLI and Terraform Follow best practices for architecting on Oracle Cloud Employ Oracle Autonomous Database to obtain valuable data insights Run containerized applications on Oracle's Container Engine for Kubernetes Understand the emerging Cloud Native ecosystem Who This Book Is For Cloud architects, developers, DevOps engineers, and technology students and others who want to learn how to build cloud-based systems on Oracle Cloud Infrastructure (OCI) leveraging a broad range of OCI Infrastructure as a Service (IAAS) capabilities, Oracle Autonomous Database, and Oracle's Container Engine for Kubernetes. Readers should have a working knowledge of Linux, exposure to programming, and a basic understanding of networking concepts. All exercises in the book can be done at no cost with a 30-day Oracle Cloud trial.

Whether you're new to Oracle or an old hand who has yet to test the waters of APEX, Beginning Oracle Application Express 5 introduces the processes and best practices you'll need to become proficient with APEX. The book shows off the programming environment, the utilities and tools available, and then continues by walking through the process of building a working system from the ground up. All code is documented and explained so that those new to the languages will not be lost. After reading this book, power users and programmers alike can quickly put together robust and scalable applications for use by one person, by a department, by an entire company. Beginning Oracle Application Express 5 introduces version 5 of the popular and productive Oracle Application Express development platform. Called APEX for short, the platform enables rapid and easy development of web-based applications that make full use of Oracle Database. The release of APEX 5 brings major new changes to the page builder, an enhanced universal theme, better RESTful web services support, enhanced application packaging, and the many redesigned wizards give a new and fresh feel to the user interface. Covers brand-new functionality in APEX 5 Provides fully documented and explained example code Guides you through creating a working and fully deployable application

This book presents a process-based approach to implementing Oracle's Identity and Access Management Suite. Learn everything from basic installation through to advanced topics such as leveraging Oracle Virtual Directory and Identity Federation. Also covered is integrating with applications such as Oracle E-Business Suite and WebCenter Content. Pro Oracle Identity and Access Management Suite provides real world implementation examples that make up a valuable resource as you plan and implement the product stack in your own environment. The book and the examples are also useful post-installation as your enterprise begins to explore the capabilities that Identity Management Suite provides. Implementing an identity management system can be a daunting project. There are many aspects that must be considered to ensure the highest availability and high integration value to the enterprise business units. Pro Oracle Identity and Access Management Suite imparts the information needed to leverage Oracle's Identity and Access Management suite and provide the level of service your organization demands. Show results to leadership by learning from example how to integrate cross-domain authentication using identity federation, how to allow user self-service capabilities across multiple directories with Virtual Directory, and how to perform the many other functions provided by Oracle Identity and Access Management Suite. Presents an example-based installation and configuration of the entire Oracle Identity and Access Management Suite, including high-availability and performance-tuning concepts. Demonstrates Identity Federation, Virtual Directory, Fusion Middleware Integration, and Integration with Oracle Access Manager. Introduces concepts such as Split Profiles for Identity Manager, MultiFactor authentication with Oracle Adaptive Access Manager, and Self Service Portals.

Learn how to define strategies for cloud adoption of your Oracle database landscape. Understand private cloud, public cloud, and hybrid cloud computing in order to successfully design and manage databases in the cloud. The Cloud DBA-Oracle provides an overview of Database-as-a-Service (DBaaS) that you can use in defining your cloud adoption strategy. In-depth details of various cloud service providers for Oracle database are given, including Oracle Cloud and Amazon Web Services (AWS). Database administration techniques relevant to hosting databases in the cloud are shown in the book as well as the technical details needed to perform all database administration tasks and activities, such as migration to the cloud, backup in the cloud, and new database setup in the cloud. You will learn from real-world business cases and practical examples of administration of Oracle database in the cloud, highlighting the challenges faced and solutions implemented.What you will learn: Cloud computing concepts from the DBA perspective, such as private cloud, public cloud, hybrid cloud Technical details of all aspects of cloud database administration Challenges faced during setup of databases in private cloud or database migration to public cloud Key points to be kept in mind during database administration in the cloud Practical examples of successful Oracle database cloud migration and support Who Is This Book For All levels of IT professionals, from executives responsible for determining database strategies to database administrators and database architects who manage and design databases.

Learn to build and implement a robust Oracle E-Business Suite system using the new release, EBS 12.2. This hands-on, real-world guide explains the rationale for using an Oracle E-Business Suite environment in a business enterprise and covers the major technology stack changes from EBS version 11i through R12.2. You will learn to build up an EBS environment from a simple single-node installation to a complex multi-node high available setup. Practical Oracle E-Business Suite focuses on release R12.2, but key areas in R12.1 are also covered wherever necessary. Detailed instructions are provided for the installation of EBS R12.2 in single and multi-node configurations, the logic and methodology used in EBS patching, and cloning of EBS single-node and complex multi-node environments configured with RAC. This book also provides information on FMW used in EBS 12.2, as well as performance tuning and EBS 12.2 on engineered system implementations. Understand Oracle EBS software and the underlying technology stack components Install/configure Oracle E-Business Suite R12.2 in simple and HA complex setups Manage Oracle EBS 12.2 Use online patching (adop) for Installation of Oracle EBS patches Clone an EBS environment in simple and complex configurations Perform and tune Oracle EBS in all layers (Application/DB/OS/NW) Secure E-Business Suite R12.2 Who This Book Is For: Developers, data architects, and data scientists looking to integrate the most successful big data open stack architecture and how to choose the correct technology in every layer

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

RMAN Recipes for Oracle Database 12c is an example-driven approach to the Oracle database administrator's #1 job responsibility: * Be able to recover the database. Of all the things you are responsible for as database administrator, nothing is more important than the data itself. Like it or not, the fearsome responsibility of protecting your organization's most critical data falls squarely upon your shoulders: * Lose that data and your company could fail. * Lose that data and you could be out of a job. Oracle's flagship database product fortunately implements a wide-ranging feature set to aid you in the all-important task of safeguarding against data loss. Recovery Manager, or RMAN, is at the heart of that feature set, and is the tool most-often used to initiate database backup and recovery operations. In this book, well-known authors and database experts Darl Kuhn, Sam Alapati, and Arup Nanda have created a set of examples encompassing the gamut of backup and recovery tasks that you might need to perform. Sometimes, especially when the heat is on, a good example is what you need to get started towards a solution. RMAN Recipes for Oracle Database 12c delivers.It'll be the book you reach for when that dreaded call comes in at 3:00am some dreary morning. It'll be the book that lets you sleep at night knowing that no matter what transpires, that you've done your job well and can recover from any outage. RMAN Recipes for Oracle Database 12c gets right to the point with quick and easy-to-read, step-by-step solutions that can help you backup and recover your data with confidence.

Oracle RMAN Pocket Reference is ideal for DBAs who require a concise reference to common RMAN tasks. The first portion of the book presents commands for such tasks as taking a full database backup, recovering from loss of data file, and cloning a database. The second portion offers a very concise RMAN syntax reference. This book will save DBAs time when performing tasks that are infrequent, yet extremely vital.

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 12"c," 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 featuresCore concepts and structures in Oracle's architecture, including pluggable databasesOracle objects and the various datatypes Oracle supportsSystem and database management, including Oracle Enterprise Manager 12"c"Security options, basic auditing capabilities, and options for meeting compliance needsPerformance characteristics of disk, memory, and CPU tuningBasic principles of multiuser concurrencyOracle's online transaction processing (OLTP)Data warehouses, Big Data, and Oracle's business intelligence toolsBackup and recovery, and high availability and failover solutions

Now in its second edition, this best-selling book by Tom Kyte of Ask Tom fame continues to bring you some of the best thinking on how to apply Oracle Database to produce scalable applications that perform well and deliver correct results. Tom has a simple philosophy: you can treat Oracle as a black box and just stick data into it or you can understand how it works and exploit it as a powerful computing environment. If you choose the latter, then you'll find that there are few information management problems that you cannot solve quickly and elegantly. This fully revised second edition covers the latest developments in Oracle Database 11g. Each feature is taught in a proof-by-example manner, not only discussing what it is, but also how it works, how to implement software using it, and the common pitfalls associated with it. Don't treat Oracle Database as a black-box. Get this book. Get under the hood. Turbo-charge your career.* Fully-revised to cover Oracle Database 11g* Proof-by-example approach: Let the evidence be your guide* Dives deeply into Oracle Databases's most powerful featuresWhat you'll learn* Develop an evidence-based approach to problem solving* Manage transactions in highly concurrent environments* Speed access to data through table and index design* Manage files and memory structures for performance and reliability* Scale up through partitioning and parallel processing* Load and unload data to interface with external systems* Think for yourself; don't take Tom's word for it Who this book is for This book is aimed at Oracle Database administrators, at PL/SQL and Java developers writing code to be deployed inside the database, and at developers of external applications who use Oracle Database as a data store. It is the go to book for those wishing to create efficient and scalable applications.

If you are an Oracle DBA moving to Unix from another environment such as Windows NT or IBM Mainframe, you know that the commands you need to learn are far different from those covered in most beginning Unix books. In this handy pocket-sized book, Don Burleson introduces those Unix commands that you as an Oracle DBA most need to know.

This book is a comprehensive and easy-to-understand guide for using the Oracle Data Provider (ODP) version 11g on the .NET Framework. It also outlines the core GoF (Gang of Four) design patterns and coding techniques employed to build and deploy high-impact mission-critical applications using advanced Oracle database features through the ODP.NET provider. The book details the features of the ODP.NET provider in two main sections: Basic, covering the basics and mechanisms for data access via ODP.NET; and Advanced, covering advanced Oracle features such as globalization, savepoints, distributed transactions and how to call them via ODP.NET, advanced queueing (AQ), and promotable transactions. It takes you from the ground up through different implementation scenarios via a rich collection of both VB.NET and C# code samples. It outlines database security and performance optimization tricks and techniques on ODP.NET that conform to best practices and adaptable design. Different GoF design patterns are highlighted for different types of ODP.NET usage scenarios with consideration of performance and security.It provides a comprehensive guide to the synergistic integration of Oracle and Microsoft technologies such as the upcoming Oracle Developer Tools for Visual Studio (11.1.0.7.10). It also details how programmers can make use of ODT to streamline the creation of robust ODP.NET applications from within the Visual Studio environment. What you ll learn* How to use the full set of features available in ODP.NET 11g (with code samples and diagrams illustrating each feature/concept). New features such as using Oracle Streams AQ, promotable transactions, Oracle database event notifications, and Oracle database control are also covered. * The core performance and feature differences between ODP.NET, Microsoft.NET Provider for Oracle, OLEDB.NET, and ODBC.NET, together with the strengths and weaknesses of each method. This section also provides comprehensive coverage on the differences between ODP.NET 9i, 10g, and 11g.* How to take advantage of connection pooling, fetch size controls, ref cursors, bind variables, client result cache and statement caching via ODP.NET to squeeze every ounce of performance from your .NET application.* How to secure your ODP.NET applications via authentication and ODP.NET 11g s new classes to enforce imperative and declarative Oracle security.* The common programming pitfalls and design patterns to use/avoid in different ODP.NET usage scenarios* How to use a significant set of features of Oracle Developer Tools for Visual Studio (11.1.0.7.10), including new features such as the AQ designers, user/role management, and performance-tuning tools.Who this book is for This book is aimed at .NET developers looking for a comprehensive guide to ODP.NET and its latest features. The book will also appeal to those looking to optimize their OPD.NET applications by applying the best design patterns and other practices.

The insights that Jonathan provides into the workings of the cost-based optimizer will make a DBA a better designer, and a Developer a better SQL coder. Both groups will become better troubleshooters. -- Thomas Kyte, VP (Public Sector), Oracle Corporation

The question, "Why isn't Oracle using my index?" must be one of the most popular (or perhaps unpopular) questions ever asked on the Oracle help forums. You've picked exactly the right columns, you've got them in the ideal order, you've computed statistics, you've checked for null columnsand the optimizer flatly refuses to use your index unless you hint it. What could possibly be going wrong?

If you've suffered the frustration of watching the optimizer do something completely bizarre when the best execution plan is totally obvious, or spent hours or days trying to make the optimizer do what you want it to do, then this is the book you need. Youll come to know how the optimizer "thinks," understand why it makes mistakes, and recognize the data patterns that make it go awry. With this information at your fingertips, you will save an enormous amount of time on designing and trouble-shooting your SQL.

The cost-based optimizer is simply a piece of code that contains a model of how Oracle databases work. By applying this model to the statistics about your data, the optimizer tries to efficiently convert your query into an executable plan. Unfortunately, the model can't be perfect, your statistics can't be perfect, and the resulting execution plan may be far from perfect.

In "Cost-Based Oracle Fundamentals," the first book in a series of three, Jonathan Lewisone of the foremost authorities in this fielddescribes the mostcommonly used parts of the model, what the optimizer does with your statistics, and why things go wrong. With this information, youll be in a position to fix entire problem areas, not just single SQL statements, by adjusting the model or creating more truthful statistics.

This book is an anthology of effective database management techniques representing the collective wisdom of the OakTable Network. With an emphasis upon performance--but also branching into security, national language, and other issues--the book helps you deliver the most value for your company's investment in Oracle Database technologies. You'll learn to effectively plan for and monitor performance, to troubleshoot systematically when things go wrong, and to manage your database rather than letting it manage you. What you'll learn Adopt a rational approach to database management; eliminate guesswork Add value to your organization as a database professional Manage and optimize performance Exploit different platform technologies Secure your organization's data Gain deep understanding of database internals and structures Who this book is for

This book is aimed at Oracle database administrators who want to further their careers by implementing sound and proven database administration practices--and especially repeatable and predictable practices--in their daily work. Table of Contents Battle Against Any Guess A Partly Cloudy Future Developing a Performance Methodology The DBA as Designer Running Oracle on Windows Managing SQL Performance PL/SQL and the CBO Understanding Performance Optimization Methods Choosing a Performance Optimization Method Managing the Very Large Database Statistics Troubleshooting Latch Contention Measuring for Robust Performance User Security Securing Data