Now in its second edition, this best-selling book by Tom Kyte of Ask Tom fame continues to bring you some of the best thinking on how to apply Oracle Database to produce scalable applications that perform well and deliver correct results. Tom has a simple philosophy: you can treat Oracle as a black box and just stick data into it or you can understand how it works and exploit it as a powerful computing environment. If you choose the latter, then you'll find that there are few information managem ent problems that you cannot solve quickly and elegantly. This fully revised second edition covers the latest developments in Oracle Database 11g. Each feature is taught in a proof-by-example manner, not only discussing what it is, but also how it works, how to implement software using it, and the common pitfalls associated with it.

Introduction to Oracle Discoverer 3i to 10g - New Horizons EditionBeginners course which main focus is to introduced End-Users with Little or No experiences with Oracle Discoverer reporting tools to achieve a functional level of knowledge in report creation, business objects usage and application interaction. This is a lab based book.

Centralize and simplify enterprise infrastructure administration using the detailed information contained in this Oracle Press guide. Oracle Enterprise Manager 10g Control Handbook shows you how to implement a grid-based management system and maintain on-demand access to critical services. Develop rollout plans, configure hardware and software, deploy targets and agents, control access, and distribute business reports. This authoritative resource also explains how to generate reliable backups, i mplement top-down performance monitoring, and maximize system availability.

Centralize and simplify enterprise infrastructure administration using the detailed information contained in this Oracle Press guide. Oracle Enterprise Manager 10g Control Handbook shows you how to implement a grid-based management system and maintain on-demand access to critical services. Develop rollout plans, configure hardware and software, deploy targets and agents, control access, and distribute business reports. This authoritative resource also explains how to generate reliable backups, i mplement top-down performance monitoring, and maximize system availability.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

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.

Install and configure Oracle Database 10g on a Linux enterprise platform. This book explains how to set up, administer, monitor, and tune Oracle Database 10g on Linux. You will also learn how to implement High Availability solutions as well as handle backup, recovery, and replication. This exclusive Oracle Press guide is the ideal resource for all Oracle DBAs working in a Linux environment.

This book is written with the objective of providing the students or professionals with the knowledge of how to develop and manipulate a relational database through the medium of the Internet. It provides a hands-on approach toward applying the database application concepts for Web development. In an academic environment, the book can be adopted in any class or course that emphasizes relational database application concepts and/or Web application development. This textbook goes beyond mere refin ements of database or Web application concepts. It contains many distinct features and presents concepts in a significant new way. These features together provide a complete package for Web application development.

This is a unique, one-volume guide to the administration and management of the Oracle database. Fully revised and updated from its best-selling 9i predecessor, this edition covers all new features, with fully field-tested examples--not just "showcase" examples. This book covers the new 10g management and performance tools and provides essential primers on Unix, Linux and Windows NT administration and on core SQL and PL/SQL programming techniques. And it provides everything the new and aspring O racle DBA needs to build and admisiter complex Oracle 10g databases.

This is a defining book on the Oracle database for any developer or DBA who works with Oracle-driven database applications. Tom has a simple philosophy: you can treat Oracle as a black box and just stick data into it or you can understand how it works and exploit it as a powerful computing environment. If you choose the latter, then you will find that there are few information management problems that you cannot solve quickly and elegantly. Each feature is taught in a proof-by-example manner, n ot only discussing what it is, but also how it works, how to implement software using it, and the common pitfalls associated with it. This fully revised edition covers both the 9i and 10g versions. It also comes with a CD containing a searchable PDF of the 8i version of the book. Tom has fully revised and expanded the architecture-related sections from Expert One-on-One Oracle (a searchable PDF of which is included on the CD accompanying this book), and added substantial new material. He focus es solely on 9i and 10g architecture in this book and refers to the CD for 8i-specific details. The number of changes will surprise you. In summary, this book provides a one-stop resource containing deep wisdom on the design, development and administration of Oracle applications, written by one of the world's foremost Oracle experts, Thomas Kyte.

The Most Authoritative OCA/OCP Exam Guide Available Prepare to pass the OCA and OCP Oracle Database 10g certification exams with help from this Oracle Press guide. With complete coverage of all the material on Exam #1Z0-042 Oracle Database 10g: Administration I and Exam #1Z0-043 Oracle Database 10g: Administration II, this book covers everything you need to know to pass both exams. Inside, you'll find helpful exam tips, hundreds of practice questions, and real-world exercises. This comprehensive guide serves as both a study tool and an on-the-job reference. Get full details on all exam objectives, including how to: Install Oracle Database 10g and create a database Use SQL, SQL*Plus, iSQL*Plus, and PL/SQL Create and manage database user accounts Configure Oracle Networking Manage shared servers Monitor, tune, and troubleshoot a database Handle database backup, restore, and recovery Use Oracle Recovery Manager and Oracle Flashback Configure and manage security Use Automatic Storage Manag ement and Resource Manager Automate administrative tasks Included on the CD-ROM Electronic Practice Test engine with two full practice exams Complete electronic book

This book should satisfy those who want a different perspective than the official Oracle documentation. It will cover all important aspects of a data warehouse while giving the necessary examples to make the reading a lively experience. Tuning a data warehouse database focuses on large transactions, mostly requiring what is known as throughput. Throughput is the passing of large amounts of information through a server, network and Internet environment, backwards and forwards, constantly! The ul timate objective of a data warehouse is the production of meaningful and useful reporting, from historical and archived data. The trick is to make the reports print within an acceptable time frame. A data model contains tables and relationships between tables. Tuning a data model involves Normalization and Denormalization. Different approaches are required depending on the application, such as OLTP or a Data Warehouse. Inappropriate database design can make SQL code impossible to tune. Poor dat a modeling can have a most profound effect on database performance since all SQL code is constructed from the data model.

Oracle Database 10g Insider Solutions is a must-have reference guide for all Oracle professionals. It provides much-needed information on best practices, tips, and techniques in debugging, installation, deployment, and tuning of the Oracle 10g database. You can draw upon the experience and knowledge of these authors to find creative ways to put your Oracle database to work. The authors will also address common and not-so-common installation concerns, database administration, development, and tun ing. Oracle Database 10g Insider Solutions will bring you the insider information that you can't get anywhere else.

Everything a DBA needs to know in one volume--this is the must-have reference for anyone working with the Oracle database, and it's been fully revised and updated for Oracle Database 10g. Co-author Kevin Loney is the all-time, best-selling Oracle Press author. Maintain a high-performance Oracle enterprise database with help from this exclusive Oracle Press guide. Oracle Database 10g DBA Handbook explains how to install Oracle Database 10g, or upgrade from an earlier version, and take full advan tage of all the new and improved management, scalability, availability, and security features. Written by Oracle experts, the book covers Automatic Undo Management, Oracle Real Application Clusters, Oracle Recovery Manager, Oracle Data Guard, and much more.

Here's the comprehensive and affordable self-study solution you need to prepare for the Oracle Database 10g Administration I and Administration II exams. These Study Guides were developed to meet the exacting requirements of today's Oracle certification candidates. In addition to the consistent and accessible instructional approach that has earned Sybex the reputation as the preferred publisher for IT certification exam candidates worldwide, each book provides: * Clear and concise information on database administration with Oracle 10g * Practical examples and insights drawn from the authors' real-world experiences * Leading-edge exam preparation software, including a test engine and electronic flashcards

Here's the book you need to prepare for the Oracle Database 10g Administration II exam, 1Z0-043. This Study Guide was developed to meet the exacting requirements of today's Oracle certification candidates. In addition to the consistent and accessible instructional approach that has earned Sybex the "Best Study Guide" selection in CertCities Readers' Choice Awards for two consecutive years

Explaining how to use the powerful Oracle10g automatic features for simple database administration, this book has complete coverage for 10g Automatic Storage Management (ASM), 10g Automatic Workload Repository (AWR), Automatic Database Diagnostic Monitor (ADDM), Automatic SGA Management (ASM), and the SQL Tuning Advisor. Demonstrated is how a non-Oracle person can quickly install and configure Oracle database 10g for automatic database administration and how, in less than a day, a complete Oracl e10g database can be ready to use. Also explained is easy disk and file management with the 10g Automatic Storage Management and how the 10g Automatic Workload Repository collects important Oracle performance statistics.

This guide for using Dataguard technology covers all areas of disaster recovery, standby databases, and automatic Oracle failover. The details of how Oracle10g's improved Dataguard provides a comprehensive solution for disaster recovery while keeping a low TCO are discussed. Descriptions of the concepts and architecture of standby databases as well as the implementation and management of Dataguard are provided. Tips for success in configuration and first-time implementation of Dataguard includin g the internal working of Dataguard Broker and Dataguard with Recovery Manager are revealed.

Here's the book you need to prepare for the Oracle Database 10g Administration I exam, 1Z0-042. This Study Guide was developed to meet the exacting requirements of today's Oracle certification candidates. In addition to the consistent and accessible instructional approach that has earned Sybex the "Best Study Guide" selection in CertCities Readers Choice Awards for two consecutive years

Develop flexible, cross-platform Web applications using Oracle Application Server 10g and this exclusive Oracle Press guide. Take advantage of the full support for all major Web development languages, APIs, and frameworks and learn to create and test applications quickly, interface with the Oracle database seamlessly, and deploy your applications to the Web securely. Inside you'll find full details on J2EE integration, Oracle Forms 10g , Oracle Reports 10g , OracleAS Discoverer 10g , OracleAS Po rtal, and Oracle JDeveloper 10g

Here's the book you need to prepare for Oracle's 10g upgrade exam, Oracle Database 10g: New Features for Administrators (1Z0-040). This Study Guide was developed to meet the exacting requirements of today's Oracle certification candidates. In addition to the consistent and accessible instructional approach that has earned Sybex the "Best Study Guide" selection in CertCities Readers Choice Awards for two consecutive years

Oracle 10g Data Warehousing is a guide to using the Data Warehouse features in the latest version of Oracle Oracle Database 10g. Written by people on the Oracle development team that designed and implemented the code and by people with industry experience implementing warehouses using Oracle technology, this thoroughly updated and extended edition provides an insiders view of how the Oracle Database 10g software is best used for your application. It provides a detailed look at the new features of Oracle Database 10g and other Oracle products and how these are used in the data warehouse. This book will show you how to deploy the Oracle database and correctly use the new Oracle Database 10g features for your data warehouse. It contains walkthroughs and examples on how to use tools such as Oracle Discoverer and Reports to query the warehouse and generate reports that can be deployed over the web and gain better insight into your business. This how-to guide provides step by step instruct ions including screen captures to make it easier to design, build and optimize performance of the data warehouse or data mart. It is a must have reference for database developers, administrators and IT professionals who want to get to work now with all of the newest features of Oracle Database 10g.

Prepare for the Oracle Certified Professional Oracle Database 10 g New Features for Administrators exam with help from this exclusive Oracle Press guide. Get complete coverage of all topics on the upgrade exam, including installation, configuration, application tuning, database management, backup and recovery, security, and more. In each chapter, you'll find examples, practice questions, lab questions, a two-minute drill, and a chapter summary to highlight what you've learned. This book and CD-R OM package is the most comprehensive preparation tool available for this OCP exam.

This book is based on the very latest version of Oracle's fully J2EE- certified Application Server (previously called Oracle9iAS). Oracle Corp.Adoption interest is growing rapidly amidst favorable reports regarding performance and reliability. Deploying J2EE applications and configuring the application server are known to be the most tricky and non-standard elements of J2EE development, and thus they receive scant attention in general J2EE texts. This book provides a focused, no-frills guide to getting J2EE applications up and running on 10G. It covers Oracle's J2EE container, OC4J (available for free for development purposes), in full detail and then moves on to explain how to configure and use the various enterprise-level features that come with the commercial editions.

The new Oracle Application Server offers a wide range of functionality, including Java runtime and development tools, portal development tools, business intelligence, single sign-on identify management, and much more. It's so powerful and complex, in fact, that many people who use the product (or are considering using it) are familiar with only a portion of the entire range of its capabilities. The choices can be overwhelming. Few people grasp how the larger issues--such as the interplay between components or the various architectural choices in the product--play out in the Oracle Application Server. This new guide provides the perfect introduction to the Oracle Application Server for users of any level. Regardless of which of the server's capabilities you use, you'll benefit from this tightly focused, all-in-one technical overview. It's written for anyone who is concerned with using and managing web servers, doing Java development and deployment, using Oracle's own tools--like Forms a nd Reports, using or developing for Oracle Portal, or those who use and administer business intelligence, mobile or integration software. Divided into three concise sections, the book covers server basics, core components, and server functionality. The book leads with the history of Oracle Application Server, its architecture, management, standards, and third-party support for languages and tools such as Java, Perl, and HTTP. The next section covers Oracle's web server, containers for Java web c aching, and the server's security features. And finally, the book discusses HTML development, Java development, and Oracle development. Although the book refers mainly to Oracle Application Server 10g, the authors also describe features in earlier product releases where necessary, particularly Oracle9i Application Server. More comprehensible than a large reference and more detailed than a primer, the book provides a foundation for understanding and using Oracle Application Server effectively and efficiently. Readers concentrate on the most important issues and components of the server, focusing primarily on principles rather than syntax. Designed to be the ideal first OracleAS book, Oracle Application Server 10g Essentials offers Oracle application developers and administrators everything they need to know about this powerful server.

Obtain the solid foundation you need to become an effective database programmer with this nuts-and-bolts PS/SQL book from Oracle Press. Step-by-step coverage includes storing, retrieving, and manipulating data, and a broad range of SQL and PL/SQL functions and tools. Real-life examples and hands-on projects help you see how to apply what you have learned.

Create web and database applications with Oracle JDeveloper 10g--the complete, integrated Java development environment--with help from this comprehensive, real-world resource. Many chapters contain hands-on practices and source code examples reinforcing vital concepts. It's all here--from the nuts-and-bolts of J2EE applications, servlets, and JavaServer Pages technology to advanced development using the Oracle Application Development Framework. From the exclusive publishers of Oracle Press books , Oracle JDeveloper 10g Handbook will have you developing Java-based applications in no time.

Oracle security expert David Knox explains how to design and develop an integrated, secure Oracle environment. In my experience in the security world, including 32 years at the Central Intelligence Agency, I've not found anyone with more experience in the theory and practice of protecting your data than David Knox.

Refined to focus on the newest and most important practical features in Oracle Database 10g, this new edition of the most popular Oracle book of all time will thoroughly cover the most meaningful aspects with a straightforward combination of prose, conceptual diagrams, and code listings.

Revealing the secrets for quickly implementing and tuning Oracle RAC database systems, this book covers all areas of Oracle Real Application Clusters including Oracle10g new features. Oracle DBAs who are charged with configuring and implementing a RAC clusters database will benefit from this complete guide to the installation as well as configuration and design of Oracle Real Application Clusters. Information is supplied on expert internals of shared disk technology, raw devices and RAID with RA C, the internal concurrency, resource coordination, and the locking mechanism within RAC. Also explained are Transparent Application Failover (TAF) and monitoring and tuning Oracle10g RAC applications.

Grid Computing has at its foundation the necessity that all computing components be readily available at all times, so they can be used when needed. Therefore, the ultimate success of any grid implementation must have at its core the resources to always be up. As such, the Oracle's High Availability offerings are a central component to its future strategy. This will be the first comprehensive book available on this core topic.

The essential reference for PL/SQL has been revised and expanded, featuring all new examples throughout based on the new Oracle Database 10g sample schema plus a CD with all the book's code as well as development environments. Written by a senior member of the technical staff on the Diagnostics and Defect Resolution (DDR) team in Oracle's Server Technologies Division.

Written by members of the Oracle XML group, this is a must-have reference for all IT managers, DBAs, and developers who want to learn the best practices for using XML with Oracle's XML-enabled products. Includes real-world case studies based on the authors' experience managing Oracle's XML Discussion Forum--a community of 20,000+ XML component users.

Provides beginning DBAs and developers with a solid foundation in the database administration and programming basics needed to embark on an Oracle career. The focus is on Oracle Database 10g, but you'll get the fundamentals applicable to all Oracle database releases.

From the exclusive publisher of Oracle Press books, here is an architectural and technical reference on how to use Oracle Application Server 10g to Web-enable Oracle databases for application server systems. You'll find coverage of installation, configuration, and tuning, using Java with Oracle Application Server 10g, and much more.

The new edition of this classic book, Oracle Essentials 3rd Edition: Oracle Database 10g, distills a vast amount of knowledge into an easy-to-read volume covering every aspect of the Oracle database. Readers of all levels will learn about Oracle's features and technologies, including the product line, architecture, data structures, networking, concurrency, tuning, and much more. Featuring focused text, abundant illustrations, and helpful hints, the new edition offers a valuable overview of Oracl e's Database 10g--the industry's first database to support grid computing. Recent releases such as Oracle 9i and 8i are also covered. More comprehensible than a large reference, and more detailed than mot primers, this book covers all the information you'll need to install and run the Oracle databases, as well as the conceptual background you'll want to understand how they work. If you're new to Oracle or upgrading to Oracle 10g, you'll find this all-in-one guide essential.

This volume will take you from novice to master, covering not only how to use SQL but also the Oracle extensions to SQL. The examples feature the sample schemas available with Oracle Database 10g, and free code will be available for download.

Here is an invaluable overview of all the cutting-edge features of Oracle's latest database release, Oracle Database 10g. Includes expert commentary throughout from world-renowned Oracle guru Jonathan Lewis. This is an ideal resource for decision-makers and IT staff preparing for upgrades or migration.

There are three parts to tuning an Oracle database: data modeling, SQL code tuning and physical database configuration. A data model contains tables and relationships between tables. Tuning a data model involves normalization and de-normalization. Different approaches are required depending on the application, such as OLTP or a Data Warehouse. Inappropriate database design can make SQL code impossible to tune. Poor data modeling can have a most profound effect on database performance since all SQL code is constructed from the data model. Poorly written SQL code is often a culprit of performance problems and is expensive to rectify. However, tuning of SQL code is generally cheaper than changing the data model. SQL code tends to be contained inside independent blocks within applications or stored procedures. Physical database tuning involves hardware resource usage, networking and various other Oracle things such as configuration and file distribution. Physical configuration is often a culprit of poor performance where Oracle is installed with defaults, and never altered by an expert.

For those database administrators intending to upgrade or those who need to know the new features that will affect the entire Oracle database world, this book relates all of the features of this new database. The complete details of the database's new features, including database management and administration enhancements, are discussed. Improvements and additions to security, architecture, Internet features, real application clusters, and performance are also detailed.

2001-2011 Oracle-Books.com