Oracle Database Online Documentation 11g Release 2 (11.2)

Essentials

2 Day DBA covers general database administration tasks and concepts. Each 2 Day + book covers more specialized tasks and concepts for specific advanced topics. All tasks are presented in the Enterprise Manager GUI. Supporting documentation describes command line-based methods.

2 Day DBA

Provides a single source reference for administering Oracle Database in a small to midsize environment, using the graphical user interface of Oracle Enterprise Manager Database Control. 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.

Download As...

PDF for offline viewing

2 Day + Security Guide

Provides an introduction to securing an Oracle database. In addition to describing how to manage security in a default Oracle database, this guide includes beginning level tutorials for Oracle Label Security and Oracle Database Vault.

Download As...

PDF for offline viewing

2 Day + Performance Tuning Guide

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.

Download As...

PDF for offline viewing

Supporting Documentation

Supporting documentation treats advanced topics related to database administration. In general, the 2 Day + books refer you to these topics when needed.

Concepts

Describes Oracle Database architecture and essential topics for database administrators and developers.

Download As...

PDF for offline viewing

Administrator's Guide

Describes how to create, configure, and administer an Oracle database. Includes sections on Oracle Scheduler, Oracle Database Resource Manager, Oracle Restart, and distributed computing.

Download As...

PDF for offline viewing

Reference

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

Download As...

PDF for offline viewing

SQL Language Reference

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

Download As...

PDF for offline viewing

Performance Tuning Guide

Describes how to tune the performance of Oracle Database and SQL statements using Oracle performance tools in the command-line interface.

Download As...

PDF for offline viewing

Error Messages

Describes error messages that may appear while using products that are part of Oracle Database.

Download As...

PDF for offline viewing

SQL and PL/SQL

SQL statements and PL/SQL programs and packages are used extensively in administering Oracle databases.

SQL Language Reference

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

Download As...

PDF for offline viewing

SQL Language Quick Reference

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

Download As...

PDF for offline viewing

PL/SQL Language Reference

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.

Download As...

PDF for offline viewing

PL/SQL Packages and Types Reference

Describes the packages provided with the Oracle database server. The manual is intended for programmers, systems analysts, project managers, and others interested in developing database applications.

Download As...

PDF for offline viewing

SQL Developer User's Guide

Provides conceptual and usage information about Oracle SQL Developer, a graphical tool that enables you to browse, create, edit, and delete (drop) database objects; run SQL statements and scripts; edit and debug PL/SQL code; manipulate and export data; migrate third-party databases to Oracle; view metadata and data in third-party databases; and view and create reports.Note: This book is for an old release of SQL Developer. You are encouraged to use the latest available release. See http://www.oracle.com/technetwork/developer-tools/sql-developer/ for information about downloads and documentation.

Download As...

PDF for offline viewing

Advanced Application Developer's Guide

Explains topics that experienced application developers reference repeatedly.

Download As...

PDF for offline viewing

Clients for Database Administration

Oracle SQL Developer is a powerful easy-to-use GUI with browse, create, edit, and drag-and-drop capabilities for managing database objects, and creating and viewing reports. SQL*Plus is a command-line client used for running SQL statements and compiling PL/SQL code. SQL Developer has all the capabilities of SQL*Plus in a GUI-based interface.

SQL Developer User's Guide

Provides conceptual and usage information about Oracle SQL Developer, a graphical tool that enables you to browse, create, edit, and delete (drop) database objects; run SQL statements and scripts; edit and debug PL/SQL code; manipulate and export data; migrate third-party databases to Oracle; view metadata and data in third-party databases; and view and create reports.Note: This book is for an old release of SQL Developer. You are encouraged to use the latest available release. See http://www.oracle.com/technetwork/developer-tools/sql-developer/ for information about downloads and documentation.

Download As...

PDF for offline viewing

SQL*Plus Release Notes

Contains important information not included in the SQL*Plus User's Guide and Reference.

Download As...

PDF for offline viewing

SQL*Plus User's Guide and Reference

Contains a complete description of the SQL*Plus command-line interface to the Oracle Database, and a complete reference to SQL*Plus commands and syntax.

Download As...

PDF for offline viewing

SQL*Plus Quick Reference

Contains a complete list of SQL*Plus command syntax.

Download As...

PDF for offline viewing

Security

Detailed information on database features used to secure your data against unauthorized access.

Security Guide

Explains how to configure an Oracle database to use the default security features.

Download As...

PDF for offline viewing

Advanced Security Administrator's Guide

Explains how to configure and use Oracle Database Advanced Security. It covers stored data encryption.

Download As...

PDF for offline viewing

Enterprise User Security Administrator's Guide

Explains how to configure and use enterprise users, which are users defined in a directory. The guide also covers administrative tasks related to enterprise user security.

Download As...

PDF for offline viewing

Label Security Administrator's Guide

Explains how to configure and use Oracle Label Security, which provides row-level access control based on the virtual private database technology of Oracle Database Enterprise Edition.

Download As...

PDF for offline viewing

Database Vault Administrator's Guide

Explains how to configure an Oracle database to use Oracle Database Vault, which enables users to restrict and monitor administrative user access.

Download As...

PDF for offline viewing

Network Management

Oracle Net helps you manage connectivity, security, and performance across both Internet and intranet networks.

Net Services Reference

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

Download As...

PDF for offline viewing

Net Services Administrator's Guide

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

Download As...

PDF for offline viewing

Storage

Using Automatic Storage Management for Oracle databases.

Automatic Storage Management Administrator's Guide

This is the 11.2.0.3 draft version of the guide.

Download As...

PDF for offline viewing

Backup and Recovery

Use Recovery Manager (RMAN) or user-managed backup techniques to back up and recover Oracle databases.

Backup and Recovery User's Guide

A guide to backup and recovery of Oracle databases, including RMAN backup and recovery, RMAN data transfer, Oracle Flashback Technology, and user-managed backup and recovery

Download As...

PDF for offline viewing

Backup and Recovery Reference

A guide to backup and recovery of Oracle databases, including RMAN backup and recovery, RMAN data transfer, Oracle Flashback Technology, and user-managed backup and recovery

Download As...

PDF for offline viewing

Advanced Replication Management API Reference

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. It also includes reference information about data dictionary views that are important for Advanced Replication and security considerations for an Advanced Replication environment.

Download As...

PDF for offline viewing

UNIX and Windows Database Administration

Administration concepts and tasks specific to the Oracle Database on a specific operating system.

Administrator's Reference for Linux and UNIX-Based Operating Systems

Explains how to create, configure, and manage Oracle Database on Linux and UNIX-based operating systems.

Download As...

PDF for offline viewing

Platform Guide for Microsoft Windows

Provides platform-specific information for configuring and using Oracle Database software on the Windows platform. Topics discussed include: architecture, services, tools, configuration, administration, tuning, backup, accounts, passwords, user authentication, registry parameters, and application development.

Download As...

PDF for offline viewing

Testing

Real Application Testing User's Guide

Provides information about how to assure the integrity of database changes and manage test data using Oracle Real Application Testing, data masking, and data subsetting.

Download As...

PDF for offline viewing