Home
Home
Customize
Customize
Help
Help
Contact us
Contact Us

Oracle Database
  10g Release 2 (10.2)

Welcome Search Books Installation Administration Application Development OLTP Data Warehousing Grid Computing Unstructured Data Information Integration Windows Enterprise Manager Secure Backup Secure Enterprise Search Database Vault

Administration

Administration involves:

  • Creating and maintaining schema objects, such as tables and indexes
  • Backup and recovery
  • Granting permissions to users
  • Performance tuning
  • Monitoring the condition of the database
  • Administering network connections
  • Administering database security

Oracle Enterprise Manager

2 Day DBA HTML PDF
Enterprise Manager Command Line Interface HTML PDF
Enterprise Manager Concepts HTML PDF
Enterprise Manager SNMP Support Reference Guide HTML PDF
Enterprise Manager Framework, Host, and Services Metric Reference Manual HTML PDF
Enterprise Manager Licensing Information HTML PDF
Enterprise Manager Oracle Database and Database-Related Metric Reference Manual HTML PDF
Enterprise Manager Policy Reference Manual HTML PDF
Enterprise Manager Advanced Configuration HTML PDF
Enterprise Manager Extensibility for Windows or UNIX HTML PDF

Monitoring

To observe and customize database settings from SQL, you can query the data dictionary views and read or set initialization parameters for an individual session or the whole database.

High Availability

To keep your database available at all times, you can use these software components:

2 Day + Real Application Clusters Guide HTML PDF
Advanced Replication HTML PDF
Advanced Replication Management API Reference HTML PDF
Data Guard Broker HTML PDF
Data Guard Concepts and Administration HTML PDF
High Availability Best Practices HTML PDF
High Availability Overview HTML PDF
Oracle Clusterware and Oracle Real Application Clusters Administration and Deployment Guide HTML PDF
Database Oracle Clusterware and Oracle Real Application Clusters Installation Guide for AIX HTML PDF
Database Oracle Clusterware and Oracle Real Application Clusters Installation Guide for hp Tru64 HTML PDF
Database Oracle Clusterware and Oracle Real Application Clusters Installation Guide for HP-UX HTML PDF
Database Oracle Clusterware and Oracle Real Application Clusters Installation Guide for Linux HTML PDF
Database Oracle Clusterware and Oracle Real Application Clusters Installation Guide for Microsoft Windows HTML PDF
Database Oracle Clusterware and Oracle Real Application Clusters Installation Guide for Solaris Operating System HTML PDF
Streams Advanced Queuing User's Guide and Reference HTML PDF
Streams Concepts and Administration HTML PDF
Streams Replication Administrator's Guide HTML PDF

Data Guard

Data Guard provides a standby database for disaster recovery:

Data Guard Concepts and Administration HTML PDF
Data Guard Broker HTML PDF

Network Management

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

Net Services Administrator's Guide HTML PDF
Net Services Reference HTML PDF

Oracle HTTP Server

The database includes a built-in Web server. You can build Web-based front ends to stored procedures for data entry and reporting:

HTTP Server Administrator's Guide HTML PDF
HTTP Server mod_plsql User's Guide HTML PDF
 

Backup and Recovery

You can use Recovery Manager (RMAN) to back up and recover Oracle databases. The new Oracle Backup media management utility enables you to back up and restore any files on the file system. RMAN can also use the Oracle Backup SBT interface to back up database files to tape.

Backup and Recovery Quick Start Guide HTML PDF
Backup and Recovery Basics HTML PDF
Secure Backup Installation Guide HTML PDF
Secure Backup Licensing Information HTML PDF
Backup and Recovery Reference HTML PDF
Backup and Recovery Advanced User's Guide HTML PDF
Secure Backup Administrator's Guide HTML PDF
Secure Backup Migration Guide HTML PDF
Secure Backup Readme HTML PDF
Secure Backup Reference HTML PDF

SQL and PL/SQL

SQL is the underlying language for all database programming. PL/SQL is tightly integrated with SQL, usually for code running inside the database such as triggers, stored procedures and functions, and PL/SQL packages. SQL*Plus is the command-line tool for running SQL and compiling PL/SQL.

In addition to the individual books for each environment, there is an online quick reference that combines all three environments.

SQL Developer User's Guide HTML PDF
Database SQL Developer Installation Guide HTML PDF
PL/SQL User's Guide and Reference HTML PDF
PL/SQL Packages and Types Reference HTML PDF
SQL Reference HTML PDF
SQL Quick Reference HTML PDF
SQL*Plus User's Guide and Reference HTML PDF
SQL*Plus Quick Reference HTML PDF

Security

Security involves many aspects, such as network protocols, user privileges, and encryption:

Label Security Administrator's Guide HTML PDF
Enterprise User Security Administrator's Guide HTML PDF
Advanced Security Administrator's Guide HTML PDF
Enterprise Manager System Monitoring Plug-In Installation Guide for Microsoft Internet Security and Acceleration Server HTML PDF
Security Guide HTML PDF

Performance

Oracle Database 10g includes many automated performance features, which you access through Oracle Enterprise Manager. You can also learn about and use detailed performance features, such as indexes, hints, and performance-related views in the data dictionary:

2 Day + Performance Tuning Guide HTML PDF
Performance Tuning Guide HTML PDF

Guides

These books cover specific aspects of administering Oracle:

Administrator's Guide HTML PDF
Advanced Security Administrator's Guide HTML PDF
Configuration Manager Installation and Administration Guide HTML PDF
Data Mining Administrator's Guide HTML PDF
Enterprise User Security Administrator's Guide HTML PDF
Heterogeneous Connectivity Administrator's Guide HTML PDF
HTTP Server Administrator's Guide HTML PDF
Database Installation and Administration Guide for Fujitsu Siemens BS2000/OSD HTML PDF
Label Security Administrator's Guide HTML PDF
Net Services Administrator's Guide HTML PDF
Platform Guide for Microsoft Windows (32-Bit) HTML PDF
Platform Guide for Microsoft Windows Itanium (64-Bit) HTML PDF
Platform Guide for Microsoft Windows x64 (64-Bit) HTML PDF
Real Application Testing User's Guide HTML PDF
Secure Backup Administrator's Guide HTML PDF
Secure Enterprise Search Administrator's Guide HTML PDF
Streams Replication Administrator's Guide HTML PDF
System Administration Guide for IBM z/OS on System z HTML PDF
Transparent Gateway for Informix Administrator's Guide for HP-UX HTML PDF
Transparent Gateway for Informix Administrator's Guide for Solaris Operating System (SPARC 64-Bit) HTML PDF
Transparent Gateway for Ingres II Administrator's Guide for hp-ux HTML PDF
Transparent Gateway for Ingres II Administrator's Guide for Solaris Operating System (SPARC 64-Bit) HTML PDF
Transparent Gateway for Microsoft SQL Server Administrator's Guide for Microsoft Windows HTML PDF
Transparent Gateway for Sybase Administrator's Guide for hp Tru64 UNIX HTML PDF
Transparent Gateway for Sybase Administrator's Guide for HP-UX HTML PDF
Transparent Gateway for Sybase Administrator's Guide for IBM AIX HTML PDF
Transparent Gateway for Sybase Administrator's Guide for Microsoft Windows HTML PDF
Transparent Gateway for Sybase Administrator's Guide for Solaris Operating System (SPARC 64-Bit) HTML PDF
Transparent Gateway for Teradata Administrator's Guide for hp-ux HTML PDF
Transparent Gateway for Teradata Administrator's Guide for Microsoft Windows HTML PDF
Transparent Gateway for Teradata Administrator's Guide for Solaris Operating System (SPARC 64-Bit) HTML PDF
Ultra Search Administrator's Guide HTML PDF
Database Vault Administrator's Guide HTML PDF

lower border