EssentialsDatabase 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.
| 2 Day + Security Guide | HTML | |
| 2 Day DBA | HTML | |
| 2 Day + Performance Tuning Guide | HTML |
Supporting Documentation
The documents below provide more extensive reference and advanced task material related to database administration.
| Administrator's Guide | HTML | |
| Concepts | HTML | |
| Error Messages | HTML | |
| Performance Tuning Guide | HTML | |
| Reference | HTML |
SQL, PL/SQL, and PL/SQL Packages
SQL statements and PL/SQL programs and packages are used extensively in administering Oracle databases.
| SQL Language Reference | HTML | |
| SQL Language Quick Reference | HTML | |
| PL/SQL Language Reference | HTML | |
| PL/SQL Packages and Types Reference | HTML |
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.
| Communications Data Model Implementation and Operations Guide | HTML | |
| SQL Developer User's Guide | HTML | |
| SQL*Plus Quick Reference | HTML | |
| SQL*Plus Release Notes | HTML | |
| SQL*Plus User's Guide and Reference | HTML |
Security
Detailed information on database features used to secure your data against unauthorized access.
| Advanced Security Administrator's Guide | HTML | |
| Database Vault Administrator's Guide | HTML | |
| Enterprise User Security Administrator's Guide | HTML | |
| Label Security Administrator's Guide | HTML | |
| Security Guide | HTML |
Network Management
Oracle Net helps you manage connectivity, security, and performance across both Internet and intranet networks.
| Net Services Administrator's Guide | HTML | |
| Net Services Reference | HTML |
Storage
Using Automatic Storage Management for Oracle databases.
| Automatic Storage Management Administrator's Guide | HTML |
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 | HTML | |
| Backup and Recovery Reference | HTML | |
| Advanced Replication Management API Reference | HTML |
UNIX and Windows Database Administration
Administration concepts and tasks specific to the Oracle Database on a specific operating system.
| Platform Guide for Microsoft Windows | HTML | |
| Administrator's Reference for Linux and UNIX-Based Operating Systems | HTML |
Testing
Oracle Real Application Testing enables you to perform real-world testing of Oracle Database.| Real Application Testing User's Guide | HTML |
