Oracle Forensics will delve deep in the guts of undocumented Oracle features and show where to find the digital footprints left by an attacker. It will show how to: 1) Hunt for digital evidence by dissecting the Redo Logs and locating dropped and deleted objects; 2) Study disparate log files and audit trails to build accurate timelines of events; 3) Work out how an attacker broke in and how to keep them out; 4) Perform a forensic analysis using scenarios based upon real world incidents

Fully revised and expanded for the latest database release, this authoritative guide provides thorough coverage of Oracle Database 11g in the most comprehensive reference available. Starting by establishing critical database concepts and with in-depth details on all the new features, this powerhouse resource provides an overview of database architecture and Oracle Grid Computing technology. The Complete Reference covers SQL, SQL Plus, PL/SQL, dynamic PL/SQL, object-oriented features, and Java p rogramming in the Oracle environment. The book includes valuable database administration and application development techniques, plus an alphabetical reference covering major Oracle commands, keywords, features, and functions, with cross-referencing of topics. All code from the book will be available for download.

Open the door to a career as an Oracle database administrator as you learn to plan for and install the Oracle Database software. Then learn the rudiments of database administration from longtime Oracle expert Iggy Fernandez. Take advantage of the high demand for Oracle expertise and use Beginning Oracle Database 11g Administration to launch you on the right track to Oracle DBA career success.

Here is the first book to tie together the strategies, best practices, and practical approaches to implementing Enterprise Content Management (ECM). You will learn how to gain control of disparate enterprise content and harness intellectual property. The book presents a new, broad approach to ECM that encompasses multiple repositories, corporate-wide document management policies, and true information security.

Oracle Workflow allows Oracle E-Business Suite users to automate and continuously improve business processes, routing information of any type--according to easily modifiable business rules--to people inside or outside an organization. By using Oracle Workflow, businesses can get the most out of their multimillion dollar investments in Oracle E-Business Suite. Oracle Workflow Handbook begins by covering the setup of both the Oracle Workflow client and server. Using sample business issues and cas e studies, the book walks you through the implementation, development, and administration of Oracle Workflow including advice on defining best practices, debugging, and troubleshooting.

This hands-on guide shows Oracle administrators how to build a robust Grid Control infrastructure through practical, jargon-free instruction and real-world examples. This infrastructure allows you to efficiently manage all of your systems. You will learn to install, configure, and maintain both Oracle and non-Oracle Grid Control products and optimize system availability and performance.

Providing the best solutions to Oracle customers, this comprehensive manual answers some of SQL's most exciting challenges. Covering all the elements of an Oracle query-including new features from Oracle versions 9i, 10g, and 11g-this guide will help information technology managers and programmers alike to gain new insight into complex queries, advanced aggregation, and analytics techniques. Introducing Model and XML as new ways to retrieve data out of the database, this sourcebook culminates as a perfect companion for advanced programmers and Oracle experts.

The product of interviews with hundreds of Oracle professionals, this thorough guidebook provides useful insight into what characteristics make a good database administrator, offering helpful techniques to use while interviewing candidates for an Oracle DBA position. By using Oracle job interview questions that only an experienced person would be familiar with, employers can employ this incredible collection to ensure that their interviewer asks the right questions and hires the best-qualified D BA or developer available. A full set of Oracle job interview questions and a complete method for accurately assessing the technical abilities of Oracle job candidates are provided.

Targeted toward experienced Oracle professionals who need to perform powerful system-wide operating system on their Oracle databases, this definitive guide includes details on all of the Oracle utilities, including an experts-only section on undocumented utilities, plus the Linux/UNIX utilities, Oracle command-line utilities, and the all-important DBA package utilities. Approaching Oracle Utilities from a functional perspective, this guide adds value by explaining the "why" and "how" for the use of all Oracle Utilities. Additionally, the book also covers Oracle tuning utilities and all areas of Oracle database administration, including ADDM and the SQL tuning advisors and the traditional command-line tuning utilities, as well as secrets for database migration, and detailed tips for using Oracle OS utilities.

Covering all areas of Oracle Grid computing, this guide is indispensable for any Oracle DBA who is charged with configuring and implementing Oracle 11g Grid with server blades. This comprehensive manual presents a complete method for the installation, configuration and design of Oracle Grid and 11g RAC. It supplies expert internals of shared disk technology, raw devices and RAID, and exposes the internal configuration methods for server blades. Also demonstrated is the use of Oracle Grid using t he Enterprise Manager Grid control utility.

Beginning Database Programming with Oracle Application Express shows novice database developers and power users how to master Application Express to build effective web-based Oracle database applications. The author will provide hands-on, step-by-step guideance on the complete development process, through creating, customizing, and extending the application. The book gets quickly off the ground by showing how to build a simple application; it then gets into the details for extending the applic ation; reporting and charting; themes and templates, and security. The author also shows how to use packaged applications, as well as work with multiple applications. He concludes the book by providing guidance on data migration and integration with the Oracle environment.

This Oracle Press certification exam guide offers detailed coverage of all of the official exam objectives on the Oracle Certified Professional Administration II exam, including installation, configuration, application tuning, database management, backup and recovery, security, and more. Real-world examples, practice questions, and chapter summaries help certification candidates learn the material. The CD-ROM contains two practice exams and an electronic copy of the book.

This fully revised beginner's guide covers the fundamental concepts of Oracle Database 11g. Through self-paced tutorials, you will learn about database essentials, the role of the administrator, high availability, and large database features. An in-depth introduction to SQL and PL/SQL is also included. Oracle Database 11g: A Beginner's Guide walks you, step-by-step, through database setup, administration, programming, and backup and recovery. A configurable sample database available online prov ides additional support for projects and examples.

A comprehensive handbook for Oracle database administrators (DBAs) using the latest release of the Oracle Database (Oracle Database 11g). All key aspects of database administration are covered, including backup and recovery, day-to-day administration and monitoring, performance tuning, and more. This is the one book to have on your desk as a continual reference. Refer to it frequently. It'll help you get the job done. Also offers primers on Linux/Unix, data modeling, SQL, and PL/SQL.

An oracle on Oracle, Byron Pearce takes the complexity out of the Oracle 11g database and helps readers work effectively in the Oracle 11g environment Begins with a friendly introduction to the basics of the Oracle database and then progresses to implementing Oracle in real-world situations, creating and protecting an Oracle database, and troubleshooting Covers the new features of Oracle 11g, including automatic memory tuning, fully automatic SQL tuning, automatic storage load balancing, and aut omatic diagnostic repository Devotes entire chapters to the oft-forgotten but critical topic of common mistakes that occur when installing Oracle, designing a database, and writing SQL code.

This first book on the market covering Oracle CRM On Demand reporting delivers comprehensive feature and function information while providing guidance and strategies for report design and development. Real-world case studies, formatting tips, and sample formulas are included throughout. The book will be invaluable to those new to Oracle CRM On Demand as well as seasoned users in need of advanced reporting techniques.

Tackling some of the more than 500 updates to Oracle 11g that are intended to automate the inherent complexity of the Oracle engine, this guidebook explores all of the new features from the perspective of a working Oracle professional. This valuable resource examines only the important Oracle 11g enhancements and includes expert discussion about each new feature, why the new feature is important, and how to use the new 11g functionality. Written by working Oracle experts for both current DBAs an d Oracle developers and programmers, this flagship book on Oracle 11g explores language and PL/SQL, DBA features, RAC and enhancements, performance features, new security features, and Enterprise Manager.

Start developing applications with Oracle PL/SQL-fast! This integrated book-and-Web learning solution teaches all the Oracle PL/SQL skills you need, hands on, through real-world labs, extensive examples, exercises, projects, and a complete Web-based training site. Oracle PL/SQL by Example, Third Edition covers Oracle 10G and all the fundamentals: Master PL/SQL syntax, iterative and conditional control, scoping, anchored datatypes, cursors, triggers, security, tables, procedures, functions, packa ges and Oracle-supplied packages-plus powerful new techniques for working with exceptions, cursors, collections, and records. Your free Web-based training module includes a Virtual Study Lounge where you can interact with other learners, work on new projects, and get updates! Totally integrated with a FREE, state-of-the-art Oracle 10G learning Web site! Every Prentice Hall Oracle Interactive Workbook is fully integrated with its own exclusive Web site, giving you all this and more.

Start developing applications with Oracle PL/SQL-fast! This integrated book-and-Web learning solution teaches all the Oracle PL/SQL skills you need, hands on, through real-world labs, extensive examples, exercises, projects, and a complete Web-based training site. Oracle PL/SQL by Example, Third Edition covers Oracle 10G and all the fundamentals: Master PL/SQL syntax, iterative and conditional control, scoping, anchored datatypes, cursors, triggers, security, tables, procedures, functions, packa ges and Oracle-supplied packages-plus powerful new techniques for working with exceptions, cursors, collections, and records. Your free Web-based training module includes a Virtual Study Lounge where you can interact with other learners, work on new projects, and get updates! Totally integrated with a FREE, state-of-the-art Oracle 10G learning Web site! Every Prentice Hall Oracle Interactive Workbook is fully integrated with its own exclusive Web site, giving you all this and more.

If you're developing applications that access Oracle databases, you can save time and work by having SQL do more of the data handling for you: This new book shows you how. It teaches you how to create effective SQL queries to extract and update the data in an Oracle database. It teaches you how to design and implement a database, giving you insight into performance and security issues. It teaches you how to use PL/SQL to take advantage of powerful features like stored procedures, functions, and triggers. In short, it teaches you to create the kind of efficient database applications that make you a more effective and valuable developer.

PL/SQL is Oracles proprietary variant of the industry standard Structured Query Language (SQL.) In order to effectively develop or maintain - or even use - an Oracle database you need to have a good working knowledge of PL/SQL. Many of the current PL/SQL titles are overkill for those who need to use PL/SQL but have no intention of becoming professional DBAs. This book teaches you what you really need to know, without getting bogged down by what you don't. Sams Teach Yourself Oracle PL/SQL in 10 Minutes is a tutorial-based book, organized into a series of short, easy-to-follow lessons. Instead of dwelling on database theory and relational design, this book takes a very hands-on approach to solving the needs of the majority of SQL users who simply need to interact with data. It uses the format of the author's bestselling Sams Teach Yourself SQL in 10 Minutes =, which has proven to be highly effective and popular.

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.

A Fully Integrated Study System for OCA Exam 1Z0-052 Prepare for the Oracle Certified Associate Oracle Database 11 Administration I exam with help from this exclusive Oracle Press guide. In each chapter, you'll find challenging exercises, practice questions, a two-minute drill, and a chapter summary to highlight what you've learned. This authoritative guide will help you pass the test and serve as your essential on-the-job reference. Get complete coverage of all OCA objectives for exam 1Z0-052, including: Database architecture Creating an Oracle Database Managing the Oracle instance Configuring and managing the Oracle network Managing database storage structures Administering user security Managing schema objects, data and concurrency, and undo data Implementing Oracle Database security Database maintenance and performance management Backup and recovery Moving data Intelligent infrastructure enhancements On the CD-ROM: One full practice exam that simulates the actual OCA exam Detailed answers and explanations Score report performance assessment tool Complete electronic book Bonus exam available free with online registration.

A Fully Integrated Study System for OCA Exam 1Z0-052 Prepare for the Oracle Certified Associate Oracle Database 11 Administration I exam with help from this exclusive Oracle Press guide. In each chapter, you'll find challenging exercises, practice questions, a two-minute drill, and a chapter summary to highlight what you've learned. This authoritative guide will help you pass the test and serve as your essential on-the-job reference. Get complete coverage of all OCA objectives for exam 1Z0-052, including: Database architecture Creating an Oracle Database Managing the Oracle instance Configuring and managing the Oracle network Managing database storage structures Administering user security Managing schema objects, data and concurrency, and undo data Implementing Oracle Database security Database maintenance and performance management Backup and recovery Moving data Intelligent infrastructure enhancements On the CD-ROM: One full practice exam that simulates the actual OCA exam Detailed answers and explanations Score report performance assessment tool Complete electronic book Bonus exam available free with online registration.

Prepare for the Oracle Certified Associate Oracle Database 11g: SQL Fundamentals I exam with help from this exclusive Oracle Press guide. In each chapter, you'll find challenging exercises, practice questions, a two-minute drill, and a chapter summary to highlight what you've learned. This authoritative guide will help you pass the test and serve as your essential on-the-job reference.

Instructions on proactively ensuring the safety and security of Oracle data are found in this innovative guide to Oracle Forensics techniques. Packed with insights and expert tips, this definitive reference provides strategies for protecting critical data from a variety of outside threats and for boosting the overall effectiveness of Oracle firewalls. Additional instructions for developing an automated framework for accessing database security make this required reading for any Oracle database a dministrator.

A Fully Integrated Study System for OCP Exam 1Z0-050 Prepare for the Oracle Certified Professional Oracle Database 11 New Features for Administrators exam with help from this exclusive Oracle Press guide. In each chapter, you'll find challenging exercises, practice questions, a two-minute drill, and a chapter summary to highlight what you've learned. This authoritative guide will help you pass the test, and serve as your essential on-the-job reference. Get complete coverage of all OCP objectives for exam 1Z0-050, including: Installation and upgrades Partitioning and storage Intelligent infrastructure Diagnostics and fault management Performance Oracle Recovery Manager and Oracle Flashback Security Oracle SQL Performance Analyzer SQL plan management Automatic SQL tuning On the CD-ROM: One full practice exam that simulates the actual OCP exam Detailed answers and explanations Score report performance assessment tool Complete electronic book Bonus exam available free with online registrat ion.

A Fully Integrated Study System for OCP Exam 1Z0-050 Prepare for the Oracle Certified Professional Oracle Database 11 New Features for Administrators exam with help from this exclusive Oracle Press guide. In each chapter, you'll find challenging exercises, practice questions, a two-minute drill, and a chapter summary to highlight what you've learned. This authoritative guide will help you pass the test, and serve as your essential on-the-job reference. Get complete coverage of all OCP objectives for exam 1Z0-050, including: Installation and upgrades Partitioning and storage Intelligent infrastructure Diagnostics and fault management Performance Oracle Recovery Manager and Oracle Flashback Security Oracle SQL Performance Analyzer SQL plan management Automatic SQL tuning On the CD-ROM: One full practice exam that simulates the actual OCP exam Detailed answers and explanations Score report performance assessment tool Complete electronic book Bonus exam available free with online registrat ion.

Welcome aboard the first book focusing exclusively on PL/SQL techniques, through Oracle 11g. These techniques are tried-tested-true, yet do not compromise performance. You'll find coverage of all types of scenarios, starting from design to coding and testing to debugging and tuning. PL/SQL is more than just a 3GL sequel to SQL; instead it can be used as a methodology for application development using Oracle. The techniques covered here have a broader scope, in applications ranging from OLTP to O LAP and from data warehousing to business intelligence. The world of PL/SQL is exciting and this book provides a repository of techniques for PL/SQL developers and DBAs alike. This book takes you beyond the existing solutions found in other professional and reference texts or in online documentation. Starting from PL/SQL internals that include PL/SQL program structure, internal representation, compilation, and execution, users are taught PL/SQL concepts and techniques that go way beyond SQL, suc h as data structure management, error management, data management, application management, and transaction management. It covers the practical "how-to" techniques of applying these PL/SQL concepts in live projects and elaborates on various PL/SQL frameworks, the integration of PL/SQL with Java, and Web-enabling PL/SQL. The last two chapters on PL/SQL tuning and debugging and PL/SQL coding standards contain comprehensive coverage of performance-enhancing techniques and PL/SQL coding standards tha t can't be found in anywhere else. All techniques include examples and hands-on code, as well as tips and coding standards. The companion CD-ROM includes all the source code for the examples in the book.

The Ultimate Reference & Learning Guide for Oracle Financials Consultants! Over 150 Certification Questions, Answers, and Explanations It's clear that Oracle Financials is the future for ERP in Oracle - but finding good reference materials can be difficult. Now, for the first time, a world class Oracle consultant shares his knowledge and understanding of this complex topic. Oracle Financials Interview Questions guides you easily through your learning process. From helping you to assess your Oracle Financials skills, to helping screen candidates for your Oracle positions, Oracle Financials Interview Questions will help you understand what you really need to know. This book is organized around several areas of Oracle Financials: General Ledger, Accounts Payable, Accounts Receivable, OFSA, Budget module, Technical installation & configuration, Procure to Pay. In addition, Oracle Fusion Middleware is covered. Each question is based on implementation project know-how gained on high- profile Oracle Financials implementations. Key topics include: Fusion Middleware, General Ledger, Budget, AR/AP, Technical installation & configuration, Procure to Pay, much more.

Combining theory with everyday practicality, this de?itive volume is packed with up-to-date information, new features, and explanations you need to get the very most out of SQL and its latest standard. The book is unique in that every chapter highlights how the new SQL standard applies to the three major databases, Oracle 11g, IBM DB2 9.5, and Microsoft SQL Server 2008. The result is a comprehensive, useful, and real-world reference for all SQL users, from beginners to experienced developers.

Written by Oracle experts, this book explains how to build custom BI applications using Oracle Business Intelligence Suite Standard Edition and Enterprise Edition. The book covers all of Oracle's BI product offerings, including Oracle Warehouse Builder and the recently acquired and incorporated Siebel Analytics product. Oracle Business Intelligence Suite Developer's Guide teaches you how to design a BI database, load data using Oracle's ETL tool, and execute reporting, publishing, and analysis. The book puts the tools in context and offers real-world advice on the most appropriate approach to take for specific BI deployments.

Design Feature-Rich PL/SQL Applications Deliver dynamic, client/server PL/SQL applications with expert guidance from an Oracle programming professional. With full coverage of the latest features and tools, Oracle Database 11g PL/SQL Programming lays out each topic alongside detailed explanations, cut-and-paste syntax examples, and real-world case studies. Access and modify database information, construct powerful PL/SQL statements, execute effective queries, and deploy bulletproof security. You' ll also learn how to implement C, C++, and Java procedures, Web-enable your database, cut development time, and optimize performance. Create, debug, and manage Oracle-driven PL/SQL programs Use PL/SQL structures, delimiters, operators, variables, and statements Identify and eliminate errors using PLSQL_WARNINGS and exception handlers Work with functions, procedures, packages, collections, and triggers Define and deploy varray, nested table, and associative array data types Handle external routin es, object types, large objects, and secure files Communicate between parallel sessions using DBMS_ALERT and DBMS_PIPE Call external procedures through Oracle Net Services and PL/SQL wrappers Integrate internal and server-side Java class libraries using Oracle JVM Develop robust Web applications using PL/SQL Gateway and Web Toolkit.

Design Feature-Rich PL/SQL Applications Deliver dynamic, client/server PL/SQL applications with expert guidance from an Oracle programming professional. With full coverage of the latest features and tools, Oracle Database 11g PL/SQL Programming lays out each topic alongside detailed explanations, cut-and-paste syntax examples, and real-world case studies. Access and modify database information, construct powerful PL/SQL statements, execute effective queries, and deploy bulletproof security. You' ll also learn how to implement C, C++, and Java procedures, Web-enable your database, cut development time, and optimize performance. Create, debug, and manage Oracle-driven PL/SQL programs Use PL/SQL structures, delimiters, operators, variables, and statements Identify and eliminate errors using PLSQL_WARNINGS and exception handlers Work with functions, procedures, packages, collections, and triggers Define and deploy varray, nested table, and associative array data types Handle external routin es, object types, large objects, and secure files Communicate between parallel sessions using DBMS_ALERT and DBMS_PIPE Call external procedures through Oracle Net Services and PL/SQL wrappers Integrate internal and server-side Java class libraries using Oracle JVM Develop robust Web applications using PL/SQL Gateway and Web Toolkit.

The Topics Covered In This Book Are: Visualizing the Complete Oracle Environment, SQL: Structured Query Language, Oracle Database Concepts, Oracle Instance Concepts, Oracle in Action, Complete Oracle System Design: Steps of Implementation, Oracle Database Design, Oracle Network Administration, Oracle Database Management, Oracle Backup & Recovery Techniques, Oracle Performance Tuning. Everything in this book is covered in a step by step manner by first building reader s concept using analogi es, real world examples and then taking him/her to the steps of design implementation. The book covers Oracle 10g Database Administration for both Unix as well as Windows OS. The concepts and most of the stuff discussed in this book are equally good for other Oracle versions including 11g.

Deliver next-generation user capabilities and client-side services in your Oracle-based Web applications by combining the powerful features of AJAX and PHP. Written by Web 2.0 programming experts, Oracle Database AJAX & PHP Web Application Development shows you how to design faster, lighter, more responsive Web applications while reducing code support and creation time. You'll learn how to develop modular AJAX and PHP code, add dynamically updated content, and implement click-to-edit and dra g-and-drop functionality. You'll also get details on incorporating cutting-edge mashup, reporting, and communication features.

The questions in this guide have been selected using this framework: (1) Questions should reflect understanding of concepts (2) Questions should reflect actual hands-on experience (3) Questions should not be based on memorization of arcane names or syntax (4) Questions should reflect issues seen by the majority of DBAs of that skill level. The intent of the questions is that most DBAs, for a given skill level, can successfully answer most of the interview questions. Naturally, no one person coul d be expected to flawlessly answer all of the senior-level questions. Even the most adept DBAs have some areas of weakness. In order to test the fairness of the questions, I asked numerous DBAs, from different backgrounds and companies, to review the questions.

I quickly glanced through it and knew at the first sight that these are truly useful resources for any beginner in Oracle Apps. The topics of KFF and DFF are very well explained enough to be an expert.

The book starts with the history of versions and the advantage of learning BI publisher is that BI publisher developer can develop reports not just for Oracle but also for Siebel, JD Edwards and PeopleSoft. The book gives step by step guided practice lessons. In short I would recommend this will be a great selection to start with.

The Essential Resource for Oracle DBAs--Fully Updated and Expanded. Manage a flexible, highly available Oracle database with help from the expert information contained in this exclusive Oracle Press guide. Fully revised to cover every new feature and utility, Oracle Database 11g DBA Handbook shows how to perform a new installation, upgrade from previous versions, configure hardware and software for maximum efficiency, and employ bulletproof security. You will learn to automate the backup and rec overy process, provide transparent failover capability, audit and tune performance, and distribute your enterprise databases with Oracle Net. Plan and deploy permanent, temporary, and bigfile tablespaces. Optimize disk allocation, CPU usage, I/O throughput, and SQL queries. Develop powerful database management applications. Guard against human errors using Oracle Flashback and Oracle Automatic Undo Management. Diagnose and tune system performance using Oracle Automatic Workload Repository and SQ L Tuning Sets. Implement robust security using authentication, authorization, fine-grained auditing, and fine-grained access control. Maintain high availability using Oracle Real Application Clusters and Oracle Active Data Guard. Respond more efficiently to failure scenarios by leveraging the Oracle Automatic Diagnostic Repository and the Oracle Repair Advisor. Back up and restore tables, tablespaces, and databases with Oracle Recovery Manager and Oracle Data Pump Export and Import. Work with ne tworked databases, data warehouses, and VLDBs. Put the latest Oracle Database 11g tools to work--Oracle Total Recall, Oracle Flashback Data Archive, and more.

The Essential Resource for Oracle DBAs--Fully Updated and Expanded. Manage a flexible, highly available Oracle database with help from the expert information contained in this exclusive Oracle Press guide. Fully revised to cover every new feature and utility, Oracle Database 11g DBA Handbook shows how to perform a new installation, upgrade from previous versions, configure hardware and software for maximum efficiency, and employ bulletproof security. You will learn to automate the backup and rec overy process, provide transparent failover capability, audit and tune performance, and distribute your enterprise databases with Oracle Net. Plan and deploy permanent, temporary, and bigfile tablespaces. Optimize disk allocation, CPU usage, I/O throughput, and SQL queries. Develop powerful database management applications. Guard against human errors using Oracle Flashback and Oracle Automatic Undo Management. Diagnose and tune system performance using Oracle Automatic Workload Repository and SQ L Tuning Sets. Implement robust security using authentication, authorization, fine-grained auditing, and fine-grained access control. Maintain high availability using Oracle Real Application Clusters and Oracle Active Data Guard. Respond more efficiently to failure scenarios by leveraging the Oracle Automatic Diagnostic Repository and the Oracle Repair Advisor. Back up and restore tables, tablespaces, and databases with Oracle Recovery Manager and Oracle Data Pump Export and Import. Work with ne tworked databases, data warehouses, and VLDBs. Put the latest Oracle Database 11g tools to work--Oracle Total Recall, Oracle Flashback Data Archive, and more.

This is an amazingly comprehensive and detailed book about the new features of the Oracle 11g edition. I'm very surprised that the authors could publish this big a book (over 600 pages) on just the new features of the Oracle 11g database so soon after Oracle Open World in November.

This is an amazingly comprehensive and detailed book about the new features of the Oracle 11g edition. I'm very surprised that the authors could publish this big a book (over 600 pages) on just the new features of the Oracle 11g database so soon after Oracle Open World in November.

Build and manage a scalable storage infrastructure with Oracle Automatic Storage Management. Streamline data management and provisioning using Oracle Automatic Storage Management (Oracle ASM) and the detailed information contained in this exclusive Oracle Press resource, written by a team of database experts. Oracle Automatic Storage Management: Under-the-Hood & Practical Deployment Guide explains how to build and maintain a dynamic, highly available Oracle database storage environment. Ins ide, you'll learn how to configure storage for Oracle ASM, build disk groups, use data striping and mirroring, and optimize performance.

Build and manage a scalable storage infrastructure with Oracle Automatic Storage Management. Streamline data management and provisioning using Oracle Automatic Storage Management (Oracle ASM) and the detailed information contained in this exclusive Oracle Press resource, written by a team of database experts. Oracle Automatic Storage Management: Under-the-Hood & Practical Deployment Guide explains how to build and maintain a dynamic, highly available Oracle database storage environment. Ins ide, you'll learn how to configure storage for Oracle ASM, build disk groups, use data striping and mirroring, and optimize performance.

Your Must-Have Guide to Everything New in Oracle Database 11g. Realize the full potential of Oracle Database 11g with help from the experts. Robert G. Freeman, and with insightful commentary throughout from Arup Nanda, this Oracle Press guide offers full details on the architectural changes, database administration upgrades, availability and recovery revisions, security enhancements, and programming innovations. Every new and updated feature is covered and presented with screenshots, code sample s, tables, and charts. Find out how to take full advantage of all the new and improved capabilities of Oracle Database 11g, including New Oracle Automatic Storage Management features, such as Fast Disk Resync, Compatibility Attributes, Preferred Mirror Read, and Rolling Upgrade components. Improved Automated Memory Management capabilities. New database design features, such as virtual columns, tablespace encryption, and true table-level data compression. New Database Advisors for data recovery a nd repair, partitioning, and streams performance. New tuning features, such as Automatic SQL Tuning and SQL Performance Analyzer. Enhancements to Oracle RMAN, including active database duplication and UNDO backup optimization. Improved auditing and security capabilities. Advanced BI, data warehousing, and partitioning features New SQL and PL/SQL enhancements.

Your Must-Have Guide to Everything New in Oracle Database 11g. Realize the full potential of Oracle Database 11g with help from the experts. Robert G. Freeman, and with insightful commentary throughout from Arup Nanda, this Oracle Press guide offers full details on the architectural changes, database administration upgrades, availability and recovery revisions, security enhancements, and programming innovations. Every new and updated feature is covered and presented with screenshots, code sample s, tables, and charts. Find out how to take full advantage of all the new and improved capabilities of Oracle Database 11g, including New Oracle Automatic Storage Management features, such as Fast Disk Resync, Compatibility Attributes, Preferred Mirror Read, and Rolling Upgrade components. Improved Automated Memory Management capabilities. New database design features, such as virtual columns, tablespace encryption, and true table-level data compression. New Database Advisors for data recovery a nd repair, partitioning, and streams performance. New tuning features, such as Automatic SQL Tuning and SQL Performance Analyzer. Enhancements to Oracle RMAN, including active database duplication and UNDO backup optimization. Improved auditing and security capabilities. Advanced BI, data warehousing, and partitioning features New SQL and PL/SQL enhancements.

Write powerful SQL statements and PL/SQL programs. Learn to access Oracle databases through SQL statements and construct PL/SQL programs with guidance from Oracle expert, Jason Price. Published by Oracle Press, Oracle Database 11g SQL explains how to retrieve and modify database information, use SQL Plus and SQL Developer, work with database objects, write PL/SQL programs, and much more. Inside, you'll find in-depth coverage of the very latest SQL features and tools, performance optimization tec hniques, advanced queries, Java support, and XML. This book contains everything you need to master SQL. Explore SQL Plus and SQL Developer. Use SQL SELECT, INSERT, UPDATE, and DELETE statements. Write PL/SQL programs. Create tables, sequences, indexes, views, and triggers. Write advanced queries containing complex analytical functions. Create database objects and collections to handle abstract data. Use large objects to handle multimedia files containing music and movies. Write Java programs to access an Oracle Database using JDBC. Tune your SQL statements to make them execute faster. Explore the XML capabilities of the Oracle Database. Master the very latest Oracle Database 11g features, such as PIVOT and UNPIVOT, flashback archives, and much more.

Write powerful SQL statements and PL/SQL programs. Learn to access Oracle databases through SQL statements and construct PL/SQL programs with guidance from Oracle expert, Jason Price. Published by Oracle Press, Oracle Database 11g SQL explains how to retrieve and modify database information, use SQL Plus and SQL Developer, work with database objects, write PL/SQL programs, and much more. Inside, you'll find in-depth coverage of the very latest SQL features and tools, performance optimization tec hniques, advanced queries, Java support, and XML. This book contains everything you need to master SQL. Explore SQL Plus and SQL Developer. Use SQL SELECT, INSERT, UPDATE, and DELETE statements. Write PL/SQL programs. Create tables, sequences, indexes, views, and triggers. Write advanced queries containing complex analytical functions. Create database objects and collections to handle abstract data. Use large objects to handle multimedia files containing music and movies. Write Java programs to access an Oracle Database using JDBC. Tune your SQL statements to make them execute faster. Explore the XML capabilities of the Oracle Database. Master the very latest Oracle Database 11g features, such as PIVOT and UNPIVOT, flashback archives, and much more.

The latest Oracle Database 11g features: query result set caching, Automatic Memory Management, the Real Application Testing, Advanced Compression, Total Recall, and Active Data Guard Option Options, changes to the OLAP Option (transparently accessed and managed as materialized views), the Flashback transaction command, transparent data encryption, the Support Workbench (and diagnosability infrastructure), and partitioning enhancements (including interval and new composite types) For new Oracle users, DBAs, developers, and managers, Oracle Essentials provides an invaluable, all-in-one introduction to the full range of Oracle features and technologies, including the just-released Oracle Database 11g features. But even if you already have a library full of Oracle documentation, you'll find that this compact book is the one you turn to, again and again, as your one-stop, truly essential reference. Oracle is an enormous system, with myriad technologies, options, and releases. Most users-e ven experienced developers and database administrators-find it difficult to get a handle on the full scope of the Oracle database. And, as each new Oracle version is released, users find themselves under increasing pressure to learn about a whole range of new technologies. The latest challenge is Oracle Database 11g.

Pro Oracle Spatial for Oracle Database 11g shows how to take advantage of Oracle Databases built?in feature set for working with location?based 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 todays mobile and highly connected world.

Pro Oracle Spatial for Oracle Database 11g shows how to take advantage of Oracle Databases built?in feature set for working with location?based 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 todays mobile and highly connected world.

Truly an excellent book and definitely a must for EBS beginners. In a world of ERP , this book actually delivers a lot more than its cost. Roel, has provided an incredibly honest approach to some of key attributes essential for EBS Implementer.

Truly an excellent book and definitely a must for EBS beginners. In a world of ERP , this book actually delivers a lot more than its cost. Roel, has provided an incredibly honest approach to some of key attributes essential for EBS Implementer.

The fourth edition of this popular pocket guide provides quick-reference information that will help you use Oracle's PL/SQL language, including the newest Oracle Database 11g features. It's a companion to Steven Feuerstein and Bill Pribyl's bestselling Oracle PL/SQL Programming. This concise guide boils down the most vital PL/SQL information into an accessible summary of: Fundamental language elements (e.g., block structure, datatypes, declarations) Statements for program control, cursor managem ent, and exception handling Records, procedures, functions, triggers, and packages Calling PL/SQL functions in SQL Compilation options, object-oriented features, collections, and Java integration The new edition describes such Oracle Database 11g elements as PL/SQL's function result cache, compound triggers, the CONTINUE statement, the SIMPLE_INTEGER datatype, and improvements to native compilation, regular expressions, and compiler optimization (including intra-unit inlining). In addition, this book now includes substantial new sections on Oracle's built-in functions and packages. When you need answers quickly, the Oracle PL/SQL Language Pocket Reference will save you hours of frustration.

In this compact book, Steven Feuerstein, widely recognized as one of the world's leading experts on the Oracle PL/SQL language, distills his many years of programming, teaching, and writing about PL/SQL into a set of best practices-recommendations for developing successful applications. Covering the latest Oracle release, Oracle Database 11g, Feuerstein has rewritten this new edition in the style of his bestselling Oracle PL/SQL Programming. The text is organized in a problem/solution format, an d chronicles the programming exploits of developers at a mythical company called My Flimsy Excuse, Inc., as they write code, make mistakes, and learn from those mistakes-and each other. Oracle PL/SQL Best Practices summarizes PL/SQL best practices in nine major categories: overall PL/SQL application development; programming standards; program testing, tracing, and debugging; variables and data structures; control logic; error handling; the use of SQL in PL/SQL; building procedures, functions, p ackages, and triggers; and overall program performance. This book is a concise and entertaining guide that PL/SQL developers will turn to again and again as they seek out ways to write higher quality code and more successful applications.

The Ultimate Job Reference & Career Guide for Oracle Professionals! Over 150 Certification Questions, Answers, and Explanations Our books are for readers who must absolutely land their next job in Oracle, and who want to improve their existing positions. ORACOOKOOK readers have a need for information they can use right now. Our series of Oracle interview questions books is a direct answer to that need for instant information in the modern workplace. Our books are written by Oracle practition ers and expert authors who have varied vast experiences in the world of information technology. If great careers begin with a good book, the best careers begin with ORACOOKBOOK Over 150 Certification Questions, Answers and Explanations guide you through your learning process. Suitable for developers of any and every level of Oracle expertise, the book is organized around design, performance tuning, and audit and security. Each question includes everything you need to know to master the interview or properly evaluate a candidate. More than just a rehash of Oracle documentation and sales presentations, each question is based on project knowledge and experience gained on successful high-profile implementations.

The Ultimate Job Reference & Career Guide for Oracle Professionals! Over 150 Certification Questions, Answers, and Explanations Our books are for readers who must absolutely land their next job in Oracle, and who want to improve their existing positions. ORACOOKOOK readers have a need for information they can use right now. Our series of Oracle interview questions books is a direct answer to that need for instant information in the modern workplace. Our books are written by Oracle practition ers and expert authors who have varied vast experiences in the world of information technology. If great careers begin with a good book, the best careers begin with ORACOOKBOOK Over 150 Certification Questions, Answers and Explanations guide you through your learning process. Suitable for developers of any and every level of Oracle expertise, the book is organized around design, performance tuning, and audit and security. Each question includes everything you need to know to master the interview or properly evaluate a candidate. More than just a rehash of Oracle documentation and sales presentations, each question is based on project knowledge and experience gained on successful high-profile implementations.

Beginning PHP and Oracle: From Novice to Professional offers comprehensive information on using the PHP scripting language in conjunction with Oracles database platform. PHP is one of the most prominent open source technologies in the area of web development, while Oracle is one of the most widely deployed and used database products. You'll learn to reap the benefits of these core technologies by using them in unison to create dynamic, data-driven web applications. The book is packed with pract ical examples based on the many years of real-world experience of authors W Jason Gilmore and Bob Bryla. This book is an ideal read for web designers or programmers wanting to create applications with PHP in an Oracle environment.

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

Learn how to use the PL/SQL programming language effectively, using one of the most popular and widely-used software programs in large companies today. Oracle 10g Developer: PL/SQL Programming uses Oracle 10g to provide an overview of the PL/SQL programming language, beginning with fundamental PL/SQL concepts and progressing to the writing and testing of PL/SQL code. The book then progresses to more advanced topics, such as Dynamic SQL and code tuning. Updated to the latest release, Oracle 10g, it uses the developer's perspective to focus on the PL/SQL component of the software. With real-world examples and a straightforward writing style, this is a valuable resource for anyone preparing for the new Oracle Certification exam, or simply looking to master the PL/SQL programming language with Oracle.

This is the only practical, hands-on guide available to database administrators to secure their Oracle databases. This book will help the DBA to assess their current level of risk as well as their existing security posture. It will then provide practical, applicable knowledge to appropriately secure the Oracle database. The books companion Web site contains dozens of working scripts that DBAs can use to secure and automate their Oracle databases.

Monitor, analyze, and optimize Oracle Database 10g using the tested methods and insider advice contained in this definitive volume. Written by Oracle Certified Master Richard Niemiec, Oracle Database 10g Performance Tuning Tips & Techniques is packed with detailed case studies, best practices, and code samples illustrating Oracle's new tuning features. Find out how to select optimal indexing options, effectively manage drives and disk arrays, troubleshoot queries, and reliably predict future per formance. You'll also get detailed coverage of PL/SQL performance enhancements, initialization file tweaks, and the latest database surveying and reporting utilities.

The Ultimate Oracle Application Server Portal Resource. Build dynamic, feature-rich enterprise portals using Oracle Application Server Portal and the expert information in this exclusive Oracle Press guide. You'll learn how to maximize the capabilities of Oracle Application Server Portal, customize your portals, integrate Oracle Forms and Oracle Reports, and add Java functionality. Oracle Application Server Portal Handbook covers all of the design, management, and security features available in Oracle Application Server Portal 10.1.4 alongside real-world solutions. Take full advantage of the built-in tools and wizards. Create rich end-user experiences quickly and easily. Customize pages and maintain site-wide consistency using HTML templates. Incorporate data from disparate formats using Oracle Application Server Portal's content management features. Build pages using OmniPortlet and the Web clipping studio. Write portlets with Java and Oracle JDeveloper. Implement SOA-based applicatio ns to connect business processes. Administer, tune, and secure Oracle Application Server Portal. Integrate Oracle Forms, Oracle Reports, and Oracle Discoverer workbooks

The Ultimate Oracle Application Server Portal Resource. Build dynamic, feature-rich enterprise portals using Oracle Application Server Portal and the expert information in this exclusive Oracle Press guide. You'll learn how to maximize the capabilities of Oracle Application Server Portal, customize your portals, integrate Oracle Forms and Oracle Reports, and add Java functionality. Oracle Application Server Portal Handbook covers all of the design, management, and security features available in Oracle Application Server Portal 10.1.4 alongside real-world solutions. Take full advantage of the built-in tools and wizards. Create rich end-user experiences quickly and easily. Customize pages and maintain site-wide consistency using HTML templates. Incorporate data from disparate formats using Oracle Application Server Portal's content management features. Build pages using OmniPortlet and the Web clipping studio. Write portlets with Java and Oracle JDeveloper. Implement SOA-based applicatio ns to connect business processes. Administer, tune, and secure Oracle Application Server Portal. Integrate Oracle Forms, Oracle Reports, and Oracle Discoverer workbooks

Written in the friendly, easy-to-understand style of the For Dummies series, this book shows novice PL/SQL programmers how to use PL/SQL, the procedural programming language embedded in Oracle, to develop Oracle applications. Experienced Oracle programmers and project managers will also benefit from the best practices and code and naming standards material in the book. Discusses getting started with PL/SQL (including language fundamentals, program control, exception handling, and packages); Ora cle-specific programming topics (Oracle constructs of interest to PL/SQL developers, code-placement option, and more); and advanced PL/SQL (manipulating strings, manipulating dates, and manipulating numbers, among others)

With the expert techniques discussed in this book, Oracle database administrators can automate routine tasks to save time and money and better monitor the flow of work. Using shell scripts-an indispensable tool on UIX and Linux-any number of commands can be combined and executed either simultaneously or sequentially. More than 50 working shell scripts for both beginners and experts give Oracle professionals a fantastic head-start on automating their administration duties and are easily modifiabl e for any environment. Topics include the history of shells and shell scripting, detailed step-by-step instructions on building shell scripts, how to tell when things are working right, and how to effectively monitor the system for failures.

Physical Database Design Using Oracle correlates logical data models with the physical implementation structures that Oracle provides. It allows students to learn how to take logical data models and convert them into a series of data structures that permit fast and easy logical access to data. This textbook is targeted at undergraduate and graduate IS students studying to become the Oracle professionals of the near future. It is expected that they already have exposure to basic Oracle database a dministration. The expert guidance provided by this textbook provides the insight needed to choose appropriate physical models for mission-critical applications.

Oracle 10G Programming is a concise, streamlined guide to Oracle programming. It is ideal for students studying databases, and introduces the Oracle technology students need to know for a first database course. The Relational Data Model, Oracle SQL, PL/SQL, Web Programming with PL/SQL, Oracle JDBC, SQLJ: Embedded SQL in Java, Oracle Web Programming with Java Servlets, Oracle XML, Projects.

What makes seasoned IT professionals run for cover? Answer: Forecasting Oracle performance! Craig Shallahamer is an Oracle performance expert with over 18 years of experience. His book is the first to focus, not on the problem of solving today's problem, but squarely on the problem of forecasting the future performance of an Oracle database. Other Oracle performance books are good for putting out fires; Craig's book helps you avoid all the heat in the first place. If you're an IT practioner who appreciates application over mathematical proofs than you'll be pleasantly surprised! Each chapter is filled with examples to transform the theory, mathematics, and methods into something you can practically apply. Craig's goal is to teach you about real-word Oracle performance forecasting. Period. There is no hidden agenda.

Oracle 11i E-Business Suite from the Front Lines is the first book to compile the tips, techniques, and practical advice for administering Oracle E-Business Suite 11i. The author examines Active Directory Utilities, patching, cloning, and the new features that 11i brings to the market. The book benefits those with limited experience with Oracle Application but with more extensive background in Oracle Database Administration. This volume is valuable to systems administrators or DBAs who have expe rience with older versions of Oracle Financials and want to expand their knowledge to include the changes inherent in 11i.

This book is a collection of the best most relevant articles published in Oracle Internals, Auerbach Publications' newsletter for Oracle database administrators. Edited by Oracle guru Don Burleson, it provides the type of in-depth, highly technical information only available from peers and consultants. Unlike existing tutorials, this book focuses on the truly tough stuff - techniques learned and used in the trenches.

This book is a collection of the best most relevant articles published in Oracle Internals, Auerbach Publications' newsletter for Oracle database administrators. Edited by Oracle guru Don Burleson, it provides the type of in-depth, highly technical information only available from peers and consultants. Unlike existing tutorials, this book focuses on the truly tough stuff - techniques learned and used in the trenches.

In an effort to provide foresight as systems grow and resources are stressed, this guidebook explains how one of the major causes of unplanned database outages is the failure to anticipate the effects of growth. The benchmark method detailed enables users to spot areas of pending problems before they cripple the database. This real-world approach ensures the user will be prepared for whatever the future brings to mission-critical databases. Areas explored in this book include knowing the limits of the database, avoiding unplanned outages with capacity planning, and predicting the need for new hardware.

Installing, Upgrading and Maintaining Oracle E-Business Suite Applications Release 11.5.10+" is OnCallDBA and Solution Beacon's latest collaboration. Topics include Release 11i Concepts and Architecture, Oracle10g, Installing Release 11i, Upgrading or Migrating to Release 11i, Maintaining Release 11i, Administering Release 11i, Securing Release 11i, Setting Up the Concurrent Manager, Using the Concurrent Manager, Release 11i Reporting, and Tuning and Troubleshooting. Co-authored by Barbara Matth ews, John Stouffer, Randy Giefer, Karen Brownfield, Jeff Holt, James Morrow, Bruno Coon, Tim Sharpe and Faun deHenry, this book covers Oracle10g and E-Business Release 11.5.10+

Maximize the Capabilities of Oracle Collaboration Suite Facilitate enterprisewide communication, data sharing, and team work using Oracle Collaboration Suite 10 and the in-depth information contained in this Oracle Press guide. Oracle Collaboration Suite Handbook explains how to install, implement, manage, and optimize the suite in an enterprise environment. You'll discover how you can use this powerful tool to securely, reliably, and cost-effectively enable real-time collaboration, streamline business processes, simplify data distribution, and consolidate corporate information. Tailor a system-specific Oracle Collaboration Suite environment Install the Infrastructure Tier, Datastore Tier, and Applications Tier Perform successful migrations to Oracle Collaboration Suite 10g Create, manage, monitor, and delete user accounts with provisioning Control processes, components, and subcomponents from the command line and the Enterprise Manager Browser interface Perform reliable full and par tial database backups and restores Monitor, analyze, and act on system log files Administer applications, application components, and program functionality Manipulate unstructured data using intelligent containers and Oracle Content Services.

Maximize the Capabilities of Oracle Collaboration Suite Facilitate enterprisewide communication, data sharing, and team work using Oracle Collaboration Suite 10 and the in-depth information contained in this Oracle Press guide. Oracle Collaboration Suite Handbook explains how to install, implement, manage, and optimize the suite in an enterprise environment. You'll discover how you can use this powerful tool to securely, reliably, and cost-effectively enable real-time collaboration, streamline business processes, simplify data distribution, and consolidate corporate information. Tailor a system-specific Oracle Collaboration Suite environment Install the Infrastructure Tier, Datastore Tier, and Applications Tier Perform successful migrations to Oracle Collaboration Suite 10g Create, manage, monitor, and delete user accounts with provisioning Control processes, components, and subcomponents from the command line and the Enterprise Manager Browser interface Perform reliable full and par tial database backups and restores Monitor, analyze, and act on system log files Administer applications, application components, and program functionality Manipulate unstructured data using intelligent containers and Oracle Content Services.

The book To Become an Oracle DBA in Eighty Days explains the concepts of oracle database using the stories from Jules Verne's novel Around the World in 80 Days: One Oracle Database Architecture Two Oracle Network Configuration 2.1. Client Request 2.2. Network Configuration Files 2.3. Listener Static and Dynamic Register 2.4. Listener Failover and Load Balance Three Database Grid Control 3.1. Grid Control Structure 3.2. Event and Notification 3.3. Scheduled Job Four Backup, Recovery and RMAN 4.1. System Change Number (SCN) 4.2. Online Backup 4.3. Recovery 4.4. Oracle Recovery Manager (RMAN) Five Oracle Real Application Cluster (RAC) 5.1. Physical Structure 5.2. Resource Coordination 5.3. Cache Fusion Six Performance Tuning.

David Litchfield has devoted years to relentlessly searching out the flaws in the Oracle database system and creating defenses against them. Now he offers you his complete arsenal to assess and defend your own Oracle systems. This in-depth guide explores every technique and tool used by black hat hackers to invade and compromise Oracle and then it shows you how to find the weak spots and defend them. Without that knowledge, you have little chance of keeping your databases truly secure.

David Litchfield has devoted years to relentlessly searching out the flaws in the Oracle database system and creating defenses against them. Now he offers you his complete arsenal to assess and defend your own Oracle systems. This in-depth guide explores every technique and tool used by black hat hackers to invade and compromise Oracle and then it shows you how to find the weak spots and defend them. Without that knowledge, you have little chance of keeping your databases truly secure.

Written by a team of Oracle insiders, this authoritative book provides you with the most current coverage of the Oracle data warehousing platform as well as the full suite of business intelligence tools. You'll learn how to leverage Oracle features and how those features can be used to provide solutions to a variety of needs and demands. Plus, you'll get valuable tips and insight based on the authors' real-world experiences and their own implementations.

Oracle 10g Developing Media Rich Applications is focused squarely on database administrators and programmers as the foundation of multimedia database applications. With the release of Oracle8 Database in 1997, Oracle became the first commercial database with integrated multimedia technology for application developers. Since that time, Oracle has enhanced and extended these features to include native support for image, audio, video and streaming media storage; indexing, retrieval and processing i n the Oracle Database, Application Server; and development tools. Databases are not only words and numbers for accountants, but they also should utilize a full range of media to satisfy customer needs, from race car engineers, to manufacturing processes to security. The full range of audio, video and integration of media into databases is mission critical to these applications. This book details the most recent features in Oracles multimedia technology including those of the Oracle10gR2 Databas e and the Oracle9i Application Server. The technology covered includes: object relational media storage and services within the database, middle tier application development interfaces, wireless delivery mechanisms, and Java-based tools.

Oracle 10g Developing Media Rich Applications is focused squarely on database administrators and programmers as the foundation of multimedia database applications. With the release of Oracle8 Database in 1997, Oracle became the first commercial database with integrated multimedia technology for application developers. Since that time, Oracle has enhanced and extended these features to include native support for image, audio, video and streaming media storage; indexing, retrieval and processing i n the Oracle Database, Application Server; and development tools. Databases are not only words and numbers for accountants, but they also should utilize a full range of media to satisfy customer needs, from race car engineers, to manufacturing processes to security. The full range of audio, video and integration of media into databases is mission critical to these applications. This book details the most recent features in Oracles multimedia technology including those of the Oracle10gR2 Databas e and the Oracle9i Application Server. The technology covered includes: object relational media storage and services within the database, middle tier application development interfaces, wireless delivery mechanisms, and Java-based tools.

This Oracle Press guide shows you how to take full advantage of RMAN--the robust backup and recovery technology built into Oracle 10g. Oracle Database 10g RMAN Backup & Recovery will serve both as a step-by-step tutorial and an indispensable on-the-job reference that you will refer to again and again. All the latest RMAN features introduced in Oracle Database 10g are covered, including incremental backups, flash recovery area, resetlogs, and much more.

Learn cutting-edge technology from Oracle experts Written by Oracle insiders, this comprehensive guide covers everything you need to know about Real Application Clusters -- low-cost hardware platforms that can rival and exceed the quality of service, availability, and scalability of the most expensive mainframe systems. Concepts covered are applicable to all previous versions of Oracle Tuning and troubleshooting tips, providing insight on the most advanced diagnostics available Detailed coverage of advanced RAC concepts Working code for all examples available online.

OCS is becoming the dominant product for large-scale collaboration--blending core functions of e-mail, file serving, and diary management with the additional functionality of web conferencing, instant messaging, and wireless access. Pro Oracle Collaboration Suite 10g provides all you need to know to install and configure OCS for use, but this book is much more than a to-do list. It covers the architecture of the server processes and the applications, giving you the theoretical background to tak e OCS beyond the basics. There's no need to worry if you're new to the Oracle database, Oracle Components for Java environment (OC4J), HTTP web servers, or LDAP Internet directories--everything is explained carefully. But if you are already familiar with these topics, you'll learn how to fully exploit them in order to optimize your OCS installation.

Expertly leverage Oracle technology to protect the enterprise Now you can learn how to maximize the many powerful security features available in Oracle E-Business Suite, Oracle's fully integrated, comprehensive suite of enterprise business applications. You will find out about the key infrastructure, technical, and functional components involved in the secure deployment of Oracle E-Business Suite and how to configure and manage those components for optimum security. A blueprint topology of deplo yment is included. Covers all the security features within release 11 .5. 10 Includes the latest information on SOX, HIPPA, and major international regulatory issues

Complete coverage of the exam objectives, hands-on exercises, review questions, and more, this is the first and only book to offer such in-depth coverage of this challenging exam. Takes into consideration that candidates must not only know how to install and configure Oracle Application Server 10g, but how to use the robust tool set, including Oracle HTTP Server and OracleAS Portal. The book features an interactive CD-ROM, including the Sybex Test Engine with chapter review questions and bonus exams, a series of flash cards that can be used on a PC or handheld, and an e-version of the book

The most efficient way to learn J2EE programming techniques. Two Oracle experts demonstrate techniques for working within J2EE and JDeveloper for the thousands of developers currently using Oracle Forms and the PL/SQL language. Oracle is shifting their focus towards Java technologies, so you will need to know how to use the Java-based J2EE and JDeveloper. The book includes explanations of the Application Development Framework (ADF). Throughout, high-level and low-level Forms concepts are related to Java concepts so that you can become comfortable with the new terminology. Covers the new components required when developing and deploying a J2EE application Special callouts note how JDeveloper techniques translate to PL/SQL or Oracle Forms All code and examples will be available online.

This book and CD-ROM package contains everything you need to get started programming on Oracle Database 10g Express Edition. Learn, hands-on, how to develop enterprise applications in PHP which run on Oracle Database 10g Express Edition. The CD-ROM includes a full version of Oracle Database 10g Express Edition with all of the code and solutions from the book.

The traditional division of labor between the database (which only stores and manages SQL and XML data for fast, easy data search and retrieval) and the application server (which runs application or business logic, and presentation logic) is obsolete. Although the books primary focus is on programming the Oracle Database, the concepts and techniques provided apply to most RDBMS that support Java including Oracle, DB2, Sybase, MySQL, and PostgreSQL. This is the first book to cover new Java, JDBC, SQLJ, JPublisher and Web Services features in Oracle Database 10g Release 2 (the coverage starts with Oracle 9i Release 2). This book is a must-read for database developers audience (DBAs, database applications developers, data architects), Java developers (JDBC, SQLJ, J2EE, and OR Mapping frameworks), and to the emerging Web Services assemblers.

Real Application Clusters (RAC) and the Grid architecture are Oracle's strategy for scaling out enterprise systems to cope with bigger workloads and more users. Many books limit themselves by conceptualizing and theorizing about RAC technology, but this book is the first to portray implementing and administering an Oracle 10g RAC system in a Linux environment. This book features basic concepts underlying Linux and Oracle RAC, design strategies, hardware procurement and configuration, and many ot her topics. The RAC-specific technologies described include configuration of the interconnect, OCFS, ASM, Cluster Ready Services, and Grid Control. The Oracle features RMAN and Data Guard are also discussed, along with available hardware options. The authors include practical examples and configuration information, so that upon reading this book, you'll be armed with the information you need to build an Oracle RAC database on Linux, whether it is on a single laptop or a 64-node Itanium cluster.

Written by the former principal product manager for Grid Computing at Oracle, this is the only book on the market that explains how to take full advantage of the agility, reliability, and low cost of Enterprise Grid Computing in the Oracle environment. The book discusses the technologies and processes involved in moving towards the grid model at every layer of the IT stack, including storage, servers, databases and applications.

These Starter Kits include the full distribution of Oracle Database 10g Express Edition on CD-ROM. Readers will learn to install the database on Linux and take full advantage of all of the powerful features. Tutorials and step-by-step guidelines throughout will equip you with the key concepts and hands-on experience necessary to get started using Oracle Database 10g Express Edition right away.

These Starter Kits include the full distribution of Oracle Database 10g Express Edition on CD-ROM. Readers will learn to install the database on Windows and take full advantage of all of the powerful features. Tutorials and step-by-step guidelines throughout will equip you with the key concepts and hands-on experience necessary to get started using Oracle Database 10g Express Edition right away.

Written in the friendly, easy-to-understand style of the For Dummies series, this book shows novice PL/SQL programmers how to use PL/SQL, the procedural programming language embedded in Oracle, to develop Oracle applications. Experienced Oracle programmers and project managers will also benefit from the best practices and code and naming standards material in the book. Discusses getting started with PL/SQL (including language fundamentals, program control, exception handling, and packages); Ora cle-specific programming topics (Oracle constructs of interest to PL/SQL developers, code-placement option, and more); and advanced PL/SQL (manipulating strings, manipulating dates, and manipulating numbers, among others)

Grid architecture is Oracles strategy for high-end computing and RAC is the stepping stone into this arena. This book focuses on current technology including all valid RAC features up through Oracle Database 10g Release 2, with a primary focus on deploying it in a high-end grid environment. The book discusses this technology at length which users will find beneficial when researching, implementing or monitoring a RAC environment. The author covers workshop implementation of services and the dist ribution of workload across instances, with threshold definitions and the new load balancing algorithms. In addition it includes detailed discussions on ASM that complements the implementation of RAC in Oracle Grid strategy. The book also includes discussions on new Oracle Clusterware, its components and its integration with RAC. Oracle 10g RAC focuses on RAC-specific topics including ASM, operating system configuration, installation and configuration of RAC and much more. Coverage includes net work configuration for high availability, FAN, TAF, ONS, implementation of maximum availability architecture (MAA), EM Grid Control, AWR, ADDM and other performance-related tools. The author includes several scripts for performance tuning and implementation that the reader can use to configure a RAC environment either on a 2, 4, 8, 60 or 99 node configuration.

Oracle 10g Database Administrator II: Backup/Recovery uses the most current database release from Oracle to provide thorough coverage of an Oracle database through the day-to-day duties of a database administrator.

Targeting those new to Oracle data warehousing who need to get started right away, this book presents real-world problems and issues with managing large volumes of data in an Oracle database. All aspects of Oracle data warehouse management-including Oracle warehouse database administration, OLAP with Oracle Discoverer, Oracle Warehouse Builder, and Oracle data mining-are covered in detail. An overview of Oracle business intelligence tools and a downloadable code depot are also included.

A guide for Oracle DBAs who are too busy to build a clustered server environment to learn about Oracle's Real Application Cluster technology, this book allows DBAs to build and configure a Real Application Cluster quickly and inexpensively. Covers how to find the right hardware to build an at-home RAC, where to get Linux and how to set it up, how to install the Oracle Cluster Manager, and how to create the RAC database.

Targeted at Oracle professionals who need fast and accurate working examples of complex issues, Oracle In-focus books target specific areas of Oracle technology in a concise manner. Plenty of working code is provided without a lot of theory, allowing database managers to solve their problems quickly without reviewing data that they already know. All code scripts are available for instant download from a companion web site.

By removing the guesswork from Oracle HTML manipulation, this book shows working examples of complex HTML-DBA database access and techniques for creating easy HTML-DB applications. All HTML-DB concepts are described, and working examples of each HTML-DB feature are provided. Examples of HTML-DB data access and document formatting, information on how to update Oracle HTML-DB, and methods of customizing applications with Themes and CSS are also included.

Simplifying the work of creating dynamic web pages with Oracle content is the focus of this guide, which provides working examples of connecting to Oracle and delivering data into an HTML page. It thoroughly details information on complex Oracle queries in PHP, updating Oracle from PHP, and passing parameters to a PHP program.

Targeted at Oracle professionals who need fast and accurate working examples of complex issues, Oracle In-focus books target specific areas of Oracle technology in a concise manner. Plenty of working code is provided without a lot of theory, allowing database managers to solve their problems quickly without reviewing data that they already know. All code scripts are available for instant download from a companion web site.

Describing the successful techniques employed by large Oracle database shops to ensure quality and uniformity, this guide contains real-world examples and a code depot. All areas of Oracle best practices management, including the Oracle Optimal Flexible Architecture and testing and quality assurance best practices, are covered in detail.

The Ultimate Reference & Learning Guide for Oracle PL/SQL Over 100 PL/SQL Interview Questions, Answers, and Explanations It' s clear that Oracle is the future for enterprise information systems, and finding resources can be difficult. Oracle PL/SQL Interview Questions Answers, and Explanations guides you through your learning process. From helping you to assess your Oracle skills to evaluating candidates for a job, Oracle PL/SQL Interview Questions, Answers, & Explanations will help you understand what you really need to know. The book is organized around Programming, Troubleshooting, and understanding PL/SQL. Each question includes everything you need to know to master the interview or properly evaluate a candidate. More than just a rehash of Oracle documentation and sales presentations, each question is based on project knowledge and experience gained on successful high-profile Oracle implementations.

With tools for gaining as many as 30 times the execution speed, this handbook educates database administrators on how to rewrite SQL into PL/SQL and how to use advanced Oracle bulk array processing techniques to achieve high performance. Ready-to-use tips for saving hardware costs by running applications at peak efficiencies are provided for senior Oracle DBAs and developers, and powerful PL/SQL techniques are outlined.

Oracle Applications DBA Field Guide provides scripts, notes, guidelines, and references to guide you safely through the crucial day-to-day administration tasks that fall within your jurisdiction. This includes configuring, monitoring, performance tuning, troubleshooting, and patching. This book contains tips, techniques, and guidance for administering the highly complex Oracle E-Business Suite running Oracle9i or Oracle10g on UNIX or Linux servers--all in an easy reading and quick-to-navigate fo rmat. Even for the experienced database administrator, Oracle Applications are complicated to administer, and most other documentation out there is difficult to find and understand. Whether you're an experienced Oracle Applications DBA or a relative newcomer to Oracle 11i Applications (perhaps migrating from PeopleSoft, JD Edwards, or Siebel), this book will enable you to make a real impact on the ease and efficiency of your day-to-day administrative tasks, and will be relevant for Oracle Appli cations Release 12 and Fusion.

Prepare for the Oracle Certified Administrator Oracle Application Server 10g exam with help from this exclusive Oracle Press guide. Get complete coverage of all topics on the exam 1Z0-311, including installation, configuration, and management of Oracle Application Server 10g, as well as details on Oracle Internet Directory, Oracle HTTP Server, Oracle Single Sign-On Server, Oracle Portal, Oracle Application Server Containers for J2EE (OC4J), and Oracle Web Cache. In each chapter, you'll find cert ification objectives, examples, a two-minute drill, and a self-test to highlight what you've learned. This book and CD-ROM package is the most comprehensive preparation tool available for this OCA exam.

If you are constantly under time pressure from SLAs or product release deadlines, then pick up a copy of Pro Oracle 10g Performance Tuning. This practical field guide will help you diagnose and resolve common, everyday problems such as poorly performing SQL queries, database and session hang, and sudden slow performance of a production database. Author Soumendra Paik includes comprehensive demos of the Oracle performance diagnostic toolkit. You will learn to identify and analyze a performance b ottleneck, isolate the root cause, apply different possible resolutions, and then quantify performance improvements&emdash;all in a quick and effective manner.

JDBC Metadata, MySQL, and Oracle Recipes is the only book that focuses on metadata or annotation-based code recipes for JDBC API for use with Oracle and MySQL. It continues where the author's other book, JDBC Recipes: A Problem-Solution Approach, leaves off. This new edition is also a Java EE 5-compliant book, perfect for lightweight Java database development. And it provides cut-and-paste code templates that can be immediately customized and applied in each developer's application development.

Targeted at Oracle professionals who need fast and accurate working examples of complex issues, Oracle In-focus books target specific areas of Oracle technology in a concise manner. Plenty of working code is provided without a lot of theory, allowing database managers to solve their problems quickly without reviewing data that they already know. All code scripts are available for instant download from a companion web site.

Completely updated for Oracle Discoverer 10g Release 2, this Oracle Press guide explains how to use Oracle Discoverer -- the ad-hoc query, reporting, analysis, and Web -- publishing tool that empowers business users at all levels of an organization to gain immediate access to Business Intelligence. End users will learn to write queries, use the powerful analysis tools, and generate meaningful reports. Administrators will learn how to configure, edit, and use the analytic functions.

Even if you have limited programming experience, you can develop and deploy professional-quality applications using Oracle's new rapid web application development tool. Oracle HTML DB Handbook shows you how to quickly create secure and scalable web applications that can be instantly deployed. Learn how you can consolidate spreadsheets and desktop databases into an Oracle Database and share your applications over the web. You'll also get details on administration and security. Real-world sample p rojects get you started using Oracle HTML DB right away.

This textbook is not simply a study guide; it is written for individuals who have just a basic knowledge of databases and can be utilized in a course on this latest implementation of SQL from Oracle.

Designed to exploit Oracle 10g's SQL, this book is a comprehensive look at Oracle 10g's analytical functions, MODEL statements, and regular expressions. In addition, the book covers collection/object-oriented structures and introduces new Oracle 10g topics like SQL, XML, and statistical functions.

This guide to leveraging RAM-SAN technology shows Oracle DBAs how to create fast Oracle9i RAC databases. Techniques for leveraging RAM disk in an Oracle RAC and Grid environment are demonstrated including changes to initialization parameters and the selective use of SSD in large database environments (UNDO, REDO, and TEMP tablespaces on solid-state disk).

Targeted at Oracle professionals who need fast and accurate working examples of complex issues, Oracle In-focus books target specific areas of Oracle technology in a concise manner. Plenty of working code is provided without a lot of theory, allowing database managers to solve their problems quickly without reviewing data that they already know. All code scripts are available for instant download from a companion web site.

Students need a big-picture introduction to Oracle and they need specific examples and steps. This concise book covers all of the topics students need in a first class by using step-by-step techniques with a rich set of databases to provide students with practical experience - all in one book.