This IBM Redbooks publication explores the steps for installing Oracle 9i RAC in an IBM eServer Cluster 1600. GPFS is implemented in the Cluster as the file system of choice for Oracle code and database files.
Performance and availability considerations are presented to show system architects, system administrators, and database administrators how to implement various features of a high performance, high availability database cluster environment.
This book also presents a set of high availability tests and scenarios to help in considering these aspects in the planning and implementation phases.

Table of contents
Chapter 1. Introduction
Chapter 2. Typical Oracle9i RAC configurations
Chapter 3. Planning and implementation
Chapter 4. Oracle9i RAC installation and configuration
Chapter 5. Implementing RAC over GPFS
Chapter 6. High availability test scenarios
Appendix A. Operating system fileset levels
Appendix B. Troubleshooting
Appendix C. HACMP cluster configuration output
Appendix D. Oracle9i RAC configuration files and sample scripts

Dive deep into the internals of query tuning and optimization in SQL Server 2005 with this comprehensive reference. Understanding the internals of SQL Server helps database developers and administrators to better create, access, and effectively process information from enterprise data. Written by experts on SQL Server, this volume from the Inside Microsoft SQL Server series of books focuses on query tuning and optimization. Youll take an in-depth look at the best ways to make queries more efficient and effective, while maximizing existing resources. Includes extensive code samples and table examples to help database developers and administrators understand the intricacies and help promote mastery of query tuning and optimization.

Product Description
Oracle Application Server 10 J2EE Deployment and Administration  focuses on the latest version of Oracle’s fully J2EE-certified application server (previously called Oracle9iAS). Oracle Corp. is aggressively attacking this market with a new lost-cost version of the server, as well as a program to move BEA customers onto Oracle free of charge. Adoption interest is growing rapidly amidst favorable reports regarding performance and reliability.Deploying and configuring J2EE applications are some of the trickiest processes in J2EE development, and they unfortunately receive scant attention in general J2EE texts. This book is a focused, no-frills guide to getting J2EE applications up and running on 10  It covers Oracle’s J2EE container, OC4J (available free of charge for development purposes), in full detail. It moves on to explain how to best configure and use the various enterprise-level features that come with the commercial editions. This is  the book for anyone wanting to stay ahead in the world of Oracle’s application servers.

Updated for the latest database management systems, this introductory guide will get you up and running with SQL quickly. Whether you need to write database applications, perform administrative tasks, or generate reports, Learning SQL, Second Edition, will help you easily master all the SQL fundamentals. Each chapter presents a self-contained lesson on a key SQL concept or technique, with numerous illustrations, annotated examples, and exercises to let you practice the skills you learn.

Updated for the latest database management systems — including MySQL 6.0, Oracle 11g, and Microsoft’s SQL Server 2008 — this introductory guide will get you up and running with SQL quickly. Whether you need to write database applications, perform administrative tasks, or generate reports, Learning SQL, Second Edition, will help you easily master all the SQL fundamentals.

Transform your organization into a personalized, user-focused workplace using the detailed information in this comprehensive Oracle Press guide. Oracle WebCenter 11g Handbook shows you how to build Enterprise 2.0 applications that facilitate collaboration and foster innovation. You’ll work with task flows and content systems, employ social networking tools, develop portals and composite applications, and deploy runtime customization. Debugging, security, and application tuning are also covered in this practical resource.

• Develop, test, and deploy dynamic enterprise applications, portals, and portlets
• Design data-backed rich Internet applications using Oracle JDeveloper 11g and Oracle WebLogic Server
• Work with Oracle Content Server and Oracle Secure Enterprise Search
• Customize applications at runtime using Oracle Composer and metadata services
• Use the resource catalog to deliver personalized search results to end users
• Integrate RSS feeds, forums, wikis, and blogs with Oracle WebCenter social computing services
• Implement the latest Oracle Application Development Framework security tools
• Extend functionality using mashups, composite applications, and third-party add-ons
• Understand the Web 2.0 and portal technologies behind Oracle Fusion Applications

Install and Configure Grid Control to Manage Your Oracle Landscape

Build a robust grid computing infrastructure with guidance from an Oracle expert who developed and taught the Grid Control Deep Dive class to Oracle Consulting. Featuring real-world examples and best practices, Oracle Enterprise Manager 10g Grid Control Implementation Guide explains how to reliably and cost-effectively deploy a dynamic Grid Control environment. Learn how to lay the preinstallation groundwork, configure targets for monitoring, create services, implement security, and fine-tune performance. YouAnd#39;ll also get full coverage of backup and recovery strategies and high-availability techniques.

• Prepare infrastructure hosts for Grid Control rollout
• Install the Oracle management repository, service, and agents
• Select the Grid Control installation options that fit your needs
• Discover and manage host, database, and application server targets
• Set target metrics and policies according to best practices
• Optimize performance and availability of your Grid Control framework
• Secure the Grid Control framework to protect data transmitted between components

Oracle 10g Data Warehousing

Book Description
New edition of successful book with Oracle employees and consultants as authors.

For the past ten years, O’Reilly’s Oracle PL/SQL Programming has been the bestselling book on PL/SQL, Oracle’s powerful procedural language. Packed with examples and helpful recommendations, the book has helped everyone–from novices to experienced developers, and from Oracle Forms developers to database administrators–make the most of PL/SQL.

The fourth edition is a comprehensive update, adding significant new content and extending coverage to include the very latest Oracle version, Oracle Database 10g Release 2. It describes such new features as the PL/SQL optimizing compiler, conditional compilation, compile-time warnings, regular expressions, set operators for nested tables, nonsequential collections in FORALL, the programmer-defined quoting mechanism, the ability to backtrace an exception to a line number, a variety of new built-in packages, and support for IEEE 754 compliant floating-point numbers.

The new edition adds brand-new chapters on security (including encryption, row-level security, fine-grained auditing, and application contexts), file, email, and web I/O (including the built-in packages DBMS_OUTPUT, UTL_FILE, UTL_MAIL, UTL_SMTP, and UTL_HTTP) and globalization and localization.

Co-authored by the world’s foremost PL/SQL authority, Steven Feuerstein, this classic reference provides language syntax, best practices, and extensive code, ranging from simple examples to complete applications–making it a must-have on your road to PL/SQL mastery. A companion web site contains many more examples and additional technical content for enhanced learning.

The new edition of this must-have pocket guide boils down the most vital information from Oracle PL/SQL Programming, the bestseller that many consider “the Bible” for PL/SQL development. Indispensable for new and seasoned Oracle database developers  alike, this pocket guide summarizes features available in Oracle’s powerful new product– Oracle9i –and provides essential information on PL/SQL block structure, fundamental language elements, control statements, and use of procedures, functions, packages, triggers, Oracle objects, external procedures, and methods of calling Java  classes from PL/SQL. O’Reilly’s Pocket References have become a favorite among developers and database administrators everywhere. By providing a wealth of important details in a concise, well-organized format, these handy books deliver just what you need to complete the task at hand. When you’ve reached a sticking point in your work and need to get to a solution quickly, the new edition of Oracle PL/SQL Language Pocket Reference is the book you’ll want to have.

Oracle provides many tools for designing, developing, administering, and securing distributed database systems. With these tools, data in multiple databases is accessible just as if it were stored in a single database. This book describes how you can use multiple databases and both Oracle8 and Oracle7 distributed system features to best advantage. Aimed at both DBAs and developers, it covers:

Benefits and tradeoffs of distributed database systemsHow to install and configure a distributed system How to use Oracle’s networking products, SQL*Net and Net8, for distributed processingHow classic database design concepts extend to distributed systems and particularly to OracleSecurity considerations for distributed systemsHow to configure and administer Oracle’s distributed database features (read-only snapshots, multi-master replication, updateable snapshots, procedural replication, and conflict resolution)

This book covers both Oracle8 and Oracle7 syntax, includes a complete API reference for Oracle’s built-in distributed system packages (DBMS_REPACT, DBMS_SNAPSHOT), and comes with a diskette containing a wealth of helpful scripts and utilities.

About the Author
Charles Dye is the database architect for Excite, Inc. (www.excite.com), where he is responsible for the design and implementation of the databases theat supply content to some of the world’s busiest Web sites. Prior to joining Excite, he was the senior database administrator for The Dialog Corporation. Charles also operates a small but growing consultancy with clients in the San Francisco Bay area and Hong Kong. Once upon a time, before fleeing the East Coast for California skies, Charles taught math and physics at the Georgetown Day School in Washington DC. Charles is a frequent speaker at regional and national Oracle events such as Oracle Open World and IOUG-A Live. His favorite topics are distributed databases in general and advanced replication in particular. He also writes for the Northern California Oracle Users Group newsletter and is an active contributor to the Oracle Internet list server. Look for Charles’ upcoming O’Reilly book, Oracle Distributed Systems, available later in 1998. Charles lives in Los Altos, California, with his wife Kathy, daughter Natalie, and labrador Jed.