Home
Home
Help
Help
Contact us
Contact Us

Oracle Database
  10g Release 1 (10.1)
WelcomeSearchBooksAdministrationApplication DevelopmentOLTPData WarehousingGrid ComputingUnstructured DataInformation IntegrationWindows

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

Enterprise Manager lets you administer and monitor the database through a browser-based user interface. You can work with one or many database instances, and manage the whole software stack through the Grid Control.

Enterprise Manager Concepts HTML PDF
Enterprise Manager Advanced Configuration 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:

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 Architecture and Best Practices HTML PDF
Real Application Clusters Administrator's Guide HTML PDF
Real Application Clusters Deployment and Performance Guide HTML PDF
Streams Advanced Queuing Java API Reference (Javadoc) HTML  
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 Guide 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 produce a standard, automated backup and recovery scheme, or to define your own backup and recovery process. The EXPORT and IMPORT utilities also help to move data.

Backup and Recovery Basics HTML PDF
Recovery Manager Quick Start Guide HTML PDF
Recovery Manager Reference HTML PDF
Backup and Recovery Advanced User's Guide HTML PDF
Utilities 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 Reference HTML PDF
SQL Quick Reference HTML PDF
PL/SQL User's Guide and Reference HTML PDF
PL/SQL Packages and Types 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:

Security Overview HTML PDF
Security Guide HTML PDF
Advanced Security Administrator's Guide HTML PDF
Label Security Administrator's 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:

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
Data Mining Administrator's Guide HTML PDF
Heterogeneous Connectivity Administrator's Guide HTML PDF
HTTP Server Administrator's Guide HTML PDF
Label Security Administrator's Guide HTML PDF
Net Services Administrator's Guide HTML PDF
Platform Guide for Windows HTML PDF
Real Application Clusters Administrator's Guide HTML PDF
Streams Replication Administrator's Guide HTML PDF
Workflow Administrator's Guide HTML PDF

lower border