Graphic for Getting Started page

Oracle Database Online Documentation 12c ReleaseĀ 1 (12.1)

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

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

Provides an introduction to securing an Oracle database using the default security features, such as how to secure the database installation and configuration or manage encryption. It includes beginning level tutorials for creating secure application roles, Oracle Database Vault policies, Oracle Virtual Private Database policies, Oracle Data Redaction policies, Oracle Label Security policies, and unified auditing policies.
Download As...

PDF for offline viewing

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 Cloud Control.
Download As...

PDF for offline viewing

Supporting Documentation

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

PDF for offline viewing

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

PDF for offline viewing

Provides reference information about database initialization parameters, static data dictionary views, and dynamic performance views that are part of Oracle Database.
Download As...

PDF for offline viewing

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

PDF for offline viewing

Provides information about how to tune the performance of Oracle Database using Oracle performance tools.
Download As...

PDF for offline viewing

Describes how to perform SQL tuning, which is the iterative process of improving SQL statement performance to meet specific, measurable, and achievable goals.
Download As...

PDF for offline viewing

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 and PL/SQL are fundamental to all Oracle application development. SQL is the language used to query and modify Oracle databases. PL/SQL is used to create and call triggers, stored procedures and functions, and PL/SQL packages. Other programming technologies depend upon SQL and PL/SQL to interact with the Oracle Database server.

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

PDF for offline viewing

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

PDF for offline viewing

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

Describes the PL/SQL packages provided with the Oracle database server that extend database functionality and provide PL/SQL access to SQL features.
Download As...

PDF for offline viewing

Provides usage information for developers (all experience levels) of databases and database applications.
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.

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

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

PDF for offline viewing

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

PDF for offline viewing

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.

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

PDF for offline viewing

Explains how to configure and use Oracle Database Advanced Security Transparent Data Encryption (TDE) and Oracle Data Redaction.
Download As...

PDF for offline viewing

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

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

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

Describes how to implement Real Application Security on the database. Real Application Security is a new feature in Oracle Database 12c. Real Application Security is a database authorization model that enables end-to-end security for multitier applications. It provides an integrated solution to securing the database and application user communities. Also, it advances the security architecture of Oracle Database to meet existing and emerging demands of applications developed for the Internet.
Download As...

PDF for offline viewing

Documents two Java packages: - oracle.security.xs contains the APIs for using lightweight user sessions - oracle.security.xs.admin contains the APIs for administering lightweight user session
Download As...

Network Management

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

Contains complete listing with descriptions of the control utility commands and configuration file parameters available for managing components of Oracle Net Services.
Download As...

PDF for offline viewing

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.

Describes how to administer Oracle Automatic Storage Management (Oracle ASM) for Oracle Database.
Download As...

PDF for offline viewing

Backup and Recovery

Enhance database availability using the full range of backup and recovery capabilities of the Oracle database, such as Recovery Manager and the flashback features.

Explains how to use Recovery Manager (RMAN) to back up, recover, and duplicate a database, and how to use Oracle Flashback Technology to restore all or a portion of your data to a previous state.
Download As...

PDF for offline viewing

Provides detailed descriptions of the Recovery Manager (RMAN) commands and recovery catalog views.
Download As...

PDF for offline viewing

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.

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

PDF for offline viewing

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

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