This book focuses exclusively on Oracle database design. It covers the most up-to-date Oracle issues and technologies, including massively parallel processors, very large databases, data warehouses, client-server, and distributed database. The design advice is detailed and thorough. The book delves deeply into design issues and gives advice that will have a major impact on your database and system performance.

Tom Kyte of Oracle Magazine’s “Ask Tom” column has written the definitive guide to designing and building high-performance, scalable Oracle applications. The book covers schema design, SQL and PL/SQL, tables and indexes, and much more. From the exclusive publisher of Oracle Press books, this is a must-have resource for all Oracle developers and DBAs.

Despite the wide use of SQL *Plus, few developers and database administrators know how powerful it really is. And the syntax can sometimes be tricky. This portable guide provides a quick reference to subjects such as interacting with SQL *Plus, selecting data, formatting reports, writing scripting, and tuning SQL. There's also a command reference.

A step-by-step guide of all the tasks that Oracle developers and DBAs need to perform with SQL*Loader. Readable and informative, this reference is a task-oriented learning tool for those already using this utility.

Are you considering an upgrade from FDM to FDMEE? Have you recently upgraded from FDM to FDMEE? Have you recently been hired as an FDMEE administrator and need to expand your knowledge? If so, then The Definitive Guide to Oracle FDMEE is the book you've been looking for! Built within the Oracle Hyperion Workspace, and leveraging ODI as its data engine, FDMEE is the next generation of FDM, and the strategic option for Oracle relating to data integration within the EPM suite. The application features numerous enhancements over the previous generation including expanded mapping capabilities, more robust scripting options, improved scalability, support for Life Cycle Management, and much more. The Definitive Guide to Oracle FDMEE is a practical book that provides not only technical information about the application and its different functionality but which shares fundamental knowledge about how and why the application can and should be used. Written by one of the top FDM experts around - Tony Scalese - chapters have been designed to highlight critical functionality and share real world deployment strategies. These strategies have been developed through years of actual implementation experience. In this Book: - Learn all about System, Application, and User Settings - Explore core metadata items - source systems, source accounting entities, target application registration, import formats, locations and data load rules - Expand your knowledge of mapping with an exploration of advanced mapping options such as format mask, multidimensional and SQL - Follow detailed instructions for configuring an IDE for scripting development - Create new integrations based on leading practice - Implement a security model that meets the needs of your organization - Troubleshoot effectively using application logs and ODI Studio - Understand the Software Development Life Cycle and how LCM can be used to support the SDLC process - Learn how to maintain an application properly over time to ensure performance and stability

Troubleshoot, tune, and optimize your Oracle database efficiently and successfully every time. This book explains how to take full advantage of the revolutionary Oracle Wait Interface to quickly pinpoint--and solve--core problems and bottlenecks, and increase productivity exponentially.

Develop enterprise architect skills by building secure, highly available, and cost-effective solutions with Oracle Functions, Terraform, and the Oracle Cloud VMware Solution Key FeaturesExplore Oracle's Gen 2.0 Cloud infrastructure and its high-performance computing capabilitiesUnderstand hybrid cloud capabilities and learn to migrate apps from on-premises VMware clusters to OCILearn to create Kubernetes clusters and run containerized applications on Oracle's Container EngineBook Description Oracle Cloud Infrastructure (OCI) is a set of complementary cloud services that enables you to build and run a wide range of applications and services in a highly available hosted environment. This book is a fast-paced practical guide that will help you develop the capabilities to leverage OCI services and effectively manage your cloud infrastructure. Oracle Cloud Infrastructure for Solutions Architects begins by helping you get to grips with the fundamentals of Oracle Cloud Infrastructure, and moves on to cover the building blocks of the layers of Infrastructure as a Service (IaaS), such as Identity and Access Management (IAM), compute, storage, network, and database. As you advance, you'll delve into the development aspects of OCI, where you'll learn to build cloud-native applications and perform operations on OCI resources as well as use the CLI, API, and SDK. Finally, you'll explore the capabilities of building an Oracle hybrid cloud infrastructure. By the end of this book, you'll have learned how to leverage the OCI and gained a solid understanding of the persona of an architect as well as a developer's perspective. What you will learnBecome well-versed with the building blocks of OCI Gen 2.0 CloudControl access to your cloud resources using IAM componentsManage and operate various compute instancesTune and configure various storage options for your appsDevelop applications on OCI using OCI Registry (OCIR), Cloud Shell, OCI Container Engine for Kubernetes (OKE), and Service MeshDiscover ways to use object-relational mapping (ORM) to create infrastructure blocks using Terraform codeWho this book is for This book is for cloud architects, cloud developers, and DevSecOps engineers who want to learn how to architect and develop on Oracle Cloud Infrastructure by leveraging a wide range of OCI IAAS capabilities. Working knowledge of Linux, exposure to basic programming, and a basic understanding of networking concepts are needed to get the most out of this book.

Master Oracle Fusion Applications Design and Personalization Deliver highly adaptable business applications that bolster productivity and drive informed decision-making. Oracle Fusion Applications Development and Extensibility Handbook contains best practices, real-world case studies, and technical deep dives. Discover how to manage design- and run-time customizations, extend existing UIs and build new ones, secure your applications, and integrate with other systems. This Oracle Press guide offers complete coverage of the latest cloud and SOA-based features. Explore Oracle Fusion Applications components and architecture Plan, develop, debug, and deploy customizations Extend out-of-the-box functionality with Oracle JDeveloper Modify web applications using Oracle Composer Incorporate Oracle SOA Suite 11g composites Validate code through sandboxes and test environments Secure data using authorization, authentication, and encryption Design and distribute personalized BI reports Automate jobs with Oracle Enterprise Scheduler Change appearance and branding of your applications with the Oracle ADF Skin Editor Extend and customize CRM with Application Composer

* A proven best-seller by the most recognized Oracle expert in the world. * The best Oracle book ever written. It defines what Oracle really is, and why it is so powerful. * Inspired by the thousands of questions Tom has answered on his http://asktom.oracle.com site. It tackles the problems that developers and DBAs struggle with every day. * Provides everything you need to know to program correctly with the database and exploit its feature-set effectively.

This authoritative guide takes the developer through each step of Oracle's CASE approach. The authors show the practical methodological steps and phases of producing software and practical ways that the Designer/2000 tool can support them. There is a crucial need for coverage of this product to help developers use Designer/2000 efficiently and successfully.