Skip Navigation

Oracle Database Online Documentation 11g Release 1 (11.1)

Database Administration

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.

Provides information about how to assure the integrity of database changes using Oracle Real Application Testing.
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

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. 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

A quick start guide that teaches you how to perform day-to-day database performance tuning tasks using features provided by the 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

A database administration quick start guide that teaches you how to perform day-to-day database security tasks. The goal of this book is to help you understand the concepts behind Oracle database security. This book teaches you how to perform all common security tasks needed to secure your database. The knowledge you gain from completing the tasks in Oracle Database 2 Day + Security Guide helps you not only to better secure your data, but to meet common regulatory compliance requirements, such as the Sarbanes-Oxley Act.
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Supporting Documentation

The documents below provide more extensive reference and advanced task material related to database administration.

Explains how to create, administer, and monitor an Oracle database. Includes information about distributed processing and Oracle Scheduler.
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Describes how Oracle Database functions and lays a conceptual foundation for more detailed information contained in other Oracle Database manuals.
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Describes detailed ways to enhance Oracle performance by writing and tuning SQL properly, using performance tools, and optimizing instance performance. It also explains how to create an initial database for good performance and includes performance-related reference information. This book could be useful for database administrators, application designers, and programmers.
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

Provides information about how to use SQL Performance Analyzer to test database upgrades from Oracle Database 9i to Oracle Database 10g and subsequent releases.
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

SQL, PL/SQL, and PL/SQL Packages

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 PL/SQL packages and defined types supplied with Oracle Database. Packages are listed alphabetically with syntax, procedures and functions, and parameters described for each package.
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Clients for Database Administration

SQL*Plus is a command-line client used for running SQL statements and compiling PL/SQL code. SQL Developer provides all the same capabilities as SQL*Plus, as well as an easy-to-use, powerful drag-and-drop GUI for managing database objects and creating and viewing reports.

Describes 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; and view and create reports.
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Introduces SQL*Plus and its uses, and provides a description of each SQL*Plus command.
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Shows 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.

Provides a comprehensive overview of security for this database release, featuring security as a necessary, primary focus for Oracle installations. It provides the conceptual framework for understanding security requirements and threats as well as introducing the features, techniques, and policies for meeting those needs with Oracle products. The audience for this book includes system managers as well as users, database administrators, and application developers. This version addresses bug 7579601 and additional fixes throughout. It also includes additional material and tutorials for Chapter 9, "Verifying Security Access with Auditing."
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Provides an overview and detailed configuration information about database advanced security features. These features include network encryption, strong authentication (RADIUS, Kerberos, and SSL), and centralized user management that uses the Oracle Identity Management infrastructure (Enterprise User Security). The audience for this guide includes network security and enterprise user security administrators.
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Describes how to implement, configure, and administer Oracle Database users in Oracle Internet Directory, the directory service provided by the Oracle Identity Management platform.
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Describes how to use Oracle Label Security to protect sensitive data. It explains the basic concepts behind label-based security and provides examples to show how it is used.
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.

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

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

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.

Provides in-depth information on the mechanics of backup and recovery, and a guide to performing complex and less frequently performed backup and recovery tasks, including user-managed backup and recovery and performance tuning of backup and recovery.
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Describes RMAN syntax and recovery catalog views.
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.

Provides platform-specific information about administering and configuring Oracle Database 11g release 1 (11.1)
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices

Describes the features of Oracle Database for both Microsoft Windows (32-Bit) and Microsoft Windows (x64) software installed on a computer with an Intel (x86), AMD64, or Intel EM64T processor
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 using Oracle Real Application Testing.
Download As...

PDF for offline viewing

Mobi for Kindle

ePub for iBooks and mobile devices