Skip Navigation

Oracle Database Online Documentation 11g Release 2 (11.2)

Database Administration

"Essentials" covers everyday database administration tasks, as performed using the Enterprise Manager GUI. "Supporting Documentation" includes in-depth concept, task and reference material.

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.

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

Mobi for Kindle

ePub for iBooks and mobile devices

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

Mobi for Kindle

ePub for iBooks and mobile devices

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

Mobi for Kindle

ePub for iBooks and mobile devices

Supporting Documentation

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

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

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

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

Mobi for Kindle

ePub for iBooks and mobile devices

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

Mobi for Kindle

ePub for iBooks and mobile devices

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

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

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

Mobi for Kindle

ePub for iBooks and mobile devices

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

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

SQL and PL/SQL

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

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

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

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

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

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

Mobi for Kindle

ePub for iBooks and mobile devices

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

Mobi for Kindle

ePub for iBooks and mobile devices

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

Mobi for Kindle

ePub for iBooks and mobile devices

Explains topics that experienced application developers reference repeatedly.
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

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.

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

Mobi for Kindle

ePub for iBooks and mobile devices

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

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

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

Mobi for Kindle

ePub for iBooks and mobile devices

Contains a complete list of SQL*Plus command syntax.
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Security

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

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

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

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

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

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

Mobi for Kindle

ePub for iBooks and mobile devices

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

Mobi for Kindle

ePub for iBooks and mobile devices

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

Mobi for Kindle

ePub for iBooks and mobile devices

Network Management

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

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

Mobi for Kindle

ePub for iBooks and mobile devices

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

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Storage

Using Automatic Storage Management for Oracle databases.

This is the 11.2.0.3 draft version of the guide.
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Backup and Recovery

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

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

Mobi for Kindle

ePub for iBooks and mobile devices

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

Mobi for Kindle

ePub for iBooks and mobile devices

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

Mobi for Kindle

ePub for iBooks and mobile devices

UNIX and Windows Database Administration

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

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

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

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

Mobi for Kindle

ePub for iBooks and mobile devices

Testing

Oracle Real Application Testing enables you to perform real-world testing of Oracle Database.
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

Mobi for Kindle

ePub for iBooks and mobile devices