1. DBA Tasks

   1. Chapter 1 Introduction

      1. Oracle Database Administration
      2. Oracle Architecture
      3. Software Options
      4. Configuration Planning

   2. Chapter 2 Installation

      1. Media Selection
      2. The Oracle Installer
      3. Installable Components
      4. Dependencies
      5. Pre-Installation Checklist
      6. Critical Decisions
      7. Post-Installation Tasks

   3. Chapter 3 Maximizing Oracle Performance

      1. Configuration and Tuning—What's the Difference?
      2. Achieving Maximum Performance
      3. Configuring the Operating System
      4. Configuring Oracle
      5. Sizing and Configuring Database Objects
      6. Tuning Oracle

   4. Chapter 4 Preventing Data Loss

      1. Types of Backups
      2. Database Backup
      3. Database Recovery
      4. Automated Utilities
      5. Practice Scenarios

   5. Chapter 5 Oracle Networking

      1. Oracle Network Architecture
      2. Oracle Names
      3. MultiProtocol Interchange
      4. Connecting to Non-Oracle Databases
      5. Oracle Network Manager
      6. Oracle Net8 Assistant
      7. Manual Network Configuration
      8. Sample SQL*Net Files
      9. SQL*Net Troubleshooting

   6. Chapter 6 Security and Monitoring

      1. Security
      2. Monitoring

   7. Chapter 7 Auditing

      1. About Auditing
      2. Forms of the AUDIT Statement
      3. Audit Trail Views and Lookup Tables
      4. Establishing an Audit Policy
      5. Maintaining the Audit Trail
      6. Row-Level Auditing

   8. Chapter 8 Query Optimization

      1. Types of Queries
      2. Types of Join Access Paths
      3. Determining the Access Plan
      4. Cost-Based Optimizer
      5. Rule-Based Optimizer

   9. Chapter 9 Oracle Tools

      1. About the Tools
      2. SQL*Plus
      3. Oracle Server Manager
      4. SQLDBA
      5. Oracle Network Manager
      6. SQL*Loader
      7. Oracle Enterprise Manager
      8. Third-Party Tools

2. DBA Reference

   1. Chapter 10 The Oracle Instance

      1. Elements of the Instance
      2. About Processes
      3. About Memory Structures

   2. Chapter 11 The Oracle Database

      1. Types of Database Files
      2. Oracle Tablespaces
      3. Disk Allocation

   3. Chapter 12 Initialization Parameters

      1. Dynamically Modifiable Parameters
      2. Platform-Specific Parameters
      3. Summary of Initialization Parameters
      4. Parameters Used Only in Oracle7
      5. Parameters New in Oracle8

   4. Chapter 13 SQL Statements for the DBA

      1. SQL Commands by Task
      2. SQL Command Syntax

   5. Chapter 14 The Oracle Data Dictionary

      1. Static Data Dictionary Views
      2. Dynamic Performance Data Dictionary Views

   6. Chapter 15 System Privileges and Initial Roles

      1. Actions, Privileges, and Roles
      2. System Privileges
      3. Initial Roles
      4. Initial Users

   7. Chapter 16 Tools and Utilities

      1. SQL*Plus
      2. Export
      3. Import
      4. SQL*Loader

1. Appendix A Appendix:Resources for the DBA

   1. Books

   2. Other Publications

   3. Organizations

   4. Web Sites

   5. Discussion Groups

   6. List Servers

2. Colophon

Our look is the result of reader comments, our own experimentation, and feedback from distribution channels. Distinctive covers complement our distinctive approach to technical topics, breathing personality and life into potentially dry subjects. The animals on the cover of Oracle Database Administration: The Essential Reference are ladybug beetles (family Coccinellidae), also known as lady beetles or ladybird beetles. Due to an attractive appearance and a diet of plant-eating aphids (some females consume up to 75 a day), these small, red or orange black-spotted beetles rank high in global opinion polls, and are even associated in some cultures with Christian symbols. In German, ladybugs are called "Marienkafer," or Mary's beetle; in French, one name for them is "les vaches de la vierge" or Cows of the Virgin. Ladybugs are effective in reducing garden pests and can be ordered from garden catalogs by the pound; they also frequently spend the winter inside people's homes, which in Canada and the U.S. is said to bring good luck. Elsewhere, the beetles are thought to signify good weather, good harvest, or other good fortune. There are thousands of ladybug species worldwide, and a few are plant eaters and pests themselves. Their colorful wing covers are more than just a pretty picture: predators generally avoid red or orange-and-black insects, as they tend to taste terrible. Other defensive maneuvers include playing dead, the production of a foul odor, and fierce-looking larvae. Madeleine Newell was the production editor and copyeditor for Oracle Database Administration: The Essential Reference. Sheryl Avruch was the production manager; Ellie Fountain Maden, Nancy Kotary, and Nicole Arigo provided quality control. Robert Romano created the illustrations using Adobe Photoshop 4 and Macromedia FreeHand 7. Mike Sierra provided FrameMaker technical support. Seth Maislin wrote the index. Maureen Dempsey, Bette Hugh, and Michael Blanding provided production assistance. Edie Freedman designed the cover of this book, using a 19th-century engraving from the Dover Pictorial Archive. The cover layout was produced by Kathleen Wilson with QuarkXPress 3.32 using the ITC Garamond font. Whenever possible, our books use RepKover, a durable and flexible lay-flat binding. If the page count exceeds RepKover's limit, perfect binding is used. The inside layout was designed by Nancy Priest and implemented in FrameMaker 5.5.6 by Mike Sierra. The text and heading fonts are ITC Garamond Light and Garamond Book. The description of ladybug beetles was written by Nancy Kotary.