Oracle7 Server Administrator's Guide

Library

Product

---

• Oracle7^(tm) Server Administrator's Guide

• Preface
  • Audience
  • How to Use This Guide
  • Conventions Used in This Guide

• Basic Database Administration

• The Oracle7 Database Administrator
  • Types of Oracle7 Users
  • Database Administrator Security and Privileges
  • Database Administrator Authentication
  • Password File Administration
  • Database Administrator Utilities
  • Initial Priorities of a Database Administrator
  • Identifying Oracle Software Releases

• Creating a Database
  • Considerations Before Creating a Database
  • Creating an Oracle7 Database
  • Parameters
  • Considerations After Creating a Database
  • Initial Tuning Guidelines

• Starting Up and Shutting Down
  • Startup Procedures
  • Altering Database Availability
  • Shutdown Procedures
  • Using Parameter Files

• Oracle Server Configuration

• Managing Oracle7 Processes
  • Configuring Oracle7 for Dedicated Server Processes
  • Configuring Oracle7 for Multi-Threaded Server Processes
  • Modifying Server Processes
  • Tracking Oracle7 Processes
  • Managing Processes for the Parallel Query Option
  • Terminating Sessions

• Managing the Online Redo Log
  • Planning the Online Redo Log
  • Creating Online Redo Log Groups and Members
  • Renaming and Relocating Online Redo Log Members
  • Dropping Online Redo Log Groups
  • Dropping Online Redo Log Members
  • Controlling Checkpoints and Log Switches
  • Verifying Blocks in Redo Log Files
  • Clearing an Online Redo Log File
  • Listing Information about the Online Redo Log

• Managing Control Files
  • Guidelines for Control Files
  • Creating Control Files
  • Troubleshooting After Creating Control Files
  • Dropping Control Files

• Managing Job Queues
  • SNP Background Processes
  • Managing Job Queues
  • Viewing Job Queue Information

• Database Storage

• Managing Tablespaces
  • Guidelines for Managing Tablespaces
  • Creating Tablespaces
  • Managing Tablespace Allocation
  • Altering Tablespace Availability
  • Making a Tablespace Read-Only
  • Dropping Tablespaces
  • Viewing Information About Tablespaces

• Managing Datafiles
  • Guidelines for Managing Datafiles
  • Creating and Adding Datafiles to a Tablespace
  • Changing a Datafile's Size
  • Altering Datafile Availability
  • Renaming and Relocating Datafiles
  • Verifying Data Blocks in Datafiles
  • Viewing Information About Datafiles

• Guidelines for Managing Schema Objects
  • Managing Space in Data Blocks
  • Setting Storage Parameters
  • Deallocating Space
  • Understanding Space Use of Datatypes

• Managing Tables
  • Guidelines for Managing Tables
  • Creating Tables
  • Altering Tables
  • Manually Allocating Storage for a Table
  • Dropping Tables

• Managing Views, Sequences and Synonyms
  • Managing Views
  • Managing Sequences
  • Managing Synonyms

• Managing Indexes
  • Guidelines for Managing Indexes
  • Creating Indexes
  • Altering Indexes
  • Monitoring Space Use of Indexes
  • Dropping Indexes

• Managing Clusters
  • Guidelines for Managing Clusters
  • Creating Clusters
  • Altering Clusters
  • Dropping Clusters

• Managing Hash Clusters
  • Guidelines for Managing Hash Clusters
  • Creating Hash Clusters
  • Altering Hash Clusters
  • Dropping Hash Clusters

• 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

• Managing Rollback Segments
  • Guidelines for Managing Rollback Segments
  • Creating Rollback Segments
  • Specifying Storage Parameters for Rollback Segments
  • Taking Rollback Segments Online and Offline
  • Explicitly Assigning a Transaction to a Rollback Segment
  • Dropping Rollback Segments
  • Monitoring Rollback Segment Information

• Database Security

• Establishing Security Policies
  • System Security Policy
  • Data Security Policy
  • User Security Policy
  • Auditing Policy

• Managing Users and Resources
  • Session and User Licensing
  • User Authentication
  • Oracle Users
  • Managing Resources with Profiles
  • Listing Information About Database Users and Profiles

• Managing User Privileges and Roles
  • Identifying User Privileges
  • Managing User Roles
  • Granting User Privileges and Roles
  • Revoking User Privileges and Roles
  • Granting Roles Using the Operating System or Network
  • Listing Privilege and Role Information

• Auditing Database Use
  • Guidelines for Auditing
  • Creating and Deleting the Database Audit Trail Views
  • Managing Audit Trail Information
  • Viewing Database Audit Trail Information
  • Auditing Through Database Triggers

• Database Backup and Recovery

• Archiving Redo Information
  • Choosing Between NOARCHIVELOG and ARCHIVELOG Mode
  • Turning Archiving On and Off
  • Tuning Archiving
  • Displaying Archiving Status Information
  • Specifying the Archived Redo Log Filename Format and Destination

• Backing Up a Database
  • Guidelines for Database Backups
  • Creating a Backup Strategy
  • Read-Only Tablespaces and Backup
  • Performing Backups
  • Recovering From an Incomplete Online Tablespace Backup
  • Using the Export and Import Utilities for Supplemental Database Protection

• Recovering a Database
  • Fundamental Recovery Concepts and Strategies
  • Preparing for Media Recovery
  • Performing Complete Media Recovery
  • Performing Incomplete Media Recovery
  • Preparing for Disaster Recovery
  • Unrecoverable Objects and Recovery
  • Read-Only Tablespaces and Recovery
  • Examples of Recovery Procedures

• Reference

• Space Estimations for Schema Objects
  • Estimating Space Required by Non-Clustered Tables
  • Estimating Space for Indexes
  • Estimating Space Required by Clusters
  • Estimating Space Required by Hash Clusters

---

Copyright © 1996 Oracle Corporation 500 Oracle Parkway, Redwood City, CA 94065

Library

Product