Contact us
Contact Us

Table of Contents for Oracle9i Database Administrator's Guide

This is a computer-generated version of the table of contents for this book. Any headings that contain your search term "VIEWS" are highlighted.

Title Page


Send Us Your Comments



    Oracle9i Release 2 (9.2) New Features

    Oracle9i Release 1 (9.0.1) New Features

Basic Database Administration

The Oracle Database Administrator

    Types of Oracle Users

    Tasks of a Database Administrator

    Identifying Your Oracle Database Software Release

    Database Administrator Security and Privileges

    Database Administrator Authentication

    Creating and Maintaining a Password File

    Database Administrator Utilities

Creating an Oracle Database

    Considerations Before Creating a Database

    Using the Database Configuration Assistant

    Manually Creating an Oracle Database

    Understanding the CREATE DATABASE Statement

    Troubleshooting Database Creation

    Dropping a Database

    Considerations After Creating a Database

    Initialization Parameters and Database Creation

    Managing Initialization Parameters Using a Server Parameter File

Using Oracle-Managed Files

    What are Oracle-Managed Files?

    Enabling the Creation and Use of Oracle-Managed Files

    Creating Oracle-Managed Files

    Behavior of Oracle-Managed Files

    Scenarios for Using Oracle-Managed Files

Starting Up and Shutting Down

    Starting Up a Database

    Altering Database Availability

    Shutting Down a Database

    Quiescing a Database

    Suspending and Resuming a Database

Oracle Server Processes and Storage Structure

Managing Oracle Processes

    Server Processes

    Configuring Oracle for the Shared Server

    About Oracle Background Processes

    Monitoring the Processes of an Oracle Instance

    Managing Processes for Parallel Execution

    Managing Processes for External Procedures

    Terminating Sessions

Managing Control Files

    What Is a Control File?

    Guidelines for Control Files

    Creating Control Files

    Troubleshooting After Creating Control Files

    Backing Up Control Files

    Recovering a Control File Using a Current Copy

    Dropping Control Files

    Displaying Control File Information

Managing the Online Redo Log

    What Is the Online Redo Log?

    Planning the Online Redo Log

    Creating Online Redo Log Groups and Members

    Relocating and Renaming Online Redo Log Members

    Dropping Online Redo Log Groups and Members

    Forcing Log Switches

    Verifying Blocks in Redo Log Files

    Clearing an Online Redo Log File

    Viewing Online Redo Log Information

Managing Archived Redo Logs

    What Is the Archived Redo Log?

    Choosing Between NOARCHIVELOG and ARCHIVELOG Mode

    Controlling Archiving

    Specifying the Archive Destination

    Specifying the Mode of Log Transmission

    Managing Archive Destination Failure

    Tuning Archive Performance by Specifying Multiple ARCn Processes

    Controlling Trace Output Generated by the Archivelog Process

    Viewing Information About the Archived Redo Log

Using LogMiner to Analyze Redo Logs

    Potential Uses for Data Stored in Redo Logs

    Accessing Information Stored in Redo Logs

    Redo Logs and Dictionary Files

    LogMiner Recommendations and Restrictions

    Filtering Data That is Returned

    Accessing LogMiner Information


    Extracting Actual Data Values from Redo Logs

    Supplemental Logging

    Steps in a Typical LogMiner Session

    Example Uses of LogMiner

Managing Job Queues

    Enabling Processes Used for Executing Jobs

    Managing Job Queues

    Viewing Job Queue Information

Managing Tablespaces

    Guidelines for Managing Tablespaces

    Creating Tablespaces

    Coalescing Free Space in Dictionary-Managed Tablespaces

    Specifying Nonstandard Block Sizes for Tablespaces

    Controlling the Writing of Redo Records

    Altering Tablespace Availability

    Using Read-Only Tablespaces

    Dropping Tablespaces

    Diagnosing and Repairing Locally Managed Tablespace Problems

    Migrating the SYSTEM Tablespace to a Locally Managed Tablespace

    Transporting Tablespaces Between Databases

    Viewing Tablespace Information

Managing Datafiles

    Guidelines for Managing Datafiles

    Creating Datafiles and Adding Datafiles to a Tablespace

    Changing a Datafile's Size

    Altering Datafile Availability

    Renaming and Relocating Datafiles

    Dropping Datafiles

    Verifying Data Blocks in Datafiles

    Mapping Files to Physical Devices

    Viewing Datafile Information

Managing Undo Space

    What is Undo?

    Specifying the Mode for Undo Space Management

    Managing Undo Tablespaces

    Managing Rollback Segments

Schema Objects

Managing Space for Schema Objects

    Managing Space in Data Blocks

    Setting Storage Parameters

    Managing Resumable Space Allocation

    Deallocating Space

    Understanding Space Use of Datatypes

Managing Tables

    Guidelines for Managing Tables

    Creating Tables

    Altering Tables

    Redefining Tables Online

    Dropping Tables

    Managing Index-Organized Tables

    Managing External Tables

    Viewing Information About Tables

Managing Indexes

    Guidelines for Managing Indexes

    Creating Indexes

    Altering Indexes

    Monitoring Space Use of Indexes

    Dropping Indexes

    Viewing Index Information

Managing Partitioned Tables and Indexes

    What Are Partitioned Tables and Indexes?

    Partitioning Methods

    Creating Partitioned Tables

    Maintaining Partitioned Tables

    Partitioned Tables and Indexes Examples

    Viewing Information About Partitioned Tables and Indexes

Managing Clusters

    Guidelines for Managing Clusters

    Creating Clusters

    Altering Clusters

    Dropping Clusters

    Viewing Information About Clusters

Managing Hash Clusters

    When to Use Hash Clusters

    Creating Hash Clusters

    Altering Hash Clusters

    Dropping Hash Clusters

    Viewing Information About Hash Clusters

Managing Views, Sequences, and Synonyms

    Managing Views

    Managing Sequences

    Managing Synonyms

    Viewing Information About Views, Synonyms, and Sequences

General Management of Schema Objects

    Creating Multiple Tables and Views in a Single Operation

    Renaming Schema Objects

    Analyzing Tables, Indexes, and Clusters

    Truncating Tables and Clusters

    Enabling and Disabling Triggers

    Managing Integrity Constraints

    Managing Object Dependencies

    Managing Object Name Resolution

    Changing Storage Parameters for the Data Dictionary

    Displaying Information About Schema Objects

Detecting and Repairing Data Block Corruption

    Options for Repairing Data Block Corruption

    About the DBMS_REPAIR Package

    Using the DBMS_REPAIR Package

    DBMS_REPAIR Examples

Database Security

Establishing Security Policies

    System Security Policy

    Data Security Policy

    User Security Policy

    Password Management Policy

    Auditing Policy

    A Security Checklist

Managing Users and Resources

    Managing Oracle Users

    User Authentication Methods

    Managing Resources with Profiles

    Viewing Information About Database Users and Profiles

Managing User Privileges and Roles

    Understanding User Privileges and Roles

    Managing User Roles

    Granting User Privileges and Roles

    Revoking User Privileges and Roles

    Granting to and Revoking from the User Group PUBLIC

    When Do Grants and Revokes Take Effect?

    Granting Roles Using the Operating System or Network

    Viewing Privilege and Role Information

Auditing Database Use

    Guidelines for Auditing

    What Information is Contained in the Audit Trail?

    Actions Audited by Default

    Auditing Administrative Users

    Managing the Audit Trail

    Fine-Grained Auditing

    Viewing Database Audit Trail Information

Database Resource Management

Using the Database Resource Manager

    What Is the Database Resource Manager?

    Administering the Database Resource Manager

    Creating a Simple Resource Plan

    Creating Complex Resource Plans

    Managing Resource Consumer Groups

    Enabling the Database Resource Manager

    Putting It All Together: Database Resource Manager Examples

    Monitoring and Tuning the Database Resource Manager

    Viewing Database Resource Manager Information

Distributed Database Management

Distributed Database Concepts

    Distributed Database Architecture

    Database Links

    Distributed Database Administration

    Transaction Processing in a Distributed System

    Distributed Database Application Development

    Character Set Support for Distributed Environments

Managing a Distributed Database

    Managing Global Names in a Distributed System

    Creating Database Links

    Creating Shared Database Links

    Managing Database Links

    Viewing Information About Database Links

    Creating Location Transparency

    Managing Statement Transparency

    Managing a Distributed Database: Scenarios

Developing Applications for a Distributed Database System

    Managing the Distribution of an Application's Data

    Controlling Connections Established by Database Links

    Maintaining Referential Integrity in a Distributed System

    Tuning Distributed Queries

    Handling Errors in Remote Procedures

Distributed Transactions Concepts

    What Are Distributed Transactions?

    Session Trees for Distributed Transactions

    Two-Phase Commit Mechanism

    In-Doubt Transactions

    Distributed Transaction Processing: Case Study

Managing Distributed Transactions

    Specifying the Commit Point Strength of a Node

    Naming Transactions

    Viewing Information About Distributed Transactions

    Deciding How to Handle In-Doubt Transactions

    Manually Overriding In-Doubt Transactions

    Purging Pending Rows from the Data Dictionary

    Manually Committing an In-Doubt Transaction: Example

    Data Access Failures Due To Locks

    Simulating Distributed Transaction Failure

    Managing Read Consistency