Expert Oracle GoldenGate is a hands-on guide to creating and managing complex data replication environments using the latest in database replication technology from Oracle. GoldenGate is the future in replication technology from Oracle, and aims to be best-of-breed. GoldenGate supports homogeneous replication between Oracle databases. It supports heterogeneous replication involving other brands such as Microsoft SQL Server and IBM DB2 Universal Server. GoldenGate is high-speed, bidirectional, highly-parallelized, and makes only a light impact on the performance of databases involved in replication. The authors share their experience in the form of tutorials on designing and implementing all types of Oracle GoldenGate environments. You'll learn methods for tuning Oracle GoldenGate performance. You'll discover GoldenGate's utility as a migration and extract, transform, load (ETL) tool. You'll learn to configure highly-available environments involving GoldenGate, Real Application Clusters, and Data Guard. From installation to design to implementation and troubleshooting, Expert Oracle GoldenGate helps you master all aspects of using and applying Oracle GoldenGate as the replication tool of choice in your environment. Explains all aspects of using GoldenGate for replication Covers homogeneous, heterogeneous, and bidirectional replication Shows the use of GoldenGate for data migration and extract, transform, load (ETL) What you'll learn Install Oracle GoldenGate quickly and painlessly Design single- and bi-directional replication solutions Apply GoldenGate to high-availability solutions Troubleshoot and tune GoldenGate for performance Verify data synchronization using GoldenGate Veridata Manage and monitor GoldenGate environments using GoldenGate Director Who this book is for

Expert Oracle GoldenGate is for database professionals who need to master the latest in replication technology from Oracle. It is for the Oracle Database administrator, technical manager, or Oracle developer requiring a solid base of expertise on to implement or manage replication environments with GoldenGate technology. Expert Oracle GoldenGate is an appropriate and timely reference for all users of the GoldenGate software. Table of Contents Introduction Installation Architecture Basic Replication Bi-Directional Replication Heterogeneous Replication Tuning Oracle GoldenGate Monitoring Oracle GoldenGate Oracle GoldenGate Veridata Oracle GoldenGate Director Troubleshooting High Availability & Disaster Recovery Zero Downtime Migrations and Upgrades Best Practices

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

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.

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 Database 11g RAC on Linux provides full-life-cycle guidance on implementing Oracle Real Application Clusters in a Linux environment. Real Application Clusters, commonly abbreviated as RAC, is Oracle's industry-leading architecture for scalable and fault-tolerant databases. RAC allows you to scale up and down by simply adding and subtracting inexpensive Linux servers. Redundancy provided by those multiple, inexpensive servers is the basis for the failover and other fault-tolerance features that RAC provides. Written by authors well-known for their talent with RAC, Pro Oracle Database 11g RAC on Linux gives you a rock-solid and technically flawless foundation on which to build your RAC-management skills. Authors Julian Dyke and Steve Shaw share their hard-won experience in building RAC clusters, showing you how to build for success using the very latest Oracle technologies, such as Automatic Storage Management (ASM) and Oracle Clusterware. You'll learn to troubleshoot performance and other problems. You'll even learn how to correctly deploy RAC in a virtual-machine environment based upon Oracle VM, which is the only virtualization solution supported by Oracle Corporation.RAC is a complex and powerful technology. It demands expertise in its deployment. You can't just wing it in creating a RAC solution. Julian and Steve have earned the right to term themselves expert-in Pro Oracle Database 11g RAC on Linux, they offer a rigorous and technically-correct treatment of RAC that helps you build a solid foundation of expertise and achieve success. * Rigorous and technically accurate content* Complete coverage of RAC, from planning to implementation to rollout to ongoing maintenance and troubleshooting* Up-to-date with the very latest RAC featuresWhat you'll learn* Plan the architecture for a successful RAC installation* Implement failover and other fault-tolerant features* Scale RAC clusters up and down as needed to achieve performance targets* Consolidate RAC clusters using Oraclea s virtualization solution* Manage RAC proactively so as to sleep well at night* Troubleshoot and solve performance and availability problemsWho this book is for Pro Oracle Database 11g RAC on Linux is written for Oracle Database Administrators who want to step up their skills to be equal to the task of managing Real Application Clusters.

Beginning Oracle SQL is your introduction to the interactive query tools and specific dialect of SQL used with Oracle Database. The book is a revision of the classic Mastering Oracle SQL and SQL*Plus by Lex de Haan, and has been updated to coverdevelopments in Oracle's version of the SQL query language. 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 How to create database tables and define their relationships How to add data to your tables, thenchange and delete that data How to write database queries that generate accurate results How to avoid common traps and pitfalls in writing SQL queries How to take advantage of advanced Oracle SQL features such as support for hierarchical queries, analytic and window functions, flashback to a given point in time, and more How to get a handle on Oracle database's support for object types in the database Who this book is for

This book 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. Table of Contents Relational Database Systems and Oracle Introduction to SQL, AQL*Plus, and SQL Developer Data Definition, Part I Retrieval: The Basics Retrieval: Functions Data Manipulation Data Definition, Part II Retrieval: Multiple Tables and Aggregation Retrieval: Some Advanced Features Views Writing and Automating SQL*Plus Scripts Object-Relational Features

Secrets of the Oracle Database is the definitive guide to undocumented and partially-documented features of the Oracle Database server. Covering useful but little-known features from Oracle Database 9through Oracle Database 11, this book will improve your efficiency as an Oracle database administrator or developer. Norbert Debes shines the light of day on features that help you master more difficult administrative, tuning, and troubleshooting tasks than you ever thought possible.

Finally, in one place, you have at your fingertips knowledge that previously had to be acquired through years of experience and word of mouth through knowing the right people. What Norbert writes is accurate, well-tested, well-illustrated by clear examples, and sure to improve your ability to make an impact on your day-to-day work with Oracle. Table of Contents Partially Documented Parameters Hidden Initialization Parameters Introduction to Data Dictionary Base Tables IND$, V$OBJECT_USAGE, and Index Monitoring Event 10027 and Deadlock Diagnosis Event 10046 and Extended SQL Trace Event 10053 and the Cost Based Optimizer Event 10079 and Oracle Net Packet Contents Introduction to X$ Fixed Tables X$BH and Latch Contention X$KSLED and Enhanced Session Wait Data X$KFFXP and ASM Metadata ALTER SESSION/SYSTEM SET EVENTS ALTER SESSION SET CURRENT_SCHEMA ALTER USER IDENTIFIED BY VALUES SELECT FOR UPDATE SKIP LOCKED DBMS_BACKUP_RESTORE DBMS_IJOB DBMS_SCHEDULER DBMS_SYSTEM DBMS_UTILITY Perl DBI and DBD:: Oracle Application Instrumentation and End-to-End Tracing Extended SQL Trace File Format Reference Statspack Integrating Extended SQL Trace and AWR ESQLTRCPROF Extended SQL Trace Profiler The MERITS Performance Optimization Method TNS Listener IP Address Binding and IP=FIRST TNS Listener TCP/IP Valid Node Checking Local Naming Parameter ENABLE=BROKEN Default Host Name in Oracle Net Configurations Session Disconnection, Load Rebalancing, and TAF Removing the RAC Option Without Reinstalling OERR Recovery Manager Pipe Interface ORADEBUG SQL*Plus Command

Application Express, or APEX, is one of the most innovative products to come out of Oracle in years. APEX is an application development framework for developing databasebacked applications. It's easy enough to get started in that power users can quit storing data in random spreadsheets and instead centralize their data in the powerful Oracle database, all without developer help. Developers aren't left out, however. Those who choose to do socan go deep and leverage the full power and flexibility of Oracle's database engine.

Getting started with APEX is easy; learning how to take full advantage of APEX is the problem. It was the problem, that is, until this book came along. In Pro Oracle Application Express, authors John Scott and Scott Spendolini open the hood of APEX and expose the full power behind its easytouse GUI. They show you what you need to know to produce powerful, professionally polished applicationssuch as user-authentication models, approaches to layout and navigation, how to integrate Ajax, how to deal with localization issues such as time zones and translations, how to customize the look and feel of an APEX web site, and much, much more.

The authors are wellqualified to write on APEX. John Scott runs ShellPrompt, a hosting service that handles many large-scale APEX applications, some of which he is paid to develop. John is a hardcore APEX developer. His co-author, Scott Spendolini, is one of the original creators of APEX. Both John and Scott now base their full-time careers on developing APEX applications. Pro Oracle Application Express is your opportunity to learn APEX from the very best.

This brilliant new book gives readers the lowdown on the most important new features in the latest release of Oracle's flagship database product. Authors Sam Alapati and Charles Kim are experienced database administrators who go beyond regurgitating Oracle's new feature documentation to report on "what's new that really matters." Readers whose careers are bound up in Oracle's database system need to know what's new. Sam and Charles deliver with a rigor and candor that will help readers choose the best of the new features to apply in their own environments.

Oracle is the number one database engine in use today. The fact that it is the choice of military organizations and agencies around the world is part of the company s legacy and is evident in the product. Oracle has more security-related functions, products, and tools than almost any other database engine. Unfortunately, the fact that these capabilities exist does not mean that they are used correctly or even used at all. In fact, most users are familiar with less than twenty percent of the security mechanisms within Oracle.

Written by Ron Ben Natan, one of the most respected and knowledgeable database security experts in the world, HOWTO Secure and Audit Oracle 10g and 11g shows readers how to navigate the options, select the right tools and avoid common pitfalls. The text is structured as HOWTOs addressing each security function in the context of Oracle 11g and Oracle 10g. Among a long list of HOWTOs, readers will learn to:

• Choose configuration settings that make it harder to gain unauthorized access
• Understand when and how to encrypt data-at-rest and data-in-transit and how to implement strong authentication
• Use and manage audit trails and advanced techniques for auditing
• Assess risks that may exist and determine how to address them
• Make use of advanced tools and options such as Advanced Security Options, Virtual Private Database, Audit Vault, and Database Vault

The text also provides an overview of cryptography, covering encryption and digital signatures and shows readers how Oracle Wallet Manager and orapki can be used to generate and manage certificates and other secrets. While the book s seventeen chapters follow a logical order of implementation, each HOWTO can be referenced independently to meet a user s immediate needs. Providing authoritative and succinct instructions highlighted by examples, this ultimate guide to security best practices for Oracle bridges the gap between those who install and configure security features and those who secure and audit them.

It's sometimes said that the true job of an Oracle database administrator can be summed up in one, essential skill: to be able to recover your database.

There's much wisdom in that statement. Of all the things you are responsible for as a database administrator, nothing is more important than the data itself. Like it or not, the fearsome responsibility of protecting your organizations 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.

Scared? You should be. But theres help. You are not alone. Oracle experts Darl Kuhn, Sam Alapati, and Arup Nanda have come together in this book to show you the power of Recovery Manager, or RMAN, which is Oracles backup and recovery tool of choice. "RMAN Recipes for Oracle Database 11g" helps you take advantage of all that RMAN has to offer by providing easy-to-understand solutions to business-critical backup and recovery operations. This handy guide

Demystifies the steps required to protect your business data Provides ready-made and step-by-step solutions to simple and complex backup, restore, and recovery operations Is task-oriented, making it easy for you to find the solution to pressing backup and recovery problems Respects your time by providing example-based solutions, not endless reading material

When the pressure's on, you dont have time for long discussions of theory. This book 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.
What you'll learn

Oracle Database experts Darl Kuhn, Sam Alapati, and Arup Nanda show you how to

Reliablyback up and recover your database using Oracles Recovery Manager. Utilize New Oracle Database 11g features such as the Data Recovery Advisor. Let Oracle Database manage your backup files via the Flash Recovery Area. Automate backup and recovery tasks by writing scripts. Troubleshoot RMAN problems and optimize RMAN performance. Interface with a Media Management Layer to manage your backup tape library. Recover from the loss of a control file, loss of an online redo log, and other (hopefully!) unusual situations.

Who is this book for?

Oracle database administrators responsible for database backup and recovery operations.

This informative field guide provides scripts, notes, guidelines, and references to guide readers safely through the crucial day-to-day administration tasks that fall within their jurisdiction. This book contains tips, techniques, and guidance for administering the highly complex Oracle E-Business Suite--all in an easy reading and quick-to-navigate format.

This book offers Oracle DBAs training appropriate for understanding and handling PeopleSoft technology. DBAs will learn a range of techniques, including: indexing, implementing DDL, managing tablespaces, and fixing low-performing SQL queries. Written by a field expert, this book answers common questions and misunderstandings that arise from use of PeopleSoft on an Oracle database. The result is a highly effective training manual for any Oracle DBA charged with the maintenance of a PeopleSoft system.

PL/SQL is the procedural programming language of choice in the Oracle database. It is completely integrated with SQL and is the most fully optimized, highest performance language for database transaction processing. This book is about effective techniques to solve problems using PL/SQL.

This book teaches you all of the core concepts behind using the database, shows you the tools and techniques you need to master, and gives you practical examples of programming Oracle. teaching you Oracle technology. need to use Oracle databases with confidence. Oracle is the world's leading relational database. used properly, is the fastest and most scaleable database on which to build enterprise scale applications. an overnight job. this book have that experience. application or administering the database and can guarantee you that the techniques taught in this book are proven and have led them through many successful implementations.

* Presents an innovative, philosophical approach to Oracle database administration, and shows how to think about the whole complex problem of performance tuning, how to break it down, how to root out the cause of performance bottlenecks. *Covers all practical aspects of Oracle performance tuning. * Filled with hands-on lessons and accounts. * Teaches an innovative and effective "Physician to Magician" approach, showing how to understand the problem, uncover the root cause, and choose and implement the most effective solution.

Oracle9i PL/SQL: A Developers Guide is intended for both intermediate-level Oracle developers who are designing or coding applications in SQL and PL/SQL and for advanced PL/SQL programmers who need to learn new PL/SQL 9ifeatures. In addition to providing developers with detailed coverage of the PL/SQL 9i language itself, author -->Bulusu Lakshman--> covers the techniques of using PL/SQL 9i for server-side applications and provides the methodology for implementing robust applications. Lakshman also mentors developers in implementing effective techniques for real-world and code-centric Oracle applications that, in the long run, will save them time and energy.

Oracle9i PL/SQL: A Developers Guide is a solid source for the development of Oracle9i PL/SQL applications. Developers incorporating these technologies into new applications and those migrating from earlier versions will both find Lakshman's expert treatment of the topic beneficial.

Start developing with Oracle SQL. This book is a one-stop introduction to everything you need to know about getting started developing an Oracle Database. You'll learn about foundational concepts, setting up a simple schema, adding data, reading data from the database, and making changes. No experience with databases is required to get started. Examples in the book are built around Oracle Live SQL, a freely available, online sandbox for practicing and experimenting with SQL statements, and Oracle Express Edition, a free version of Oracle Database that is available for download. A marquee feature of Beginning Oracle SQL for Oracle Database 18c is the small chapter size. Content is divided into easily digestible chunks that can be read and practiced in very short intervals of time, making this the ideal book for a busy professional to learn from. Even just a 15-20 minute block of free time can be put to good use. Author Ben Brumm begins by helping you understand what a database is, and getting you set up with a sandbox in which to practice the SQL that you are learning. From there, easily digestible chapters cover, point-by-point, the different aspects of writing queries to get data out of a database. You'll also learn about creating tables and getting data into the database. Crucial topics such as working with nulls and writing analytic queries are given the attention they deserve, helping you to avoid pitfalls when writing queries for production use. What You'll Learn Create, update, and delete tables in an Oracle database Add, update, delete data from those database tables Query and view data stored in your database Manipulate and transform data using in-built database functions and features Correctly choose when to use Oracle-specific syntax and features Who This Book Is For Those new to Oracle who are planning to develop software using Oracle as the back-end data store. The book is also for those who are getting started in software development and realize they need to learn some kind of database language. Those who are learning software development on the side of their normal job, or learning it as a college student, who are ready to learn what a database is and how to use it also will find this book useful.

Agile Oracle Application Express shows how skilled, motivated, and self-organizing developers can realize extraordinary commercial benefits from Oracle Application Express. The secret is to couple Application Express with an agile software development approach. This book leads the way.

Oracle Application Express is well-suited to agile processes, with its support for rapid prototyping and team development. Application Express supports a gamut of enabling technologies such as SQL, HTML, CSS, JavaScript, and more that enable you to deliver any type of web application to meet your development needs. Agile Oracle Application Express helps you take the feature set of Application Express and marry it with the processes of agile development to iteratively design, create, and deliver quality applications on time and within budget. What you'll learn Discover how Application Express features compliment agile development Apply principles of agile software development to Application Express projects Deliver working code to your clients quickly Meet cost, schedule, and quality targets Increase productivity through team-based techniques Create the right amount and size of governance for any Application Express project Who this book is for

Agile Oracle Application Express is a must-read for highly skilled and highly motivated Application Express (APEX) developers who are comfortable taking responsibility within a self-organizing team environment. These APEX developers want to raise themselves to a higher level of organizational maturity that will position them to improve on APEX's already highly productive software development platform. Table of Contents Agile Software Development Agile and APEX Core APEXvs. Enhanced APEX Supporting Technologies Project Management Team Development Rules and Guidelines Documentation Quality Assurance Summary

This book highlights the practical aspects of using Oracle Essbase and Oracle Business Intelligence Enterprise Edition (OBIEE) as a comprehensive BI solution. It explains the key steps involved in Oracle Essbase and OBIEE implementations. Using case studies, the book covers Oracle Essbase for analytical BI and data integration, using OBIEE for operational BI including presentation services and BI Publisher for real-time reporting services, Self-service BI- in terms of VLDB, scalability, high performance, stability, long-lasting and ease of use that saves time, effort, and costs, while maximizing ROI.

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.

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

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.