Expert Oracle9i Database Administration

This is the only real Oracle9i database administration book in the market! This 1,000+ page book enables a beginner or intermediate level Oracle DBA or Oracle Developer/Manager to master the art of building and managing complex Oracle9i databases. Expert Oracle9i Database Administration is thorough in covering all aspects of the 9i database and also includes a UNIX primer as well as an introduction to SQL and PL/SQL. Alapati covers the entire spectrum of the new Oracle9i RDBMS software and clearly explains how to use all of its powerful features.

Currently there is no one book that includes the necessary UNIX administration, Windows NT management, and SQL backgrounds and the necessary database administration principles. This book fills that gap well, by providing all the necessary material in one comprehensive volume.

It takes several courses as well as mastery of several Oracle manuals to become a proficient DBA. Readers will be able to become expert Oracle DBAs by using this book. Expert Oracle9i Database Administration is designed to be the most complete Oracle9i database text available today.

Contents

Part One Database Basics, Data Modeling, and UNIX/Linux
  Chapter 1: The Oracle DBA’s World
  Chapter 2: Relational Database Modeling and Database Design
  Chapter 3: Essential UNIX (and Linux) for the Oracle DBA
Part Two The Oracle RDBMS
  Chapter 4: Installing the Oracle9i RDBMS
  Chapter 5: Introduction to the Oracle9i Architecture
  Chapter 6: Using SQL*Plus and iSQL*Plus
  Chapter 7: Schema Management in Oracle9i
  Chapter 8: Oracle Transaction Management
Part Three Database Creation, Connectivity, and User Management
  Chapter 9: Creating an Oracle Database
  Chapter 10: Connectivity and Networking
  Chapter 11: User Management and Database Security
Part Four Data Loading, Backup, and Recovery
  Chapter 12: Loading and Transforming Data
  Chapter 13: Using the Export and Import Utilities
  Chapter 14: Backing Up Databases
  Chapter 15: Database Recovery
Part Five Managing the Operational Oracle Database
  Chapter 16: Managing the Operational Database
  Chapter 17: Using Oracle9i Enterprise Manager
Part Six Performance Tuning and Troubleshooting the Production Database
  Chapter 18: Improving Database Performance: SQL Query Optimization
  Chapter 19: Performance Tuning: Tuning the Instance
  Chapter 20: The Oracle Data Dictionary and the Dynamic Performance Views
  Chapter 21: Using Oracle PL/SQL Packages
  Chapter 22: Managing Oracle Databases on
   Windows and Linux Systems
  Appendix A: Brief Oracle9i SQL and PL/SQL Primer