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.
2 Day DBA | HTML | |
2 Day + Security Guide | HTML | |
2 Day + Performance Tuning Guide | HTML |
Supporting Documentation
Supporting documentation treats advanced topics related to database administration. In general, the 2 Day + books refer you to these topics when needed.
Concepts | HTML | |
Administrator's Guide | HTML | |
Reference | HTML | |
SQL Language Reference | HTML | |
Performance Tuning Guide | HTML | |
Error Messages | HTML |
SQL and PL/SQL
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 | |
SQL Developer User's Guide | HTML |
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.
SQL Developer User's Guide | HTML | |
SQL*Plus Release Notes | HTML | |
SQL*Plus User's Guide and Reference | HTML | |
SQL*Plus Quick Reference | HTML |
Security
Detailed information on database features used to secure your data against unauthorized access.
Security Guide | HTML | |
Advanced Security Administrator's Guide | HTML | |
Enterprise User Security Administrator's Guide | HTML | |
Label Security Administrator's Guide | HTML | |
Database Vault Administrator's Guide | HTML |
Network Management
Oracle Net helps you manage connectivity, security, and performance across both Internet and intranet networks.
Net Services Reference | HTML | |
Net Services Administrator's Guide | 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.
Administrator's Reference for Linux and UNIX-Based Operating Systems | HTML | |
Platform Guide for Microsoft Windows | HTML |
Testing
Oracle Real Application Testing enables you to perform real-world testing of Oracle Database.Real Application Testing User's Guide | HTML |