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

Linux and Solaris Recipes for Oracle DBAs, 2nd Edition is an example-based book on managing Oracle Database under Linux and Solaris. The book is written for database administrators who need to get work done and lack the luxury of curling up fireside with a stack of operating-system documentation. What this book provides instead is task-oriented coverage designed around the needs of the Oracle Database Administrator. Find the right chapter. Look up the task to perform. See the solution. Implement the solution straight away in your own environment. Get the job done. New in this edition is coverage of Oracle's own Solaris operating system. Oracle Corporation has been working diligently to bring commonality between Solaris and and Linux, and this book takes advantage of those efforts to provide task-oriented solutions that work on common distributions of Linux such as Red Hat Enterprise Linux and Oracle Enterprise Linux while also accommodating the growing number of Oracle Solaris customers. Examples in the book match the tasks DBAs perform daily, even hourly. Solutions come first in the book, but alway are followed by close explanations of the details. Database administrators won't go wrong with Linux and Solaris Recipes for Oracle DBAs. It's the book to buy if you're after clear and reliable examples to help in getting the job done, and getting home to your family. Takes you directly from problem to solution Covers the "right" mix of operating-system tasks for database administrators Respects your time by being succinct and to-the-point Includes coverage of Solaris in addition to common Linux distributions What You Will Learn Execute Linux and Solaris commands applicable to Oracle Database. Automate critical DBA tasks via operating-system shell scripts. Monitor, tune, and optimize Linux and Solaris servers for Oracle. Setup a VirtualBox environment for the Oracle database. Perform system administration tasks relevant to Oracle Database. Remotely (and securely!) manage Oracle on Linux and Solaris. Who This Book Is For Linux and Solaris Recipes for Oracle DBAs is a book for Oracle database administrators who want to expertly operate Oracle databases on the Linux and Solaris operating systems. If you're new to Linux and Solaris and can benefit from detailed examples showing how to perform tasks that Oracle DBAs perform on Linux and Solaris servers, then this book is what you need to help you get the job done, and get home on time.

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

Pro Oracle Fusion Applications is your one-stop source for help with installing Oracle's Fusion Applications suite in your on-premise environment. It also aids in the monitoring and ongoing administration of your Fusion environment. Author Tushar Thakker is widely known for his writings and expertise on Oracle Fusion Applications, and now he brings his accumulated wisdom to you in the form of this convenient handbook. Provisioning an Oracle Fusion Applications infrastructure is a daunting task. You'll have to plan a suitable topology and install the required database, an enterprise-wide identity management solution, and the applications themselves-all while working with a wide variety of people who may not always be accustomed to working together. Pro Oracle Fusion Applications provides a path to success that you won't want to be without. Beyond installation, Pro Oracle Fusion Applications provides excellent guidance on managing, monitoring, diagnostics, and troubleshooting your environment. The book also covers patching, a mundane but essential task that must be done regularly to keep your installation protected and running smoothly. The comprehensive and wide-ranging coverage makes Pro Oracle Fusion Applications an important book for anyone with responsibility for installation and ongoing management of an Oracle Fusion Applications installation.

Expert Oracle Application Express, 2nd Edition is newly updated for APEX 5.0 and brings deep insight from some of the best APEX practitioners in the field today. You'll learn about important features in APEX 5.0, and how those can be applied to make your development work easier and with greater impact on your business. Oracle Application Express (APEX) is an entirely web-based development framework that is built into every edition of Oracle Database. The framework rests upon Oracle's powerful PL/SQL language, enabling power users and developers to rapidly develop applications that easily scale to hundreds, even thousands of concurrent users. APEX has seen meteoric growth and is becoming the tool of choice for ad-hoc application development in the enterprise. The many authors of Expert Oracle Application Express, 2nd Edition build their careers around APEX. They know what it takes to make the product sing-developing secure applications that can be deployed globally to users inside and outside a large enterprise. The authors come together in this book to share some of their deepest and most powerful insights into solving the difficult problems surrounding globalization, configuration and lifecycle management, and more. New in this edition for APEX 5.0 is coverage of Oracle REST Data Services, map integration, jQuery with APEX, and the new Page Designer. You'll learn about debugging and performance, deep secrets to customizing your application u ser interface, how to secure applications from intrusion, and about deploying globally in multiple languages. Expert Oracle Application Express, 2nd Edition is truly a book that will move you and your skillset a big step towards the apex of Application Express development. Contains all-new content on Oracle REST Data Services, jQuery in APEX, and map integration Addresses globalization and other concerns of enterprise-level development Shows how to customize APEX for your own application needs

Expert Consolidation in Oracle Database 12c is your key to reducing data management costs and increasing data center efficiency. Consolidation and cloud computing are converging trends sweeping the industry. The same technologies enabling cloud computing enable consolidation as well, leading to savings on all fronts from the amount of power used for servers to the amount of floor space consumed to the number of administrators needed to manage an installation. Yet the consolidation process can be a long and winding road. Success requires planning, and consideration to the impacts on supporting infrastructure.Expert Consolidation in Oracle Database 12c guides you through planning and implementing a consolidated Oracle Database installation using the many new features built into the latest release of Oracle's database management system. You'll learn to identify candidates for consolidation and to recognize instances that are best left stand-alone. The book guides in working with clustered systems and ASM storage in the consolidated environment. Focus is given to Oracle Enterprise Manager 12c Cloud Control as a monitoring and management dashboard. Always the goal is to drive towards a cost-effective environment that is efficient both in technology and people. Focuses on the new consolidation features in Oracle Database 12c Helps you evaluate and correctly decide when to consolidate Leads to cost savings and improved data center efficiency

Performance problems are rarely problems per se. They are more often crises during which you're pressured for results by a manager standing outside your cubicle while your phone rings with queries from the help desk. You won't have the time for a leisurely perusal of the manuals, nor to lean back and read a book on theory. What you need in that situation is a book of solutions, and solutions are precisely what Oracle Database 12c Performance Tuning Recipes delivers. Oracle Database 12c Performance Tuning Recipes is a ready reference for database administrators in need of immediate help with performance issues relating to Oracle Database. The book takes an example-based approach, wherein each chapter covers a specific problem domain. Within each chapter are recipes, showing by example how to perform common tasks in that chapter's domain. Solutions in the recipes are backed by clear explanations of background and theory from the author team. Whatever the task, if it's performance-related, you'll probably find a recipe and a solution in this book.* Provides proven solutions to real-life Oracle performance problems * Offers relevant background and theory to support each solution * Gets straight to the point for when you're under pressure for results What you'll learn * Optimize the use of memory and storage * Monitor performance and troubleshoot problems * Identify and improve poorly-performing SQL statements * Adjust the most important optimizer parameters to your advantage * Create indexes that get used and make a positive impact upon performance * Automate and stabilize using key features such as SQL Tuning Advisor and SQL Plan Baselines Who this book is for Oracle Database 12c Performance Tuning Recipes is aimed squarely at Oracle Database administrators. The book especially appeals to those administrators desiring to have at their side a ready-to-go set of solutions to common database performance problems.

Pro Oracle SQL, Second Edition unlocks the power of SQL in the Oracle database--one of the most potent SQL implementations on the market today. To master it requires a multi-pronged approach: learn the language features, learn how and why the language features work, learn the supporting features that Oracle provides to help use the language effectively, and learn to think and work in sets. Karen Morton has updated the content for Oracle version 12c and helps you master powerful aspects of Oracle SQL from the inside-out. You'll learn analytic functions, the MODEL clause, and advanced grouping syntax--features that will help in creating good queries for reporting and business intelligence applications. Pro Oracle SQL, Second Edition also helps you minimize parsing overhead, read execution plans, test for correct results, understand performance management, and exert control over SQL execution in your database. You'll learn when to create indexes, how to verify that they make a difference, how to use SQL Baselines and Profiles to optimize and stabilize SQL execution plans, and much more.You'll also understand how SQL is optimized for working in sets, and that the key to getting accurate results lies in making sure that queries ask clear and precise questions. Pro Oracle SQL, Second Edition helps you work at a truly professional level in the Oracle dialect of SQL. You'll master the language, the tools to work effectively with the language, and the right way to think about a problem in SQL. * Endorsed by the OakTable Network, a group of Oracle technologists well-known for their rigorous and scientific approach to Oracle Database performance * Comprehensive--goes beyond the language with a focus on what you need to know to write successful queries and data manipulation statements. * Performance focused--teaches you how to measure the performance of your SQL statements and not just the syntax.What you'll learn * Master powerful SQL features implemented in the Oracle Database * Understand how the Oracle Optimizer develops execution plans * Read and interpret SQL execution plans * Quickly diagnose and fix badly performing SQL * Control execution plans through hints, profiles, and plan baselines * Optimize queries within packaged applications without touching the code * Recognize when not to waste time on SQL that is performing optimally Who this book is for Pro Oracle SQL, Second Edition is aimed at developers and database administrators who submit SQL for execution by an Oracle database. Readers should already know the basic four SQL statements, and be ready to learn deeply about Oracle's specific implementation of the language, including Oracle-specific features and syntax. Readers should also want to learn about Oracle Database features such as analytic queries, the MODEL clause, and the WITH clause (subquery factoring) that are designed to help developers and database administrators exert control over their SQL environment and its execution.

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.

Enterprise Manager 12c (EM12c), Oracle's newest and fully-integrated enterprise management product, now provides a complete cloud lifecycle management solution and enterprise environment management interface. Expert Oracle Enterprise Manager 12c opens up the secrets of this incredible management tool, saving you time while enhancing your visibility as someone management can rely upon to deliver reliable database service in today's increasingly chaotic and change-driven IT environment. Expert Oracle Enterprise Manager 12c covers all the topics you demand and need to function effectively, from basic monitoring and configuration to advanced metric extensions and plugins. Real-life scenarios and demonstrations place you in the comfort zone of using the EM12c console, and the experienced author team provides deep understanding of the inner workings of this new Enterprise Manager. Database administrators and system administrators are expected to offer increasing levels of service for 24X7 systems and newer cloud environments. Em12c offers robust, end-to-end intelligent management of the complete environment. It includes direct, real-time integration with Oracle's online knowledgebase.Expert Oracle Enterprise Manager 12c helps you master this important tool and manage any challenge that comes your way. * Provides example solutions to everyday problems through EM12c features. * Explains the changes in EM12c, included trusted extensions. * Focuses on advanced aspects of the EM12c interface. What you'll learn * Installation and agent employment * Patching and provisioning * Advanced techniques for managing and monitoring * Use of EM12c in cloud environments, with RAC, and for Exadata * Creation of EM12c plugins and metric extensions * High-availability and disaster-recovery options with EM12c * Incident Manager and EM12c job management Who this book is for Expert Oracle Enterprise Manager 12c is for database administrators who are ready to upgrade, or who have already upgraded to Enterprise Manager 12c. The book also appeals to system administrators who may have responsibility for helping support Oracle Database environments -- including RAC and Exadata -- at the enterprise level.

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 Core: Essential Internals for DBAs and Developers by Jonathan Lewis provides just the essential information about Oracle Database internals that every database administrator needs for troubleshooting - no more, no less. Oracle Database seems complex on the surface. However, its extensive feature set is really built upon upon a core infrastructure resulting from sound architectural decisions made very early on that have stood the test of time. This core infrastructure manages transactions and the ability to commit and roll back changes, protects the integrity of the database, enables backup and recovery, and allows for scalability to thousands of users all accessing the same data. Most performance, backup, and recovery problems that database administrators face on a daily basis can easily be identified through understanding the essential core of Oracle Database architecture that Lewis describes in this book.* Provides proven content from a world-renowned performance and troubleshooting expert * Emphasizes the significance of internals knowledge to rapid identification of database performance problems * Covers the core essentials and does not waste your time with esoterica What you'll learn * Oracle's core architectural foundations * How much overhead is reasonable * How to recognize when you're doing too much work * How to predict bottlenecks and why they will happen * How to minimise contention and locking * Why concurrency can slow things down significantly Who this book is for Oracle Core: Essential Internals for DBAs and Developers is aimed at database administrators ready to move beyond the beginning stage of doing work by rote towards the mastery stage, in which knowledge of what needs to be done comes not from a set of recipe-style instructions, but rather from the intimate knowledge and understanding of the system to be managed. Experienced database administrators will also find the book useful in solidifying their knowledge and filling in any missing pieces of the Oracle Database puzzle.Table of Contents * Introduction * Redo and Undo * Transactions and Consistency * Latches and Locks * Caches and Copies * Writing and Recovery * RAC and Ruin * Dumping and Debugging * Working and Waiting

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

Pro Oracle Database 11g Administration is a book focused on results. Author Darl Kuhn draws from a well of experience over a decade deep to lay out real-world techniques that lead to success as an Oracle DBA. He gives clear explanations on how to perform critical tasks. He weaves in theory where necessary without bogging you down in unneeded detail. He is not afraid to take a stand on how things should be done. He won't leave you adrift in a sea of choices, showing you three ways to do something and then walking away. Database administration isn't about passing a certified exam, or about pointing-and-clicking your way through a crisis. Database administration is about applying the right solution at the right time, about avoiding risk, about making robust choices that get you home each night in time for dinner with your family. If you have buck stops here responsibility for an Oracle database, then Pro Oracle Database 11g Administration is the book you need to help elevate yourself to the level of Professional Oracle Database Administrator. * Condenses and organizes the core job of a database administrator into one volume.* Takes a results-oriented approach to getting things done. * Lays a foundation upon which to build a senior level of expertise What you'll learn * Create a stable environment consistent across all databases that you manage * Take care of job #1: backing up, and then recovering when needed * Manage users and objects, and the security between them * Do battle with large - large databases and large objects * Move and distribute data using Data Pump, materialized views, external tables * Automate critical jobs and tackle database troubleshooting problems Who this book is for Pro Oracle Database 11g Administration is aimed at new database administrators who aspire to senior positions in which employers and customers trust you to work independently, and with a buck stops here attitude.Table of Contents * Installing the Oracle Binaries * Implementing a Database * Configuring an Efficient Environment * Tablespaces and Datafiles * Managing Control Files and Online Redo Logs * Users and Basic Security * Tables and Constraints * Indexes * Views, Synonyms, and Sequences * Data Dictionary Basics * Large Objects * Partitioning: Divide and Conquer * Data Pump * External Tables * Materialized Views * User-Managed Backup and Recovery * Configuring RMAN * RMAN Backups and Reporting * RMAN Restore and Recovery * Oracle Secure Backup * Automating Jobs * Database Troubleshooting

Pro Oracle SQL unlocks the power of SQL in the Oracle Database one of the most potent SQL implementations on the market today. To master it requires a three-pronged approach: learn the language features, learn the supporting features that Oracle provides to help use the language effectively, and learn to think and work in sets. Karen Morton and her team help you master powerful aspects of Oracle SQL not found in competing databases. You ll learn analytic functions, the MODEL clause, and advanced grouping syntax techniques that will help in creating good queries for reporting and business intelligence applications. Pro Oracle SQL also helps you minimize parsing overhead, read execution plans, test for correct results, and exert control over SQL execution in your database. You ll learn when to create indexes, how to verify that they make a difference, how to use SQL Profiles to optimize SQL in packaged applications, and much more. You ll also understand how SQL is optimized for working in sets, and that the key to getting accurate results lies in making sure that queries ask clear and precise questions. What s the bottom-line?Pro Oracle SQL helps you work at a truly professional level in Oracle dialect of SQL. You ll master the language, the tools to work effectively with the language, and the right way to think about a problem in SQL. Pro Oracle SQL helps you rise above the crowd to provide stellar service in your chosen profession. * Endorsed by the OakTable Network, a group of Oracle technologists well-known for their rigorous and scientific approach to Oracle Database performance * Comprehensive goes beyond the language with a focus on what you need to know to write successful queries and data manipulation statements. What you'll learn * Master powerful SQL features implemented only in Oracle Database * Read and interpret SQL execution plans * Quickly diagnose and fix badly performing SQL * Control execution plans through hints, profiles, and plan baselines * Optimize queries within packaged applications without touching the code * Recognize when not to waste time on SQL that is performing optimally Who this book is for Pro Oracle SQL is aimed at developers and database administrators who submit SQL for execution by an Oracle database.Readers should already know the basic four SQL statements, and be ready to learn deeply about Oracle s specific implementation of the language, including Oracle-specific features and syntax. Readers should also want to learn about Oracle Database features such as analytic queries, the MODEL clause, and subquery refactoring that are designed to help developers and DBAs exert control over their SQL environment and its execution.

Oracle PL/SQL Recipes is your go to book for PL/SQL programming solutions. It takes a task-oriented approach to PL/SQL programming that lets you quickly look up a specific task and see the pattern for a solution. Then it's as simple as modifying the pattern for your specific application and implementing it. And you're done and home for dinner.
Oracle PL/SQL Recipes is another in Apress' ongoing series of recipe books aimed at Oracle practitioners. The recipe format is ideal for the busy professional who just needs to get the job done. Covers the most common PL/SQL programming problems Presents solutions in ready-to-use format Stays short and to-the-point What you'll learn Move business logic into the database Implement robust exception-handling Optimize and debug, taking advantage of Oracle SQL Developer Integrate PL/SQL with web-based applications Interface with Java code and dynamic languages in the database, and running externally Run the UTPLSQL unit-testing framework Who this book is for

Oracle PL/SQL Recipes is database administrators and developers wanting to take advantage of Oracle Database's built-in support for procedural logic. Database administrators can use PL/SQL to automate administrative tasks, audit access to sensitive data, and more. Developers will be able to optimize processing, push business logic into the database layer, and interface with Java and web applications. Table of Contents PL/SQL Fundamentals Essential SQL Looping and Logic Functions, Packages, and Procedures Triggers Type Conversion Numbers, Strings, and Dates Dynamic SQL Exceptions PL/SQL Collections and Records Automating Routine Tasks Oracle SQL Developer Analyzing and Improving Performance Using PL/SQL on the Web Java in the Database Accessing PL/SQL from JDBC, HTTP, Groovy, and Jython Unit Testing With utPLSQL

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.

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

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.

Demystifying the power of the Oracle 12c database The Oracle database is the industry-leading relational database management system (RDMS) used from small companies to the world s largest enterprises alike for their most critical business and analytical processing. Oracle 12c includes industry leading enhancements to enable cloud computing and empowers users to manage both Big Data and traditional data structures faster and cheaper than ever before. Oracle 12c For Dummies is the perfect guide for a novice database administrator or an Oracle DBA who is new to Oracle 12c. The book covers what you need to know about Oracle 12c architecture, software tools, and how to successfully manage Oracle databases in the real world. * Highlights the important features of Oracle 12c * Explains how to create, populate, protect, tune, and troubleshoot a new Oracle database * Covers advanced Oracle 12c technologies including Oracle Multitenant the "pluggable database" concept as well as several other key changes in this release Make the most of Oracle 12c's improved efficiency, stronger security, and simplified management capabilities with Oracle 12c For Dummies.

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product. Implement a Centralized Cloud Storage Infrastructure with Oracle Automatic Storage Management Build and manage a scalable, highly available cloud storage solution. Filled with detailed examples and best practices, this Oracle Press guide explains how to set up a complete cloud-based storage system using Oracle Automatic Storage Management. Find out how to prepare hardware, build disk groups, efficiently allocate storage space, and handle security. Database Cloud Storage: The Essential Guide to Oracle Automatic Storage Management shows how to monitor your system, maximize throughput, and ensure consistency across servers and clusters. Set up and configure Oracle Automatic Storage Management Discover and manage disks and establish disk groups Create, clone, and administer Oracle databases Consolidate resources with Oracle Private Database Cloud Control access, encrypt files, and assign user privileges Integrate replication, file tagging, and automatic failover Employ pre-engineered private cloud database consolidation tools Check for data consistency and resync failed disks Code examples in the book are available for download

Designed for both new programmers and those experienced in other languages, this book presents the core features of Oracle's PL/SQL language in an easy-to-read format. Learning Oracle PL/SQL will bring programmers up to speed on the most important aspects of PL/SQL, including web and Internet programming. Updated through Oracle9i, includes sample programs downloadable from examples.oreilly.com/learnoracle.

Toad is an enormously popular interactive environment tool for Oracle development and administration. It allows developers to build, test, debug, and format their code via an easy-to-use graphical user interface, available in both freeware and commercial versions. Toad makes developers far more productive; using Toad, you'll find that program changes that once took hours can now be completed in minutes. Toad allows developers to browse their database tables, procedures, and object types; use code templates; and show errors. It also simplifies database administration by providing a way for DBAs to graphically browse and change database characteristics.

Updated for Toad Versions 8.0 and 8.5, this pocket book is packed with quick-reference material: Toad feature and menu summaries, shortcut keys, suggested changes to Toad defaults, productivity tips and tricks, and more. The book includes concise discussions of all the basic Toad components: the SQL Editor, Procedure Editor, SQL Modeler, Schema Browser, Project Manager, and Debugger. The second edition includes coverage of new SQL Editor features, improvements in usability, and new tools such as CodeXpert (a robust code analyzer and advisor) and Script Debugger (the only tool available that provides real-time debugging of SQL*Plus scripts). It also provides helpful hints on using Toad to perform database administration and SQL tuning and optimization.

Whether you're a new or experienced Toad user, you'll find this quick reference an indispensable companion to the product and its online help files.

Despite its wide availability and usage, few developers and DBAs have mastered the true power of Oracle SQL*Plus. This bestselling book--now updated for Oracle 10g--is the only in-depth guide to this interactive query tool for writing SQL scripts. It's an essential resource for any Oracle user.

The new second edition of "Oracle SQL*Plus: The Definitive Guide" clearly describes how to perform, step-by-step, all of the tasks that Oracle developers and DBAs want to perform with SQL*Plus--and maybe some you didn't realize you could perform.

With "Oracle SQL*Plus: The Definitive Guide," you'll expertly:

write and execute script files

generate ad hoc reports

extract data from the database

query the data dictionary tables

customize an SQL*Plus environment

and much more

It also includes a handy quick reference to all of its syntax options and an often-requested chapter on SQL itself, along with a clear, concise, and complete introduction.

This book is truly the definitive guide to SQL*Plus. It's an indispensable resource for those who are new to SQL*Plus, a task-oriented learning tool for those who are already using it, and an immediately useful quick reference for every user. If you want to leverage the full power and flexibility of this popular Oracle tool, you'll need this book.