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

ePub for iBooks and mobile devices

Mobi for Kindle

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

ePub for iBooks and mobile devices

Mobi for Kindle

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

ePub for iBooks and mobile devices

Mobi for Kindle

Supporting Documentation

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

PDF for offline viewing

ePub for iBooks and mobile devices

Mobi for Kindle

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

ePub for iBooks and mobile devices

Mobi for Kindle

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

ePub for iBooks and mobile devices

Mobi for Kindle

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

PDF for offline viewing

ePub for iBooks and mobile devices

Mobi for Kindle

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

PDF for offline viewing

ePub for iBooks and mobile devices

Mobi for Kindle

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

ePub for iBooks and mobile devices

Mobi for Kindle

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

PDF for offline viewing

ePub for iBooks and mobile devices

Mobi for Kindle

SQL and PL/SQL

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

PDF for offline viewing

ePub for iBooks and mobile devices

Mobi for Kindle

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

PDF for offline viewing

ePub for iBooks and mobile devices

Mobi for Kindle

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

ePub for iBooks and mobile devices

Mobi for Kindle

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

ePub for iBooks and mobile devices

Mobi for Kindle

Provides usage information for developers (all experience levels) of databases and database applications.
Download As...

PDF for offline viewing

ePub for iBooks and mobile devices

Mobi for Kindle

Clients for Database Administration

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

ePub for iBooks and mobile devices

Mobi for Kindle

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

PDF for offline viewing

ePub for iBooks and mobile devices

Mobi for Kindle

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

ePub for iBooks and mobile devices

Mobi for Kindle

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

PDF for offline viewing

ePub for iBooks and mobile devices

Mobi for Kindle

Security

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

PDF for offline viewing

ePub for iBooks and mobile devices

Mobi for Kindle

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

PDF for offline viewing

ePub for iBooks and mobile devices

Mobi for Kindle

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

ePub for iBooks and mobile devices

Mobi for Kindle

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

ePub for iBooks and mobile devices

Mobi for Kindle

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

ePub for iBooks and mobile devices

Mobi for Kindle

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

ePub for iBooks and mobile devices

Mobi for Kindle

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

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

ePub for iBooks and mobile devices

Mobi for Kindle

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

PDF for offline viewing

ePub for iBooks and mobile devices

Mobi for Kindle

Storage

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

PDF for offline viewing

ePub for iBooks and mobile devices

Mobi for Kindle

Backup and Recovery

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

ePub for iBooks and mobile devices

Mobi for Kindle

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

ePub for iBooks and mobile devices

Mobi for Kindle

UNIX and Windows Database Administration

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

PDF for offline viewing

ePub for iBooks and mobile devices

Mobi for Kindle

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

ePub for iBooks and mobile devices

Mobi for Kindle

Testing

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

ePub for iBooks and mobile devices

Mobi for Kindle