Oracle Database 18c
Data Warehousing
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 Performance Tuning Guide
HTML
PDF
Provides information about how to tune the performance of Oracle Database using Oracle performance tools.
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.
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.
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.
Data Mining API Guide
HTML
PDF
Provides reference information on Oracle Data Mining - Introduction, Using API, Data Mining API reference
Data Mining Concepts
HTML
PDF
Discusses the basic concepts underlying Oracle Data Mining. Includes an overview of the features of Oracle Data Mining and information about mining functions and algorithms.
Data Mining User's Guide
HTML
PDF
Explains how to use the SQL interface to Oracle Data Mining to create models and score data. This Guide also addresses administrative issues such as security, import/export, and upgrade for Oracle Data Mining.
OLAP DML Reference
HTML
PDF
Contains a complete description of the OLAP Data Manipulation Language (OLAP DML) used to define and manipulate analytic workspace objects.
OLAP Expression Syntax Reference
HTML
PDF
Describes the Oracle OLAP expression syntax used to generate information-rich content from the data stored in dimensional database objects such as cubes and cube dimensions.
OLAP Java API Developer's Guide
HTML
PDF
Provides guidance for developing client applications using the Oracle OLAP Java API.