Home

Help

Contact Us

  10g Release 1 (10.1)

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

Copyright © 2004, Oracle. All rights reserved.