Books & Videos

Table of Contents

  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 Appendix:Resources for the DBA

    1. Books

    2. Other Publications

    3. Organizations

    4. Web Sites

    5. Discussion Groups

    6. List Servers

  2. Colophon