Expert PL/SQL Practices is a book of collected wisdom on PL/SQL programming from some of the best and the brightest in the field. Each chapter is a deep-dive into a specific problem, technology, or feature set that you'll face as a PL/SQL programmer. Each author has chosen their topic out of the strong belief that what they share can make a positive difference in the quality and scalability of code that you write. The path to mastery begins with syntax and the mechanics of writing statements to make things happen. If you've reached that point with PL/SQL, then let the authors of Expert PL/SQL Practices show you how to combine syntax and mechanics with features and techniques to really make the language sing. You'll learn to do more with less effort, to write code that scales and performs well, and to eliminate and avoid defects. These authors are passionate about PL/SQL and the power it places at your disposal. They want you to succeed, to know all that PL/SQL can offer. Let Expert PL/SQL Practices open your eyes to the full power of Oracle's world-class language for the database engine. Goes beyond the manual to cover good techniques and best practices Delivers knowledge usually gained only by hard experience Covers the functionality that distinguishes PL/SQLas apowerful andscalable programming language for deploying logic inside the database engine What you'll learn Learn when PL/SQL is best used, and when to avoid it Move data efficiently using bulk SQL operations Write code that scalesthrough pipelining, parallelism, and profiling Choose the right PL/SQL cursor type for any given application Reduce coding errors through sound development practices such as unit-testing Create and execute SQL and PL/SQL dynamically at runtime Who this book is for

Expert PL/SQL Practices is for PL/SQL developers who want to develop deep expertise in key aspects of the language and its use in database programming. Any developer writing code against Oracle's class-leading database engine will find value from the collected wisdom in this book. Some knowledge of PL/SQL is assumed. Readers should at least be past the beginning stage with the language. Table of Contents Do Not Use Dynamic SQL: Handling the Unknown PL/SQL and Parallel Processing Warnings and Conditional Compilation PL/SQL Unit Testing Bulk SQL Operations Know Your Code Contract-Oriented Programming PL/SQL from SQL Choosing the Right Cursor PL/SQL Programming in the Large Evolutionary Data Modeling Profiling for Performance Coding Conventions and Error Handling Dependencies and Invalidations

Pro Oracle Application Express 4 is your key to mastering one of the most innovative products to come out of Oracle in years. Application Express, termed "APEX" for short, is fast becoming one of the easiest and most widely-used of tools for creating enterprise-level applications that run against an Oracle database. APEX is easy enough for power users to create ad-hoc applications atop something more reliable than a spreadsheet. Yet APEX is powerful and extensible enough to enable fully-scalable, enterprise-level applications that are accessed by thousands of users. Authors Tim Fox, John Scott, and Scott Spendolini take you to the professional level in developing for Application Express. They show how to handle user authentication in enterprise environments and how to extend APEX by writing components based upon Oracle's new plug-in architecture. You'll learn to deal with localization issues such as time zones and translations, and to customize the look and feel of an APEX website to blend in with your corporate branding strategy. The authors also cover web service development, performance and scalability, and the production issues that you encounter in enterprise-level deployments. Many years of experience in solving the hard problems are coalesced in this book to help you, the reader, take advantage of all that APEX has to offer. Focuses on high-end, enterprise-level development Covers new features such as plug-ins and Websheets Introduces the new interface released with APEX 4.0 What you'll learn Design APEX solutions that conform to your corporate look and feel Create compelling reports, charts, navigation, and layout Create your own components based upon APEX's new plug-in architecture Authenticate users and manage their access to your applications Develop and deploy web services using APEX Scale APEX applications to thousands of users Secure your applications and data from intrusion Who this book is for

Pro Oracle Application Express 4 is aimed at application developers looking for a rapid application development environment harnessing the full power of the Oracle Database, including SQL and PL/SQL. The book meets the needs of developers working at both the departmental and the enterprise level, with an emphasis on high-end, enterprise deployment. Table of Contents Development Best Practices Authentication and User Management Conditions and Authorization Schemes Data Security Navigation and Layout Reports and Charts Dynamic Actions: Ajax and JavaScript WebSheets Reporting and Printing Themes and Templates Localization Issues Plugins Web Service Development Performance and Scalability Production Issues APEX Dictionary

Expert Oracle Application Express brings you groundbreaking insights into developing with Oracle's enterprise-level, rapid-development tool from some of the best practitioners in the field today. 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. The 13 authors of Expert Oracle Application Express build their careers around APEX. They know what it takes to make the product singdeveloping 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 scalability, globalization, configuration and lifecycle management, and more. You'll learn about debugging and performance, deep secrets to customizing your application user interface, how to secure applications from intrusion, and about deploying globally in multiple languages. Expert Oracle Application Express is truly a book that will move you and your skillset a big step towards the apex of Application Express development. Presents best-practices and development insights from leading experts in the field Addresses globalization, scalability, security, and other concerns of enterprise-level development Shows how to customize APEX for your own application needs What you'll learn Solve tough problems in scalability in order to serve thousands of users Design applications to sidestep performance problems and easily scale upwards Deploy applications globally while respecting linguistic and cultural differences Customize applications by exploiting APEX's roots in PL/SQL Reduce the stress of managing application lifecycle and configuration Secure outwardly-facing applications and their data from intrusion Who this book is for

Expert Oracle Application Express is aimed at APEX developers who seek the deepest possible knowledge of Oracle Application Express and how to develop with it. Readers should know and be proficient with APEX, and be prepared to expend some mental energy in absorbing the high-end material in this book. Table of Contents OHS, EPG, and APEX Listener Compared Oracle APEX 4.0 Charts Inside Out Tabular Forms Team Development Globalization Debugging Dynamic Actions Security Lifecycle Management Working with APEX Collections Plug-Ins Architecture Advanced Interactive Reporting

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

Throughout history, advances in technology have come in spurts. A single great idea can often spur rapid change as the idea takes hold and is propagated, often in totally unexpected directions. Exadata embodies such a change in how we think about and manage relational databases. The key change lies in the concept of offloading SQL processing to the storage layer. That concept is a huge win, and its implementation in the form of Exadata is truly a game changer. Expert Oracle Exadata will give you a look under the covers at how the combination of hardware and software that comprise Exadata actually work. Authors Kerry Osborne, Randy Johnson, and Tanel Poder share their real-world experience, gained through multiple Exadata implementations with the goal of opening up the internals of the Exadata platform. 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 benefitfrom the advantages that the platform provides. Changes the wayyou think about managing SQL performance and processing Provides a roadmap to laying out the Exadata platform to best support your existing systems Dives deeply into the internals, removing the black box mystique and showing how Exadata actually works What you'll learn Configure Exadata from the ground up Optimize for mixed OLTP/DW workloads Migrate large data sets from existing systems Connect Exadata to external systems Support consolidation strategies using the Resource Manager Configure high-availability features of Exadata, including Real Application Clusters (RAC) and automatic storage management (ASM) Apply tuning strategies utilizing the unique features of Exadata Who this book is for

Expert Oracle Exadata is for database administrators and developers who want to understand what makes Exadata unique so that they can take advantage of all the platform has to offer. It is also for anyone who needs to plan and execute migrations of systems to the Exadata platform. Finally, the book will be invaluable to those who support and maintain such systems. Table of Contents What Is Exadata? Offloading / Smart Scan Hybrid Columnar Compression Storage Indexes Exadata Smart Flash Cache Exadata Parallel Operations Resource Management Configuring Exadata Recovering Exadata Exadata Wait Events Understanding Exadata Performance Metrics Monitoring Exadata Performance Migrating to Exadata Storage Layout Compute Node Layout Unlearning Some Things We Thought We Knew

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.

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.

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.

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.

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.

* 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.

This book is the definitive reference on PL/SQL, considered throughout the database community to be the best Oracle programming book available. Like its predecessors, this 6th edition of Oracle PL/SQL Programming covers language fundamentals, advanced coding techniques, and best practices for using Oracle's powerful procedural language. Thoroughly updated for Oracle Database 12c, this edition reveals new PL/SQL features and provides extensive code samples, ranging from simple examples to complex and complete applications, in the book and on the companion website. It's an indispensable reference for both novices and experienced Oracle programmers.

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.