2 Oracle Database 11g Documentation

This chapter lists the books available online that document Oracle® Database 11g.

2.1 Documentation Titles and Online Documentation Structure

All books are available in electronic format.

The following categories of documentation are available:

2.1.1 Oracle® Database 11g Windows Documentation

Table 2-1 Oracle® Database Windows Documentation

Documentation Part Number Description

Developer's Guides

Oracle Data Provider for .NET Developer's Guide

B28375-01

Describes provider-specific features and properties of ODP.NET. Oracle Data Provider for .NET (ODP.NET) is an implementation of Microsoft's ADO.NET interface and provides access to Oracle databases.

Oracle Database Extensions for .NET Developer's Guide

B28376-01

Provides introductory, installation, post-installation configuration, and usage information for Oracle Data Provider for .NET.

Oracle Services for Microsoft Transaction Server Developer's Guide

B28377-01

Provides introductory, installation, configuration, usage, and administration information for using Oracle Services for Microsoft Transaction Server. Microsoft Transaction Server is a proprietary Component Object Model transaction processing system that runs on an Internet or network server.

Oracle Objects for OLE Developer's Guide

B28378-01

Describes the concepts important to OO4O and the object classes. Oracle Objects for OLE (OO4O) allows easy access to data stored in Oracle databases with any programming or scripting language that supports the Microsoft COM Automation and ActiveX technology.

Oracle Provider for OLE DB Developer's Guide

B28431-01

Describes provider-specific features and properties of OraOLEDB. Oracle Provider for OLE DB (OraOLEDB) is based on an open standard that uses a set of Component Object Model interfaces for data access, in this case to Oracle databases.

Oracle COM Automation Feature Developer's Guide

B31223-01

Describes how Oracle COM Automation Feature provides a mechanism to manipulate COM objects through PL/SQL. This developer's guide provides introductory, installation, post-installation configuration, AND usage information FOR Oracle COM Automation Feature.


2.1.2 Oracle® Database 11g Server Library

Table 2-2 Oracle® Database Server Library

Documentation Part Number Description

Administration, Concepts, and Reference

Oracle Database Performance Tuning Guide

B28274-01

Describes detailed ways to enhance Oracle performance by writing and tuning SQL properly, using performance tools, and optimizing instance performance. It also explains how to create an initial database for good performance and includes performance-related reference information. This book could be useful for database administrators, application designers, and programmers.

Oracle Database 2 Day + Performance Tuning Guide

B28275-01

A quick start guide that teaches you how to perform day-to-day database performance tuning tasks using features provided by the Oracle Diagnostics Pack, Oracle Tuning Pack, and Oracle Enterprise Manager.

Oracle Database Heterogeneous Connectivity Administrator's Guide

B28277-02

Describes the Oracle approach to information integration in a heterogeneous environment. Describes Oracle Database Gateways and is an administrator's guide for these Oracle products.

Oracle Database Error Messages

B28278-01

Includes all database error messages.

Oracle Database New Features Guide

B28279-01

Oracle Database New Features Guide is addressed to people familiar with previous versions of Oracle Database who would like to become familiar with features, options, and enhancements that are new in this release of the database.

Oracle Database High Availability Overview

B28281-01

Describes Oracle's approach for a highly available database environment. Provides an overview of high availability and helps you to determine your high availability requirements. It also describes Oracle Database products and features that are designed to support high availability and describes the primary database architectures that can help your business achieve high availability.

Oracle Database SQL Language Quick Reference

B28285-01

Contains a high-level text description of the SQL syntax used to manage information in Oracle Database.

Oracle Database SQL Language Reference

B28286-01

Contains a complete description of Oracle SQL, the language used to manage information in Oracle Database.

Oracle Database Globalization Support Guide

B28298-01

Describes Oracle globalization support for the database. Explains how to set up a globalization support environment, choose and migrate a character set, customize locale data, do linguistic sorting, program in a global environment, and program with Unicode.

Oracle Globalization Development Kit Java API Reference

B28299-01

Describes APIs for the Oracle Globalization Development Kit.

Oracle Database Upgrade Guide

B28300-01

Explains the process of planning and executing database upgrades on Oracle Database server. In addition, this guide provides information about compatibility, about upgrading applications to the current release of Oracle, and about important changes in the current release, such as initialization parameter and data dictionary changes.

Oracle Database 2 Day DBA

B28301-01

Provides a single source reference for administering Oracle Database in a small to midsize environment. If you are familiar with computers, but unfamiliar with administering Oracle Database, and your computer has four CPUs or fewer, and you do not expect to support more than 500 users, this book is appropriate for you.

Oracle Database Administrator's Guide

B28310-01

Explains how to create and to manage Oracle Database. Includes information about distributed processing.

Oracle Database Concepts

B28318-01

Describes how Oracle Database functions and lays a conceptual foundation for more detailed information contained in other Oracle Database manuals.

Oracle Database Utilities

B28319-01

Describes how to use Oracle Database utilities to load data into a database, transfer data between databases, and maintain data. The utilities described include the new Data Pump export and import products, the original export and import products, SQL*Loader, external tables, the Metadata API, LogMiner, DBVERIFY, and DBNEWID.

Oracle Database Reference

B28320-01

Provides reference information about database initialization parameters, static data dictionary views, dynamic performance views, database limits, and SQL scripts that are part of Oracle Database system.

Oracle Database Sample Schemas

B28328-01

Describes the sample schemas included in the seed database that ships with Oracle Database 11g. These schemas are used in examples in Oracle documentation and curriculum materials and in demos on Oracle Technology Network.

Oracle Database Enterprise User Security Administrator's Guide

B28528-01

Describes how to implement, configure, and administer Oracle Database users in Oracle Internet Directory, the directory service provided by the Oracle Identity Management platform.

SQL*Plus User's Guide and Reference

B31189-01

Introduces SQL*Plus and its uses, and provides a description of each SQL*Plus command.

SQL*Plus Quick Reference

B31190-01

Shows iSQL*Plus buttons and icons, and iSQL*Plus and SQL*Plus command syntax.

Oracle Database JDBC Developer's Guide and Reference

B31224-01

Provides guidance for developers of JDBC-based applications and applets. This document can be read by anyone with an interest in JDBC programming, but assumes at least some prior knowledge of Java, Oracle PL/SQL, and Oracle databases.

Oracle Database JPublisher User's Guide

B31226-01

Describes the JPublisher utility for Java programmers who want classes in their applications to correspond to SQL or PL/SQL entities or server-side Java classes. JPublisher also provides features supporting Web services call-ins to the database and call-outs from the database.

Oracle Database SQLJ Developer's Guide and Reference

B31227-01

Describes how SQLJ enables application programmers to embed SQL operations in Java code in a way that is compatible with the Java design philosophy.

Application Development

Oracle XML DB Developer's Guide

B28369-01

This manual describes Oracle XML DB. It includes guidelines and examples for storing, generating, accessing, searching, validating, transforming, evolving, and indexing XML data in Oracle Database.

Oracle XML Developer's Kit Programmer's Guide

B28394-01

Introduces you to the Oracle XML Developer's Kit and how the various language components of the XDK can work together to generate and store XML data in a database or in a document outside the database. Examples and sample applications are introduced where possible.

Oracle Database Advanced Application Developer's Guide

B28424-01

Explains topics that experienced application developers reference repeatedly.

Oracle Database Data Cartridge Developer's Guide

B28425-01

Describes how to implement custom indexing and query optimization services and how to package and use these as a server extension called a data cartridge.

Application Express

Oracle Database 2 Day + Application Express Developer's Guide

B28551-01

Offers an introduction to application development using the Oracle Application Express development environment. This guide contains instructions that lead you through the process of setting up your development environment to quickly build an application. Through a series of exercises, you become familiar with basic functionality, the product user interface, and the underlying concepts to enable you to develop professional, fast, and secure applications.

Oracle Database Application Express Advanced Tutorials

B28842-01

Features a series of tutorials that demonstrate how to use the Oracle Application Express development environment to develop Web applications. Each tutorial offers step-by-step instructions that explain how to create applications and different types of application components.

Oracle Database Application Express Release Notes

B32257-01

Contains important information not included in the Oracle Application Express documentation.

Oracle Database Application Express User's Guide

B32258-01

Functions as a comprehensive, task-based reference on using the Oracle Application Express development environment. Oracle Application Express is a rapid Web application development tool for the Oracle database. Using only a Web browser and limited programming experience, you can develop professional, fast, and secure applications. Deployed applications require only a browser and access to an Oracle database running Application Express.

Application Reference

Oracle Database XML C API Reference

B28388-01

Provides information about XML related C APIs. It primarily lists the syntax of functions, methods, and procedures associated with these API.

Oracle Database XML C++ API Reference

B28389-01

Provides information about XML related C APIs. It primarily lists the syntax of functions, methods, and procedures associated with these APIs.

Backup and Recovery

Oracle Database Backup and Recovery User's Guide

B28270-01

Provides in-depth information on the mechanics of backup and recovery, and a guide to performing complex and less frequently performed backup and recovery tasks, including user-managed backup and recovery and performance tuning of backup and recovery.

Oracle Database Backup and Recovery Reference

B28273-01

Describes RMAN syntax and recovery catalog views.

Data Warehousing

Oracle Data Guard Concepts and Administration

B28294-01

Provides a comprehensive overview of Oracle Data Guard concepts and describes how to configure and implement standby databases that can take over production operations if your production database becomes unusable. This guide includes several database scenarios such as creating, recovering, failing over, switching over, configuring, and backing up standby and primary databases.

Oracle Data Guard Broker

B28295-01

Describes the Oracle Data Guard broker, a management and monitoring interface that automates many of the tasks involved in configuring and monitoring standby databases in an Oracle Data Guard configuration. This guide provides comprehensive descriptions and examples for using both the command-line interface and the Oracle Data Guard Manager graphical user interface.

Oracle Database Data Warehousing Guide

B28313-01

Provides conceptual, reference, and implementation material for using Oracle Database 10 in data warehouses. It covers the full range of data warehousing activities, from physical database design to advanced calculation techniques.

Oracle Database 2 Day + Data Warehousing Guide

B28314-01

Teaches you how to perform common day-to-day tasks necessary to implement and administer a data warehouse.

Language and Interface

Oracle Database PL/SQL Language Reference

B28370-01

Presents PL/SQL, the Oracle procedural extension of SQL, an advanced fourth-generation programming language. Explains the concepts behind PL/SQL and illustrates every facet of the language.

Oracle Database PL/SQL Packages and Types Reference

B28419-01

Describes the PL/SQL packages and defined types supplied with Oracle Database. Packages are listed alphabetically with syntax, procedures and functions, and parameters described for each package.

Pro*C/C++ Programmer's Guide

B28427-01

Describes how to develop C++ programs that use the SQL and PL/SQL database languages to access and manipulate Oracle data.

Pro*FORTRAN Supplement to the Oracle Precompilers Guide

B31229-01

Describes how to write FORTRAN programs that use SQL to access and manipulate Oracle data.

Pro*PL/1 Supplement to the Oracle Precompilers Guide

B31230-01

Describes how to write PL/1 programs that use SQL to access and manipulate Oracle data. An understanding of the material in the Programmer's Guide to the Oracle Precompilers is assumed.

Oracle Database Programmer's Guide to the Oracle Precompilers

B31231-01

This guide is a comprehensive user's guide and on-the-job reference to the Pro*COBOL and Pro*FORTRAN precompilers. It shows you step-by-step how to develop applications that use the powerful database language SQL to access and manipulate Oracle data.

Networking and Security

Oracle Database Net Services Administrator's Guide

B28316-01

Explains how to plan, configure, and manage enterprise-wide connectivity with Oracle Net Services.

Oracle Database Net Services Reference

B28317-01

Contains a complete listing and description of the control utility commands and configuration file parameters available for managing components of Oracle Net Services.

Oracle Database 2 Day + Security Guide

B28337-01

A database administration quick start guide that teaches you how to perform day-to-day database security tasks. The goal of this book is to help you understand the concepts behind Oracle database security. This book teaches you how to perform all common security tasks needed to secure your database. The knowledge you gain from completing the tasks in Oracle Database 2 Day + Security Guide helps you not only to better secure your data, but to meet common regulatory compliance requirements, such as the Sarbanes-Oxley Act.

Oracle Label Security Administrator's Guide

B28529-01

Describes how to use Oracle Label Security to protect sensitive data. It explains the basic concepts behind label-based security and provides examples to show how it is used.

Oracle Database Advanced Security Administrator's Guide

B28530-01

Provides an overview and detailed configuration information about database advanced security features. These features include network encryption, strong authentication (RADIUS, Kerberos, and SSL), and centralized user management that uses the Oracle Identity Management infrastructure (Enterprise User Security). The audience for this guide includes network security and enterprise user security administrators.

Oracle Database Security Guide

B28531-01

Provides a comprehensive overview of security for this database release, featuring security as a necessary, primary focus for Oracle installations. It provides the conceptual framework for understanding security requirements and threats as well as introducing the features, techniques, and policies for meeting those needs with Oracle products. The audience for this book includes system managers as well as users, database administrators, and application developers.

Oracle Real Application Clusters

Oracle Database 2 Day + Real Application Clusters Guide

B28252-01

Describes how to install, configure, and administer Oracle Clusterware and Oracle Real Application Clusters on a two-node system using Red Hat Linux.

Oracle Real Application Clusters Administration and Deployment Guide

B28254-01

Explains how to administer Oracle Real Application Clusters.

Oracle Real Application Clusters Installation Guide for Linux and UNIX

B28264-01

Explains Oracle Real Application Clusters setup and configuration procedures for Linux and UNIX as well as how to use Oracle tools for software installation and database creation.

Oracle Text

Oracle Ultra Search Administrator's Guide

B28330-01

Describes how to build web-based query applications using Oracle Ultra Search. Topics include crawling, indexing, and searching text content in databases or HTML pages. Java Server Pages (JSP) web-application examples are provided.

Others

Oracle Database Object-Relational Developer's Guide

B28371-01

Describes user-defined object data types and how to use these data types to model complex real-world entities as objects in the database.

Oracle Database SecureFiles and Large Objects Developer's Guide

B28393-01

Describes use of large object data types BLOB, CLOB, NCLOB, and BFILE in application development. You can use these data types to store and manipulate unstructured and semi-structured data in binary or character format. This book also describes APIs for working with LOBs in supported programmatic environments. New APIs that allow you to use LOBs 8 terabytes in size or larger, depending on your configuration, are described.

Streams and Replication

Oracle Streams Concepts and Administration

B28321-01

Contains conceptual information about Oracle Streams and information about configuring, administering, and monitoring an Oracle Streams environment. Also includes detailed examples of using Oracle Streams for various purposes.

Oracle Streams Replication Administrator's Guide

B28322-01

Contains conceptual information about Oracle Streams replication and about configuring, administering, and monitoring an Oracle Streams replication environment. Also includes detailed examples of configuring Oracle Streams replication environments.

Oracle Database Advanced Replication

B28326-01

Contains conceptual information about Oracle Advanced Replication. Also includes information about planning an Advanced Replication environment, an introduction to the Replication Management tool in Oracle Enterprise Manager, and information about troubleshooting Advanced Replication problems.

Oracle Database Advanced Replication Management API Reference

B28327-01

Contains reference information about and step-by-step instructions for using the replication management API, which is a set of PL/SQL packages for setting up and managing an Advanced Replication environment. Also includes reference information about data dictionary views that are important for Advanced Replication and security considerations for an Advanced Replication environment.

Oracle Streams Advanced Queuing Java API Reference

B28392-01

Describes features of application development and integration using the Oracle messaging system, Advanced Queuing. Includes the PL/SQL, C, Visual Basic, Java, and JMS interfaces to AQ and gateways to non-Oracle messaging systems.

Oracle Streams Advanced Queuing User's Guide

B28420-01

Describes features of application development and integration using the Oracle messaging system, Advanced Queuing. Includes the PL/SQL, C, Visual Basic, Java, and JMS interfaces to AQ and gateways to non-Oracle messaging systems.


2.1.3 Oracle® Database 11g OLAP Documentation

Table 2-3 Oracle® Database OLAP Documentation

Documentation Part Number Description

Oracle OLAP User's Guide

B28124-01

Explains how applications developers and DBAs can develop business intelligence applications, design and develop dimensional data stores (analytic workspaces), and administer Oracle Database with the OLAP option.

Oracle OLAP DML Reference

B28126-01

Contains a complete description of the OLAP Data Manipulation Language (OLAP DML) used to define and manipulate analytic workspace objects.

Oracle OLAP Java API Developer's Guide

B28127-01

Assists Java programmers who are responsible for creating applications that perform analysis using Oracle OLAP.

Oracle OLAP Java API Reference

B28128-01

Describes the classes and methods in the Oracle OLAP Java API for querying analytic workspaces and relational data warehouses.


2.1.4 Oracle® Database 11g Data Mining Documentation

Table 2-4 Oracle® Database Data Mining Documentation

Documentation Part Number Description

Oracle Data Mining Concepts

B28129-01

Discusses the basic concepts underlying Oracle Data Mining. Details of programming with the Java and PL/SQL interfaces are discussed in the Oracle Data Mining Application Developer's Guide.

Oracle Data Mining Administrator's Guide

B28130-01

Describes how to install the Oracle Data Mining software and how to perform other administrative functions common to all Oracle Data Mining environments on both UNIX and Windows platforms.

Oracle Data Mining Application Developer's Guide

B28131-01

Describes how to use the Oracle Data Mining PL/SQL and Java APIs and the SQL scoring functions to create data mining applications.

Oracle Data Mining Java API Reference

B28132-01

Describes the classes and methods in the Oracle Data Mining Java API, the JDM JSR-73-compliant API for data mining. The Java API supports a full range of data mining activities, including model building and scoring, data preparation, and import/export of models.


2.1.5 Oracle® Database 11g Spatial Documentation

Table 2-5 Oracle® Database Spatial Documentation

Documentation Part Number Description

Oracle Database Semantic Technologies Developer's Guide

B28397-01

Provides usage and reference information about Oracle Database support for semantic technologies, specifically Resource Description Framework (RDF) and a subset of the Web Ontology Language (OWL).

Oracle Spatial GeoRaster Developer's Guide

B28398-01

Describes GeoRaster, a feature of Oracle Spatial that lets you store, index, query, analyze, and deliver GeoRaster data, that is, raster image data and its associated Spatial vector geometry data, plus metadata.

Oracle Spatial Topology and Network Data Models Developer's Guide

B28399-01

Provides usage and reference information about the topology data model and network data model capabilities of Oracle Spatial.

Oracle Spatial Developer's Guide

B28400-01

Provides usage and reference information for indexing and storing spatial data and for developing spatial applications. Includes an appendix about Oracle Locator 10 and its relationship to Oracle Spatial.

Oracle Spatial Java API Reference

B28401-01

Consists of interfaces and classes that support features available with Oracle Spatial, including GeoRaster and the topology and network data models, and with MapView, which is packaged with Oracle Application Server.


2.1.6 Oracle® Database 11g Java Documentation

Table 2-6 Oracle® Database Java Documentation

Documentation Part Number Description

Oracle Ultra Search Java API Reference

B28329-01

Contains all Oracle Ultra Search APIs. Oracle Ultra Search provides APIs for performing various tasks including obtaining query results and displaying e-mail messages.

Oracle Database XML Java API Reference

B28391-01

Describes the Java APIs for XML.

Oracle Database 2 Day + Java Developer's Guide

B28765-01

Illustrates how to access and modify data in Oracle Database using a simple Java Database Connectivity (JDBC) application. This guide uses the Oracle JDeveloper integrated development environment (IDE) to create the application.

Oracle Database Java Developer's Guide

B31225-01

Provides a general overview on how to develop, load, and execute Java applications in the database.


2.1.7 Oracle® Database 11g Linux x86 Documentation

Table 2-7 Oracle® Database Linux x86 Documentation

Documentation Part Number Description

Oracle Database Gateway Installation and Configuration Guide for AIX 5L Based Systems (64-Bit), HP-UX PA-RISC (64-Bit), HP-UX Itanium, Solaris Operating System (SPARC 64-Bit), Linux x86, and Linux x86-64

B31042-01

Describes how to install and configure Oracle Database Gateway for Sybase, Informix, Teradata, Microsoft SQL Server, and ODBC on UNIX based platforms.

Oracle Database Gateway for IMS, VSAM, and Adabas Installation and Configuration Guide for AIX 5L Based Systems (64-Bit), HP-UX PA-RISC (64-Bit), Solaris Operating System (SPARC 64-Bit), Linux x86, and Linux x86-64

B32526-01

Describes the installation and configuration of Oracle Transparent Gateway for IMS, VSAM, and Adabas, which enables Oracle client applications to access IMS, VSAM, and Adabas data through Structured Query Language (SQL). The gateway, with the Oracle Database, creates the appearance that all data is located on a local Oracle Database, even though the data can be widely distributed.


2.1.8 Oracle® Database 11g Release Notes Documentation

Table 2-8 Oracle® Database Release Notes Documentation

Documentation Part Number Description

Oracle Database Release Notes for Linux

B32001-01

These Release Notes contain important information not included in the Oracle Database documentation for Linux.

Oracle Warehouse Builder Release Notes

B40098-01

Contains important information not included in the Oracle Warehouse Builder documentation.

Oracle Database Gateway Release Notes for AIX 5L Based Systems (64-Bit), HP-UX PA-RISC (64-Bit), HP-UX Itanium, Solaris Operating System (SPARC 64-Bit), Linux x86, and Linux x86-64

E10398-01

Contains important information that was not included in the platform-specific or product-specific documentation for this release.


2.1.9 Oracle® Database 11g Installation Guide Documentation

Table 2-9 Oracle® Database Installation Guide Documentation

Documentation Part Number Description

Oracle Clusterware Installation Guide for Linux

B28263-01

Provides configuration information for network and system administrators, and database installation information for database administrators (DBAs) who install and configure Oracle Clusterware for Linux.

Oracle Database Installation Guide for Linux

B32002-01

Describes how to install and configure Oracle Database on Linux.

Oracle Database Client Installation Guide for Linux

B32003-01

Describes how to install and configure Oracle Database client on Linux.

Oracle Database Quick Installation Guide for Linux x86

B32281-01

Describes how to quickly install Oracle Database on Linux x86 systems.

Oracle Database Client Quick Installation Guide for Linux x86

B32282-01

Describes how to quickly install Oracle Database client on Linux x86 systems.

Oracle Database Examples Installation Guide

E10402-01

Describes how to install and configure the products available on the Oracle Database Examples installation media.


2.1.10 Oracle® Database 11g Documentation Library

Table 2-10 Oracle® Database Documentation Library

Documentation Part Number Description

Oracle Database Readme

B28280-01

Describes important last-minute features and changes not included in Oracle Database Documentation Library.

Oracle Database Licensing Information

B28287-01

Describes Oracle Database licensing.

Oracle Database Documentation Readme

Q15595-01

Describes Oracle Database documentation.