Home Database Oracle Oracle Database Release 23 Oracle Database 23ai Books Browse the Oracle Database 23ai bookshelf below for a particular title, or download a zip file containing all the books. Advanced Cluster File System Administrator's Guide HTML PDF Describes how to administer Oracle Advanced Cluster File System (Oracle ACFS) for Oracle Database. Advanced Security Guide HTML PDF Explains how to configure and use Oracle Database Advanced Security Transparent Data Encryption (TDE) and Oracle Data Redaction. Automatic Storage Management Administrator's Guide HTML PDF Describes how to administer Oracle Automatic Storage Management (Oracle ASM) for Oracle Database. Autonomous Health Framework User’s Guide HTML PDF This book describes how to use Oracle Autonomous Health Framework diagnostic components - Oracle ORAchk, Cluster Health Monitor, Oracle Trace File Analyzer Collector, Oracle Cluster Health Advisor, Memory Guard, and Hang Manager. Backup and Recovery Technical Architecture HTML Describes the Technical Architecture for Oracle Backup and Recovery components Clusterware Administration and Deployment Guide HTML PDF The Oracle Clusterware Administration and Deployment Guide describes the Oracle Clusterware architecture and provides an overview of this product. This book also describes administrative and deployment topics for Oracle Clusterware. Data Cartridge Developer's Guide HTML PDF 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. Data Guard Broker HTML PDF 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. Data Guard Concepts and Administration HTML PDF 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. Data Provider for .NET Developer's Guide HTML PDF Describes provider-specific features and properties of ODP.NET. Oracle Data Provider for .NET is an implementation of Microsoft's ADO.NET interface and provides access to Oracle databases. Database Administrator's Guide HTML PDF Describes how to create, configure, and administer an Oracle database. Includes sections on Oracle Scheduler, Oracle Database Resource Manager, Oracle Restart, and distributed computing. Database Advanced Queuing Java API Reference HTML Describes the Java APIs for application development and integration using the Oracle messaging system, Advanced Queuing. Database Backup and Recovery Reference HTML PDF Provides detailed descriptions of the Recovery Manager (RMAN) commands and recovery catalog views. Database Backup and Recovery User's Guide HTML PDF Explains how to use Recovery Manager (RMAN) to back up, recover, and duplicate a database, and how to use Oracle Flashback Technology to restore all or a portion of your data to a previous state. Database Client Installation Guide for Linux HTML PDF Describes how to install and configure Oracle Database client on Linux. Database Concepts HTML PDF Describes Oracle Database architecture and essential topics for database administrators and developers. Database Data Warehousing Guide HTML PDF Provides conceptual, reference, and implementation material for using Oracle Database in data warehousing. It covers the full range of data warehousing activities, from physical database design to advanced calculation techniques. Database Development Guide HTML PDF Describes various features that are available in the Oracle database and how to use them in real time applications. Database Free Installation Guide for Linux HTML PDF Contains information about installing Oracle Database Free on Linux X86-64 for Release 23. Database Gateway for APPC Installation and Configuration Guide for AIX 5L Based Systems (64-Bit), HP-UX Itanium, Solaris Operating System (SPARC 64-Bit), Linux x86, and Linux x86-64 HTML PDF Provides Oracle applications with seamless access to IBM mainframe data and services through Remote Procedure Call (RPC) processing. Database Gateway for APPC Installation and Configuration Guide for Microsoft Windows HTML PDF Provides Oracle applications with seamless access to IBM mainframe data and services through Remote Procedure Call (RPC) processing. Database Gateway for APPC User's Guide HTML PDF Provides Oracle applications seamless access to virtually any APPC-enabled system, including IBM mainframe data and services through Remote Procedure Call (RPC) processing. Database Gateway for DRDA User's Guide HTML PDF Provides users with transparent access to DB2. Database Gateway for Informix User's Guide HTML PDF Describes the Oracle Database Gateway for Informix, which enables Oracle client applications to access Informix data through Structured Query Language (SQL). Database Gateway for ODBC User's Guide HTML PDF Describes the Oracle Database Gateway for ODBC, which enables Oracle client applications to access non-Oracle systems data through Structured Query Language (SQL). Database Gateway for SQL Server User's Guide HTML PDF Describes the Oracle Database Gateway for SQL Server, which enables Oracle client applications to access SQL Server data through Structured Query Language (SQL). Database Gateway for Sybase User's Guide HTML PDF Describes the Oracle Database Gateway for Sybase, which enables Oracle client applications to access Sybase data through Structured Query Language (SQL). Database Gateway for Teradata User's Guide HTML PDF Describes the Oracle Database Gateway for Teradata, which enables Oracle client applications to access Teradata data through Structured Query Language (SQL). Database Gateway for WebSphere MQ Installation and User's Guide HTML PDF Provides access to WebSphere MQ services. This gateway requires a system that is capable of running 64-bit applications. Database Gateway Installation and Configuration Guide for AIX 5L Based Systems (64-Bit), HP-UX Itanium, Solaris Operating System (SPARC 64-Bit), Linux x86, and Linux x86-64 HTML PDF Provides Oracle Database Gateway installation and configuration information. Database Gateway Installation and Configuration Guide for Microsoft Windows HTML PDF Describes how to install Oracle Database Gateway for Sybase, Informix, Teradata, SQL Server, ODBC, and DRDA on Microsoft Windows (32-bit) and Microsoft Windows (64-bit) platform. Database Globalization Development Kit Java API Reference HTML Describes Java APIs for Oracle Database Globalization Development Kit (GDK) Database Globalization Support Guide HTML PDF 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. Database In-Memory Guide HTML PDF Describes the architecture, configuration, and administration of the In-Memory Column Store Database Licensing Information User Manual HTML PDF Describes Oracle Database licensing. If you have a question about your licensing needs, contact your Oracle sales representative. Database Net Services Administrator's Guide HTML PDF Explains how to plan, configure, and manage enterprise-wide connectivity with Oracle Net Services. Database Net Services Reference HTML PDF Contains complete listing with descriptions of the control utility commands and configuration file parameters available for managing components of Oracle Net Services. Database Performance Tuning Guide HTML PDF Provides information about how to tune the performance of Oracle Database using Oracle performance tools. Database PL/SQL Language Reference HTML PDF 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. Database PL/SQL Packages and Types Reference HTML PDF Describes the PL/SQL packages provided with the Oracle database server that extend database functionality and provide PL/SQL access to SQL features. Database Reference HTML PDF Provides reference information about database initialization parameters, static data dictionary views, and dynamic performance views that are part of Oracle Database. Database Release Notes HTML PDF Contains information about new features, changes, unsupported products, preinstallation requirements, generic and platform-specific bug fixes, and known issues that are not included in the Oracle Database Documentation Library. Database Sample Schemas HTML PDF Sample schemas provide a common platform for examples in each release of the Oracle Database. The sample schemas are a set of interlinked database schemas. Database Security Guide HTML PDF Explains how to configure an Oracle database to use the default security features Database Transactional Event Queues and Advanced Queuing User's Guide HTML PDF Describes features of application development and integration using Oracle Database Transactional Event Queues (TEQ) and Advanced Queuing (AQ). This information applies to versions of the Oracle Database server that run on all platforms, unless otherwise specified. Database Transactional Event Queues Java API Reference HTML Describes the client-side Kafka Java APIs for the Oracle messaging system, Transactional Event Queues (TxEventQ). Database Vault Administrator's Guide HTML PDF Describes how to register and administer Oracle Database Vault Developer's Guide to the Oracle Precompilers HTML PDF Describes how to develop applications using the Oracle precompilers and the SQL and PL/SQL database languages to access and manipulate Oracle data. Enterprise User Security Administrator's Guide HTML PDF Get Started with Java Development HTML PDF Provides getting started information to the application developers on how to use Java to access and modify data in Oracle Database. Get Started with Oracle Database Development HTML PDF An introduction to application development for developers who are new to Oracle Database. Explains general concepts behind development with Oracle Database, introduces basic features of SQL and PL/SQL, provides references to in-depth information elsewhere in Oracle Database library, and shows how to create a simple application. Get Started with Performance Tuning HTML PDF Explains how to perform day-to-day database performance tuning tasks using features provided by Oracle Diagnostics Pack, Oracle Tuning Pack, and Oracle Enterprise Manager Cloud Control. Global Data Services Concepts and Administration Guide HTML PDF Provides dynamic load balancing, failover, and centralized service management for a set of replicated databases that offer common services. Graph Developer's Guide for Property Graph HTML PDF Graph Developer's Guide for RDF Graph HTML PDF Provides usage and reference information about Oracle Database support for semantic technologies, including storage, inference, and query capabilities for data and ontologies based on Resource Description Framework (RDF), RDF Schema (RDFS), and Web Ontology Language (OWL). Graph Java API Reference for Property Graph (Javadoc) HTML Graph JavaScript API Reference for Property Graph Visualization HTML Graph Python API Reference for Property Graph HTML Heterogeneous Connectivity User's Guide HTML PDF Describes Oracle's approach to information integration in a heterogeneous environment. Describes Oracle Database Gateways and is a user's guide for these Oracle products. High Availability Overview and Best Practices HTML PDF Presents Oracle best practices for deploying a highly available environment, helps you determine your availability requirements, and describes the database architectures that can help your business achieve high availability. Java Developer's Guide HTML PDF Describes how to develop, load, and run Java applications in Oracle Database. JDBC Developer's Guide HTML PDF Describes how to use Oracle JDBC drivers to develop powerful Java database applications. JSON Developer's Guide HTML PDF This manual describes the use of JSON data that is stored in Oracle Database. It covers how to store, generate, view, manipulate, manage, search, and index it. JSON-Relational Duality Developer's Guide HTML PDF This manual describes JSON-document views of relational data that is stored in Oracle Database. It covers how to create, query, and update such views, which automatically entails updating the underlying relational data. Label Security Administrator's Guide HTML PDF Describes how to register and administer Oracle Label Security Multitenant Administrator's Guide HTML PDF Describes how to create and configure multitenant container databases (CDBs), pluggable databases (PDBs), and application containers. Object-Relational Developer's Guide HTML PDF Explains how to use the object-relational features of Oracle Database. ODBC Developer’s Guide HTML PDF This book describes how to use Oracle ODBC drivers to develop powerful database applications. Oracle AI Vector Search Technical Architecture HTML Oracle AI Vector Search Technical Architecture Oracle AI Vector Search User's Guide HTML PDF This guide describes the Oracle AI Vector Search feature. Oracle C++ Call Interface Developer's Guide HTML PDF Presents the Oracle C++ Call Interface, an application program interface that enables applications written in C++ to interact with one or more Oracle databases. To extend the functionality of code generated by the Object Type Translator, programmers may want to add code in the OTT-generated file. The OTT can distinguish between OTT-generated code and user-generated code by looking for some predefined markers (tags). Oracle Call Interface Developer's Guide HTML PDF Describes the Oracle Call Interface (OCI) which is an application programming interface (API) that allows applications written in C or C++ to interact with Oracle Database. Oracle Database 23ai New Features Guide HTML PDF Oracle Database 23ai is the next long-term support release of Oracle Database. It includes over 300 new features with a focus on artificial intelligence (AI) and developer productivity. Oracle Database 23ai Technical Architecture HTML Explore the technical architecture of Oracle Database 23ai Oracle Database API for MongoDB HTML PDF Oracle Database API for MongoDB translates the MongoDB wire protocol into SQL statements that are executed by Oracle Database. It lets developers who have MongoDB skill sets write JSON document-store applications for Oracle Database that use drivers and tools that understand the MongoDB protocol. Oracle Database JavaScript Developer's Guide HTML PDF Describes the method to run JavaScript in Oracle Database, either with persistent MLE modules or with ad-hoc code execution through the DBMS_MLE package. Oracle Database Testing Guide HTML PDF Provides information about how to assure the integrity of database changes and manage test data using Oracle Real Application Testing. Oracle Database Upgrade Guide HTML PDF Guides you through the process of planning and performing upgrades for Oracle Database. This book also provides information about compatibility, upgrading applications, and changes in the new release that affect upgrading Oracle Database. Oracle Database Utilities HTML PDF Describes how to use Oracle Database utilities to load data into a database, transfer data between databases, and maintain data. The topics discussed include Data Pump Export, Data Pump Import, SQL*Loader, external tables and associated access drivers, the Automatic Diagnostic Repository Command Interpreter (ADRCI), DBVERIFY, DBNEWID, LogMiner, the Metadata API, original Export, and original Import. Oracle Database XStream Java API Reference 23ai HTML Oracle Globally Distributed Database Guide HTML PDF Create, deploy, and manage a sharded database using Oracle Sharding Oracle Interactive Technical Architecture Diagrams HTML Oracle Interactive Technical Architecture Diagrams Oracle MAA Reference Architectures HTML PDF Oracle REST Data Services API HTML Oracle True Cache Technical Architecture HTML Oracle True Cache Technical Architecture Oracle True Cache User's Guide HTML PDF This book provides an overview of Oracle True Cache and documents the steps to configure it. Oracle® Database JDBC Java API Reference HTML Provides Java API reference for Java Database connectivity. Oracle® Database RAC FAN Events Java API Reference HTML Provides easy access to Oracle Fast Application Notification (FAN) events. Oracle® Database Reactive Streams Ingestion Library Java API Reference HTML Provides Java API reference for Reactive Streams Ingestion Library that enables efficient data streaming into Oracle Database in a nonblocking way. Oracle® Database Real Application Security Java API Reference HTML Documents two Java packages: - oracle.security.xs contains the APIs for using lightweight user sessions - oracle.security.xs.admin contains the APIs for administering lightweight user session Oracle® Database Real Application Security Session Service Java API Reference HTML Documents one Java package: - oracle.security.xs.ee.session contains the APIs for using an application session service. Oracle® Database XML Java API Reference HTML Describes the Java APIs for XML. Oracle® REST Data Services Java API Reference HTML Provides Java API reference for Oracle REST Data Services. Oracle® Universal Connection Pool Java API Reference HTML Provides Java API reference for Universal Connection Pool for JDBC. Pro*C/C++ Developer's Guide HTML PDF Describes how to develop C++ programs that use the SQL and PL/SQL database languages to access and manipulate Oracle data. Pro*COBOL Developer's Guide HTML PDF Describes how to develop COBOL programs that use the database languages SQL and PL/SQL to access and manipulate Oracle data. Pro*FORTRAN Supplement to the Oracle Precompilers HTML PDF Supplements the Oracle Database Programmer's Guide to the Oracle precompilers to provide additional information on how to develop FORTRAN programs that use the database languages SQL and PL/SQL to access and manipulate Oracle data. Provider for DRDA User's Guide HTML PDF For customers who have a large investment in DB2-based applications, this document describes how to migrate to Oracle Database while keeping these applications largely unchanged. Providers for ASP.NET Developer's Guide HTML PDF Provides introductory, installation, postinstallation configuration, and usage information for using these providers with ASP.NET services and controls. Real Application Clusters Administration and Deployment Guide HTML PDF Describes the Oracle Real Application Clusters (Oracle RAC) architecture and provides an overview of this product, including Oracle Real Application Clusters One Node (Oracle RAC One Node). Real Application Security Administrator's and Developer's Guide HTML PDF Describes how to implement Real Application Security on the database. Real Application Security is a new feature in Oracle Database 12c. Real Application Security is a database authorization model that enables end-to-end security for multitier applications. It provides an integrated solution to securing the database and application user communities. Also, it advances the security architecture of Oracle Database to meet existing and emerging demands of applications developed for the Internet. REST APIs for Clusterware HTML The REST APIs for Oracle Clusterware enable you to remotely run commands on your cluster in the Oracle Cloud, at remote physical locations or locally provisioned. With the remote processing of REST interface commands, you can retrieve information about that processing, including output, error codes, and processing duration. In some cases, a command generates a file as output. In such cases, the REST interface also provides a Uniform Resource Identifier (URI) to retrieve the file. The REST interface provides secure support for Oracle Clusterware CLUVFY, CRSCTL, and SRVCTL command line interfaces (CLIs). SecureFiles and Large Objects Developer's Guide HTML PDF This guide explains what are Large Objects(LOBs), different types of LOBs, their usage and utilities, configuring LOBs, and how to use the LOBs in real time applications. Spatial Developer's Guide HTML PDF Provides usage and reference information for indexing and storing spatial data and for developing spatial applications using Oracle Spatial. Spatial GeoRaster Developer's Guide HTML PDF Provides usage and reference information for the GeoRaster feature of Oracle Spatial, which lets you store, index, query, analyze, and deliver raster data (raster image and gridded data and its associated metadata). Spatial Java API Reference HTML Provides Javadoc-generated information about interfaces and classes that support features available with Oracle Spatial, including GeoRaster, the Topology and Network Data Model features, the location tracking server, and the map visualization component (formerly called MapViewer). Spatial Map Visualization Developer's Guide HTML PDF Describes how to use the Oracle Spatial map visualization component, which renders maps showing different kinds of spatial data. It is intended primarily for programmers who develop applications that require maps to be drawn. Spatial Map Visualization Oracle Maps HTML5 JavaScript API Reference HTML Provides JSdoc-generated reference information for the Oracle Spatial Map Visualization Component (formerly called MapViewer) Oracle Maps HTML5 JavaScript API. Spatial REST API HTML REST APIs for Spatial GeoRaster and Network Data Model Contraction Hierarchies. Spatial Studio Guide HTML Spatial Topology and Network Data Model Developer's Guide HTML PDF Provides usage and reference information about the Topology and Network Data Model features of Oracle Spatial. SQL Language Quick Reference HTML PDF Contains a high-level text description of the SQL syntax used to manage information in Oracle Database. SQL Language Reference HTML PDF Contains a complete description of Oracle SQL, the language used to manage information in Oracle Database. SQL Translation and Migration Guide HTML PDF Describes the installation, configuration, and administration tasks for all activities related to migrating applications to Oracle Database from other databases, including DB2, MySQL, and Sybase. SQL Tuning Guide HTML PDF Describes how to perform SQL tuning, which is the iterative process of improving SQL statement performance to meet specific, measurable, and achievable goals. SQL*Plus User's Guide and Reference HTML PDF Contains a complete description of the SQL*Plus command-line interface to Oracle Database, and a complete reference to SQL*Plus commands and syntax. SQLJ Developer's Guide HTML PDF Provides guidance to developers on SQLJ programming. This document can be read by anyone with an interest in SQLJ programming, but assumes at least some prior knowledge of Java, SQLJ, PL/SQL, and Oracle database. Text Application Developer's Guide HTML PDF Provides information for building applications with Oracle Text. Text Reference HTML PDF Provides reference information for building applications with Oracle Text. Universal Connection Pool Developer's Guide HTML PDF Provides instructions for using Oracle Universal Connection Pool. VLDB and Partitioning Guide HTML PDF Contains an overview of very large database (VLDB) topics, with emphasis on partitioning and parallel execution as a key component of the VLDB strategy. Workspace Manager Developer's Guide HTML PDF Provides usage and reference information about Oracle Workspace Manager, which enables applications to create workspaces and to group different versions of table row values in different workspaces. XML C API Reference HTML PDF Describes Oracle XML Developer's Kit (XDK) and Oracle XML DB APIs for the C programming language. It primarily lists the syntax of functions, methods, and procedures associated with these APIs. XML C++ API Reference HTML PDF Describes Oracle XML Developer's Kit (XDK) and Oracle XML DB APIs for the C++ programming language. This manual primarily lists the syntax of functions, methods, and procedures associated with these APIs. XML DB Developer's Guide HTML PDF 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. XML Developers Kit Programmers Guide HTML PDF Provides information to application developers who need to use components of the Oracle XML Developer's Kit (XDK) to generate and store XML data in a database or in a document outside the database. XStream Guide HTML PDF Contains conceptual information about XStream. Also contains instructions for configuring and using XStream.
