Expert Oracle9i Database Administration / Edition 1
by Sam Alapati, Martin Reid
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
… See more details belowOverview
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 includes a UNIX primer as well as an introduction to SQL and PL/SQL. Author Sam 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 database administrator. Readers will be able to become expert Oracle Database administrators by using this book. Expert Oracle9i Database Administration is designed to be the most complete Oracle9i database text available.
Product Details
- ISBN-13:
- 9781590590225
- Publisher:
- Apress
- Publication date:
- 04/15/2003
- Edition description:
- 2003
- Pages:
- 1248
- Product dimensions:
- 7.50(w) x 9.25(h) x 2.13(d)
Table of Contents
| About the Author | ||
| About the Technical Reviewer | ||
| Acknowledgments | ||
| Introduction | ||
| Pt. 1 | Database Basics, Data Modeling, and UNIX/Linux | 1 |
| Ch. 1 | The Oracle DBA's World | 3 |
| Ch. 2 | Relational Database Modeling and Database Design | 25 |
| Ch. 3 | Essential UNIX (and Linux) for the Oracle DBA | 55 |
| Pt. 2 | The Oracle RDBMS | 105 |
| Ch. 4 | Installing the Oracle9i RDBMS | 107 |
| Ch. 5 | Introduction to the Oracle9i Architecture | 139 |
| Ch. 6 | Using SQL[superscript *]Plus and iSQL[superscript *]Plus | 197 |
| Ch. 7 | Schema Management in Oracle9i | 237 |
| Ch. 8 | Oracle Transaction Management | 309 |
| Pt. 3 | Database Creation, Connectivity, and User Management | 261 |
| Ch. 9 | Creating an Oracle Database | 363 |
| Ch. 10 | Connectivity and Networking | 425 |
| Ch. 11 | User Management and Database Security | 469 |
| Pt. 4 | Data Loading, Backup, and Recovery | 531 |
| Ch. 12 | Loading and Transforming Data | 533 |
| Ch. 13 | Using the Export and Import Utilities | 579 |
| Ch. 14 | Backing Up Databases | 611 |
| Ch. 15 | Database Recovery | 673 |
| Pt. 5 | Managing the Operational Oracle Database | 721 |
| Ch. 16 | Managing the Operational Database | 723 |
| Ch. 17 | Using Oracle9i Enterprise Manager | 771 |
| Pt. 6 | Performance Tuning and Troubleshooting the Production Database | 819 |
| Ch. 18 | Improving Database Performance: SQL Query Optimization | 821 |
| Ch. 19 | Performance Tuning: Tuning the Instance | 887 |
| Ch. 20 | The Oracle Date Dictionary and the Dynamic Performance Views | 973 |
| Ch. 21 | Using Oracle PL/SQL Packages | 1029 |
| Ch. 22 | Managing Oracle Databases on Windows and Linux Systems | 1077 |
| App | A Brief Oracle9i SQL and PL/SQL Primer | 1105 |
| Index | 1145 |
Customer Reviews
Average Review: