How to view Oracle official documents

Concept

It contains some basic concepts and principles of oracle database, such as database logical structure, physical structure, instance structure, optimizer, transaction and so on. PDF 460 pages

Reference

Including dynamic performance view, data dictionary, initialization parameters, etc., if there are parameters do not know the meaning, or v$ view field information is vague, you can find a description here, use the html version of the ctrl+f to find faster. It also includes other hard restrictions on the database, the name of the waiting event, the description of the background process, and so on.

SQL Language Reference

This document contains the sql syntax of the oracle database (excluding plsql), such as create table, etc.

Administrator's Guide

Various scenarios for managing oracle databases are here, including tables, indexes, tablespaces, redo, etc.

Performance tuning guide

Contains optimization related content, introduces optimization methods, database examples and sql optimization.

Database Administration page

Because administrator's guide has already described it, here are a few more important documents

Net Services Reference

The document describes several important files about monitoring, such as tnsnames.ora, listener.ora, sqlnet.ora, etc.

Backup and Recovery User's Guide

Describes the various uses of rman

Application Development page

PL/SQL Packages and Types Reference

Including a variety of oracle self-built packages and functions, parameter description. If you have any packages you don't know, you can find them here, such as dbms_stats.

PL/SQL language Reference

Basic concepts, syntax and so on of plsql programming.

SQLJ Developer's Guide

SQLJ, JAVA related content

Workspace Manager Developer's Guide

Something about the workspace manager version of oracle

Installing and upgrading page

Need to install oracle refer to here.

Grid Computing page

Including various documents of oracle grid infrastructure cluster software

Automatic Storage Management Administrator's Guide

Asm related documents

Real Application Clusters Administration and Development Guide

Including the content of database management and maintenance in RAC environment.

Clusterware Administration and Deployment Guide

It mainly writes various tools and commands of cluster software.

High Availability page

Contains a variety of highly available documents

Data Guard Broker and Data Guard Concepts and Administration

About Data guard documentation

Data Warehousing and Business Intelligence page

Technologies related to data Warehouse and Business Intelligence

VLDB and Partitioning Guide

Very large database,... Partition and parallel related content

Utilities

Imp, expdp, sql*loader, external table, dbv, adrci, logminer

Unstructured Data and Content Management page

Related to unstructured data, such as object type, xml type, oracle text

SecureFiles and Large Objects Developer's Guide

This paper describes the content of secure file technology used to store lob fields in 11g.

Text Application Developer's Guide and Text Reference

Related to full-text indexing