Oracle Endeca Information Discovery Best Practices Maximize the powerful capabilities of this self-service enterprise data discovery platform. Master Competitive Analytics with Oracle Endeca Information Discovery reveals how to unlock insights from any type of data, regardless of structure. The first part of the book is a complete technical guide to the product's architecture, components, and implementation. The second part presents a comprehensive collection of business analytics use cases in various industries, including financial services, healthcare, research, manufacturing, retail, consumer packaged goods, and public sector. Step-by-step instructions on implementing some of these use cases are included in this Oracle Press book. Install and manage Oracle Endeca Server Design Oracle Endeca Information Discovery Studio visualizations to facilitate user-driven data exploration and discovery Enable enterprise-driven data exploration with Oracle Endeca Information Discovery Integrator Develop and implement a fraud detection and analysis application Build a healthcare correlation application that integrates claims, patient, and operations analysis; partners; clinical research; and remote monitoring Use an enterprise architecture approach to incrementally establish big data and analytical capabilities

The "WS-BPEL 2.0 Beginner's Guide" is an essential resource for getting started with designing and implementing WS-BPEL 2.0-based business processes using Oracle SOA Suite 12c. The book introduces you to core concepts, guides you through practical activities, and equips you with skills to effectively use WS-BPEL for orchestrating and managing web services. What this Book will help me do Understand the core syntax and semantics of WS-BPEL 2.0 for designing business processes. Learn to utilize the Oracle SOA Suite 12c to build and deploy WS-BPEL executable processes. Develop skills to use WS-BPEL features such as variables, conditions, loops, and error handling for robust implementations. Gain practical insights into asynchronous operations, dynamic invocations, and messaging patterns in WS-BPEL. Master advanced WS-BPEL concepts like human task integration, event handling, and compensation mechanisms. Author(s) Matjaz B. Juric is a renowned author and technical expert with extensive experience in SOA and BPM technologies. He has authored multiple books focusing on enterprise systems and has a background in academic research and teaching. His approachable and thorough writing style ensures that readers are able to grasp complex topics and apply them effectively in their work. Who is it for? This book is directed at software professionals such as architects, designers, and developers who are working on or looking to adopt SOA and BPM solutions within their projects. Readers should have a basic understanding of SOA concepts and web services but do not need prior experience with WS-BPEL. It is suitable for those aiming to learn WS-BPEL 2.0 from scratch to become proficient in designing and implementing business processes.

Build Next-Generation In-Database Predictive Analytics Applications with Oracle Data Miner “If you have an Oracle Database and want to leverage that data to discover new insights, make predictions, and generate actionable insights, this book is a must read for you! In Predictive Analytics Using Oracle Data Miner: Develop & Use Oracle Data Mining Models in Oracle Data Miner, SQL & PL/SQL, Brendan Tierney, Oracle ACE Director and data mining expert, guides you through the basic concepts of data mining and offers step-by-step instructions for solving data-driven problems using SQL Developer’s Oracle Data Mining extension. Brendan takes it full circle by showing you how to deploy advanced analytical methodologies and predictive models immediately into enterprise-wide production environments using the in-database SQL and PL/SQL functionality. Definitely a must read for any Oracle data professional!” --Charlie Berger, Senior Director Product Management, Oracle Data Mining and Advanced Analytics Perform in-database data mining to unlock hidden insights in data. Written by an Oracle ACE Director, Predictive Analytics Using Oracle Data Miner shows you how to use this powerful tool to create and deploy advanced data mining models. Covering topics for the data scientist, Oracle developer, and Oracle database administrator, this Oracle Press guide shows you how to get started with Oracle Data Miner and build Oracle Data Miner models using SQL and PL/SQL packages. You'll get best practices for integrating your Oracle Data Miner models into applications to automate the discovery and distribution of business intelligence predictions throughout the enterprise. Install and configure Oracle Data Miner for Oracle Database 11 g Release 11.2 and Oracle Database 12 c Create Oracle Data Miner projects and workflows Prepare data for data mining Develop data mining models using association rule analysis, classification, clustering, regression, and anomaly detection Use data dictionary views and prepare your data using in-database transformations Build and use data mining models using SQL and PL/SQL packages Migrate your Oracle Data Miner models, integrate them into dashboards and applications, and run them in parallel Build transient data mining models with the Predictive Queries feature in Oracle Database 12 c

A Fully Integrated Study System for OCP Exam 1Z0-060 Prepare for the Oracle Certified Professional Upgrade to Oracle Database 12 c exam with this exclusive Oracle Press guide. Each chapter features step-by-step examples, a certification summary, a two-minute drill, and a self-test to reinforce the topics presented. This authoritative resource helps you pass the exam and also serves as an essential, on-the-job reference. Get complete coverage of the new features of Oracle Database 12 c, including: Oracle Enterprise Manager Database Express and additional tools for database monitoring Multitenant container databases and pluggable databases Auditing, administrative privileges, data redaction, and other Oracle security features Adaptive execution plans, adaptive statistics, and automatic SQL plan management Oracle Recovery Manager backup and recovery improvements Oracle Database Resource Manager and other performance enhancements Oracle Data Pump, SQL*Loader, external tables, and online operations enhancements Improvements to information lifecycle management and storage, including automatic data optimization, in-database archiving, and temporal validity Electronic content includes: 170 practice exam questions with detailed answer explanations

Troubleshooting Oracle Performance, 2nd Edition is your systematic guide to diagnosing and resolving performance problems in database-backed applications involving Oracle's database engine. Christian Antognini brings a decade and a half experience to his topic. His first edition is one of the most well-respected books in its field. This second edition has been rigorously updated to cover the latest developments in Oracle Database 11 g Release 2 through Oracle Database 12 c. 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, 2nd Edition helps by providing a systematic approach to addressing the underlying causes of poor database application performance. The author freely shares his experience while explaining the underlying foundations of how SQL statements are executed by the Oracle database engine. You'll be able to draw a solid foundation of theory and shared experience as you face head-on the performance challenges in your daily work. 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 Systematically identify performance problems Configure the query optimizer to meet performance goals Read and recognize inefficient execution plans Minimize the impact of parsing upon performance Optimize data access, joins, and the physical design of your database Improve performance through parallel processing, materialized views, and result caching Apply SQL tuning techniques such as hints, SQL profiles, stored outlines, and SQL plan baselines Reduce inefficiencies from too much procedural code Who this book is for Troubleshooting Oracle Performance, Second Edition is targeted at application developers and database administrators involved in troubleshooting performance problems in Oracle-based applications.

A Complete Study System for OCA Exam 1Z0-062 Prepare for the Oracle Certified Associate Oracle Database 12 c Installation and Administration exam with this exclusive Oracle Press guide. Each chapter features challenging exercises, a certification summary, a two-minute drill, and a self-test to reinforce the topics presented. This authoritative resource helps you pass the exam and also serves as an essential, on-the-job reference. Get complete coverage of all OCA objectives for exam 1Z0-062, including: Installing and upgrading Oracle Database software Managing the database instance Configuring the Oracle network environment Managing database storage structures Administering user security Managing undo data and data concurrency Implementing Oracle Database auditing Performing database maintenance Managing performance and tuning SQL Managing resources using Oracle Database Resource Manager Automating tasks Moving data Performing backup and recovery Installing Oracle Grid Infrastructure for a standalone server Electronic content includes: 185+ practice exam questions with detailed answers and explanations Test engine that provides custom exams by chapter or by domain

Best Practices for Oracle WebLogic Server 12 c Configuration and Administration Maintain a high-performance enterprise application framework using the detailed information in this authoritative resource. Through expert instruction and real-world examples, Oracle WebLogic Server 12c Administration Handbook fully explains the latest management tools and techniques. Learn how to work from the Oracle WebLogic Server Administration Console or command line, configure servers and clusters, deploy applications, and optimize application performance. Tuning, troubleshooting, and load balancing are thoroughly covered in this Oracle Press guide. Install Oracle WebLogic Server 12 c or perform an upgrade Manage domains, server instances, networks, and virtual hosts Work with the WebLogic Scripting Tool feature and Node Manager Build custom network channels and resource adapters Monitor performance with the WebLogic Diagnostics Framework feature Prioritize requests using Oracle WebLogic Server Work Managers Configure Oracle WebLogic clusters and migrate servers and services Deploy web applications, Enterprise JavaBeans, and Java EE modules Establish security realms and authenticate and authorize users Allocate memory, optimize throughput, and tune the Java Virtual Machine

Oracle Database 12c Release 1 is now supported on Linux on IBM® System z®. This platform offers many advantages to customers who rely upon the IBM mainframe systems to run their businesses. Linux on System z takes advantage of the qualities of service in the System z hardware and in IBM z/VM®, making it a robust industrial strength version of Linux. This provides an excellent platform for hosting Oracle solutions that run in an enterprise. This IBM Redbooks® publication shares experiences that are gained while installing and testing Oracle Database 12c Release 1: Recommendations about how to set up an infrastructure Installing an Oracle Grid Infrastructure Installing Oracle 12C R1 Real Application Clusters (RAC) and creating a RAC Database, including a multitenant database Using the Cloud Control Agent to manage Oracle Database 12c Release 1 Installing Oracle WebLogic Server 12c Upgrading from an Oracle Database from 11gR2 to 12c Release 1

Beginning Oracle SQL is your introduction to the interactive query tools and specific dialect of SQL used with Oracle Database. These tools include SQLPlus and SQL Developer. SQLPlus is the one tool any Oracle developer or database administrator can always count on, and it is widely used in creating scripts to automate routine tasks. SQL Developer is a powerful, graphical environment for developing and debugging queries. Oracle's is possibly the most valuable dialect of SQL from a career standpoint. Oracle's database engine is widely used in corporate environments worldwide. It is also found in many government applications. Oracle SQL implements many features not found in competing products. No developer or DBA working with Oracle can afford to be without knowledge of these features and how they work, because of the performance and expressiveness they bring to the table. Written in an easygoing and example-based style, Beginning Oracle SQL is the book that will get you started down the path to successfully writing SQL statements and getting results from Oracle Database. Takes an example-based approach, with clear and authoritative explanations Introduces both SQL and the query tools used to execute SQL statements Shows how to create tables, populate them with data, and then query that data to generate business results What you'll learn Create database tables and define their relationships. Add data to your tables. Then change and delete that data. Write database queries that generate accurate results. Avoid common traps and pitfalls in writing SQL queries, especially from nulls. Reap the performance and expressiveness of analytic and window functions. Make use of Oracle Database's support for object types. Write recursive queries to query hierarchical data. Who this book is for Beginning Oracle SQL is aimed at developers and database administrators who must write SQL statements to execute against an Oracle database. No prior knowledge of SQL is assumed.

Oracle ADF Enterprise Application Development Made Simple: Second Edition is a comprehensive guide for developers looking to harness the power of Oracle Application Development Framework (ADF) for building enterprise-grade applications. Throughout the book, you'll explore foundational concepts and advanced techniques, enabling you to create efficient, secure, and user-friendly applications tailored to your organization. What this Book will help me do Create ADF applications based on database tables and utilize a wide range of ADF user interface components effectively. Implement development templates and framework classes for efficient and flexible application development. Adapt applications to specific user requirements and expectations, ensuring a customized experience. Plan and accurately estimate the development effort for building substantial ADF enterprise applications. Thoroughly test applications at various levels and secure them by assigning roles for specific functionalities. Author(s) Sten E Vesterli is a seasoned Oracle expert with years of experience in enterprise application development. He specializes in teaching developers how to effectively utilize Oracle technologies, particularly Oracle ADF, to create impactful business solutions. Sten's approach in writing is clear, pragmatic, and solution-oriented, ensuring readers can translate theory into practice seamlessly. Who is it for? This book is ideal for Oracle developers, software engineers, and IT professionals who want to deepen their skills in using Oracle ADF for enterprise application development. If you're familiar with Oracle databases and have a working knowledge of Java, this book will be of particular benefit. Readers aiming to build robust, secure, and user-friendly applications for organizational purposes will find it highly valuable. Whether you're just beginning with ADF or have prior experience, you'll gain skills to develop professional-grade enterprise applications.

Master Oracle Database 12 c PL/SQL Application Development Develop, debug, and administer robust database programs. Filled with detailed examples and expert strategies from an Oracle ACE, Oracle Database 12c PL/SQL Programming explains how to retrieve and process data, write PL/SQL statements, execute effective queries, incorporate PHP and Java, and work with dynamic SQL. Code testing, security, and object-oriented programming techniques are fully covered in this comprehensive Oracle Press guide. Explore new SQL and PL/SQL features in Oracle Database 12 c Build control structures, cursors, and loop statements Work with collections, varrays, tables, and associative array collections Locate and repair errors and employ exception handlers Execute black box, white box, and integration tests Configure and manage stored packages and libraries Handle security with authentication and encryption Use LOBs to store text and multimedia content Write and implement PL/SQL and Java triggers Extend functionality using dynamic SQL statements Understand object types, nested tables, and unnesting queries

Practical Oracle Database Appliance is a hands-on book taking you through the components and implementation of the Oracle Database Appliance. Learn about architecture, installation, configuration, and reconfiguration. Install and configure the Oracle Database Appliance with confidence. Make the right choices between the various configurations in order to realize your performance requirements. Manage and monitor the appliance to meet business requirements. Protect your data through proper backup and recovery procedures. Oracle Database is one of the most relied-up databases in industry. For many years Oracle Database was a software product that had to be installed and configured at no small expense. The Oracle Database Appliance makes Oracle Database into a plug-and-play proposition: Plug the appliance into the wall socket, and turn it on. That's it. You have a running database server. This book takes you through that beginning point and beyond, helping you to realize in your own organization the ease of deployment and management represented by the appliance. Covers the Oracle Database Appliance from architecture through configuration. Provides a technical resource for system- and database administrators. Examines practical use cases for the Oracle Database Appliance. What you'll learn Assemble the Oracle Database Appliance. Understand the architecture and its implications for deployment. Configure network access and protect against intrusion. Monitor and troubleshoot the appliance. Identify and choose options for good performance. Diagnose problems and install patch sets when needed. Who this book is for Practical Oracle Database Appliance is for the Oracle database administrator or system administrator who currently manages, or will be implementing, the Oracle Database Appliance within a small- to medium-size business, or who is using the virtualization feature set to deploy numerous appliances within a large enterprise having many branch locations.

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 11 g 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

Maximize the New and Improved Features of Oracle Database 12 c Written by Master Principle Database Expert, Oracle, and Oracle ACE Robert G. Freeman, this Oracle Press guide describes the myriad new and enhanced capabilities available in the latest Oracle Database release. Inside, you’ll find everything you need to know to get up and running quickly on Oracle Database 12 c. Supported by running commentary from world-renowned Oracle expert Tom Kyte, and with additional contributions by Oracle experts Eric Yen and Scott Black, Oracle Database 12c New Features offers detailed coverage of: Installing Oracle Database 12 c Architectural changes, such as Oracle Multitenant The most current information on upgrading and migrating to Oracle Database 12 c The pre-upgrade information tool and parallel processing for database upgrades Oracle Real Application Clusters new features, such as Oracle Flex Cluster, Oracle Flex Automatic Storage Management, and Oracle Automatic Storage Management Cluster File System Oracle RMAN enhancements, including cross-platform backup and recovery Oracle Data Guard improvements, such as Fast Sync, and Oracle Active Data Guard new features, such as Far Sync SQL, PL/SQL, DML, and DDL new features Improvements to partitioning manageability, performance, and availability Advanced business intelligence and data warehousing capabilities Security enhancements, including privileges analysis, data redaction, and new administrative-level privileges Manageability, performance, and optimization improvements

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.

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.

Linux on System z offers many advantages to customers who rely on the IBM® mainframe systems to run their businesses. Linux on System z makes use of the qualities of service in the System z® hardware and in z/VM®, making it a robust industrial strength Linux. This provides an excellent platform for hosting Oracle solutions that run in your enterprise. This IBM Redbooks® publication is divided into several sections to share the following experiences that are gained while Oracle Database 11gR2 is installed and tested: Setting up Red Hat Enterprise Linux 6 for Oracle Managing an Oracle on Linux on System z environment Provisioning Linux guests using several tools Interested readers include database consultants, installers, administrators, and system programmers. This book is not meant to replace Oracle documentation but to supplement it with our experiences while Oracle products are installed and used. Please note that the additional material referenced in the text is not available from IBM.

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 What you'll learn Master the new consolidation and cloud features in Oracle Database 12c Correctly decide when to consolidate and when to remain standalone Reduce cost by reducing demand for rack space, power, and floor space Streamline administration with Oracle Enterprise Manager 12c Cloud Control Ensure the correct supporting infrastructure for a rock-solid environment Safeguard your new consolidate infrastructure from disaster and data loss Who this book is for Expert Consolidation in Oracle Database 12c is aimed at database administrators involved in consolidation efforts, or who are interested in exploring Oracle Database 12c's strong support for consolidation and cloud computing.

Oracle Exadata Survival Guide is a hands-on guide for busy Oracle database administrators who are migrating their skill sets to Oracle's Exadata database appliance. The book covers the concepts behind Exadata, and the available configurations for features such as smart scans, storage indexes, Smart Flash Cache, hybrid columnar compression, and more. You'll learn about performance metrics and execution plans, and how to optimize SQL running in Oracle's powerful, new environment. The authors also cover migration from other servers. Oracle Exadata is fast becoming the standard for large installations such as those running data warehouse, business intelligence, and large-scale OLTP systems. Exadata is like no other platform, and is new ground even for experienced Oracle database administrators. The Oracle Exadata Survival Guide helps you navigate the ins and outs of this new platform, de-mystifying this amazing appliance and its exceptional performance. The book takes a highly practical approach, not diving too deeply into the details, but giving you just the right depth of information to quickly transfer your skills to Oracle's important new platform. Helps transfer your skills to the platform of the future Covers the important ground without going too deep Takes a practical and hands-on approach to everyday tasks What you'll learn Learn the components and basic architecture of an Exadata machine Reduce data transfer overhead by processing queries in the storage layer Examine and take action on Exadata-specific performance metrics Deploy Hybrid Columnar Compression to reduce storage and I/O needs Create worry-free migrations from existing databases into Exadata Understand and address issues specific to ERP migrations Who this book is for Oracle Exadata Survival Guide is for the busy enterprise Oracle DBA who has suddenly been thrust into the Exadata arena. Readers should have a sound grasp of traditional Oracle database administration, and be prepared to learn new aspects that are specific to the Exadata appliance.

Master Oracle Business Intelligence Discoverer 11g Provide secure, immediate access to critical business information from relational and multidimensional data sources across your organization. Oracle Business Intelligence Discoverer 11g Handbook shows you how to optimize this intuitive ad hoc query, reporting, analysis, and web publishing tool for maximum performance. Real-world examples illustrate the powerful analysis, security, and reporting capabilities. Enable business users at all levels to make faster, more-informed decisions with help from this Oracle Press guide. Configure and manage Oracle Business Intelligence Discoverer 11g Run functional queries using the Workbook Wizard Add sorts, calculations, percentages, totals, and parameters using Oracle Business Intelligence Discoverer Plus Format queries into well-organized reports with graphs, tables, titles, headers, and footers Perform data analysis--statistical, classification, deviation, trend, and aging Use Oracle Business Intelligence Discoverer Viewer 11g to analyze, format, export, e-mail, and print reports Manage integration with Oracle WebLogic Server Refine existing queries using interactive pivoting, drilling, and hyper-drilling Build effective conditions and refine parameters, calculations, sorting, and percentages Manage access and sharing rights, scheduling privileges, and user preferences Build an end user layer and a business area using Oracle Business Intelligence Discoverer Administrator Use Oracle Enterprise Manager's Fusion Middleware Control feature to manage Oracle Business Intelligence Discoverer settings and preferences Implement powerful analytic functions using templates