Shulou(Shulou.com)05/31 Report--

This article introduces the relevant knowledge of "Oracle official document structure Analysis". In the operation of actual cases, many people will encounter such a dilemma. Then let the editor lead you to learn how to deal with these situations. I hope you can read it carefully and be able to achieve something!

Getting started page:

Some of the most basic documentation links are included here.

Concept, which includes some basic concepts and principles in the Oracle database. For example, the logical structure, physical structure, instance composition, optimizer, transaction and other knowledge of the database are described.

Reference, which includes dynamic performance view, data dictionary, initialization parameters and other information. If you have a parameter that doesn't know what it means, or if the field information in the v$ view is a little vague, you can find the corresponding description here. (there is an index at the bottom after the HTML is clicked in, and the ctrl+f lookup is relatively fast.) it also contains some 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 includes the syntax of the SQL statement in the Oracle database (plsql is not included). For example, create table syntax, functions, and expressions are all described here. If you have any syntax for sql statements that you don't know how to write, you can click on this document.

Administrator's Guide, this document contains a lot of content, almost all kinds of scenarios for managing Oracle database are described here. Various management tables, indexes, tablespaces, redo, etc. can be found here (online transport tablespaces are also described in this document)

Performance tuning guide, which contains optimization-related content, introduces the optimization methods, database examples and sql optimization. The details of the optimizer are explained here.

Database Administration page:

The main thing is that Administrator's Guide has been described above, here are some of the more important documents.

Net Services Reference, several important documents about monitoring are described in the documentation, such as tnsnames.ora, listener.ora, sqlnet.ora, etc. Questions related to monitoring can be found in this document.

Backup and Recovery User's Guide, the various uses of rman are described in the documentation. (there is a chapter about using rman for data transmission. If you are interested, you can take a look.)

Backup and Recovery Reference, mainly describes the syntax of rman.

Application Development page

PL/SQL Packages and Types Reference, this document includes the functions and parameter descriptions of various oracle self-built packages and functions. If you do not understand the package can be found here, for example, commonly used information about the dbms_stats package, the function of the package functions and stored procedures, instructions for parameters, examples can be found in this document.

PL/SQL Language Reference, this document describes the basic concepts, syntax, and so on of plsql programming. If you want to learn plsql programming, you can start with this document.

SQLJ Developer's Guide SQLJ heard this on pub. I don't know the details yet, but it feels advanced and easy to use. When plsql is unable to complete the task, you can use java stored procedures to solve the problem, for example, you want to get a list of files in the host directory. SQLJ provides an easy way to integrate plsql and java.

Workspace Manager Developer's Guide, which contains something about the versioning of workspace manager in oracle.

Installing and upgrading page:

When you need to install the oracle database, you can go to the Installing and upgrading link. The installation documentation for various operating systems is here. It is recommended to go through the documents when deploying the environment. Online articles may have problems of one kind or another on the basis of existing hardware because of environmental differences. Looking at the official documentation is the fastest way to deploy)

Grid Computing page:

Includes various documents for oracle grid infrastructure cluster software.

Automatic Storage Management Administrator's Guide, asm related documents, questions about asm can be found in this document.

Real Application Clusters Administration and Deployment Guide, including the content of database management and maintenance in RAC environment.

Clusterware Administration and Deployment Guide, mainly wrote various tools and commands of cluster software.

High Availability page:

It includes documentation for a variety of highly available technologies.

Data Guard Broker and Data Guard Concepts and Administration, needless to say, this is a document about Dataguard.

In 12c, goldengate takes over the stream task completely. If you are interested, you can also have a look.

Data Warehousing and Business Intelligence page:

Related technologies of data warehouse and business intelligence.

VLDB and Partitioning Guide, very large database... The content related to partition and parallel is actually here.

Utilities, I don't know how to use imp, expdp, sql*loader, external table, dbv, adrci, logminer, come here.

Unstructured Data and Content Management page:

Related to unstructured data. For example, object type, xmltype, oracle text and so on.

SecureFiles and Large Objects Developer's Guide, talked about the secure file technology used to store lob fields in 11g.

Text Application Developer's Guide and Text Reference, things related to full-text indexing.

This is the end of the content of "Oracle official document structure Analysis". Thank you for reading. If you want to know more about the industry, you can follow the website, the editor will output more high-quality practical articles for you!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.