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

Preface

i?

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

Querying V$LOGMNR_CONTENTS

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

Index