Expert Oracle9i Database Administration / Edition 1

Expert Oracle9i Database Administration / Edition 1

by Sam Alapati
ISBN-10:
1590590228
ISBN-13:
2901590590224
Pub. Date:
04/13/2003
Publisher:
Apress

Paperback

View All Available Formats & Editions
Current price is , Original price is $59.99. You
Select a Purchase Option (2003)
  • purchase options
    $42.20 $59.99 Save 30% Current price is $42.2, Original price is $59.99. You Save 30%.
    icon-error
    Note: Access code and/or supplemental material are not guaranteed to be included with textbook rental or used textbook.

Overview

Expert Oracle9i Database Administration / Edition 1

This is the only real Oracle 9i 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 Oracle 9i databases. Expert Oracle 9i 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. Sam R. Alapati covers the entire spectrum of the new Oracle 9i 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 in one book. Sam R. Alapati's book fills that gap well, by providing all the necessary material in one comprehensive volume.

Expert Oracle 9i Database Administration is designed as the most complete Oracle 9i database text available today. It takes several courses as well as mastery of several Oracle manuals to become a proficient DBA. A major focus of this book is on the most important features of the Oracle 9i database. Readers will be able to become expert Oracle DBA's by using this book.

Sam R. Alapati is an experienced Oracle Database Administration, who holds the Oracle OCP DBA certification and the Hewlett Packard UNIX System Administrator certification. He currently manages Oracle databases at the Boy Scouts of America's National Headquarters in Los Colinas, Texas. Alapati has been dealing with databases for a long time, including the Ingres RDBMS in the mid 1980s. He is also well versed in the Microsoft SQL Server, Sybase, and the IBM DB2 database management systems.

- Written by an experienced, practicing Certified Oracle DBA

- The book is actually based on the Oracle 9i version and is not just a revamp of an older book to superficially address the new features of the Oracle 9i database

- Covers the principles in-depth and also contains a how to section at the end of chapters to help explain how to perform DBA tasks using actual real life commands

Product Details

ISBN-13: 2901590590224
Publisher: Apress
Publication date: 04/13/2003
Edition description: 2003
Pages: 1248
Product dimensions: 6.00(w) x 1.25(h) x 9.00(d)

About the Author

Sam R. Alapati is an experienced Oracle database administrator who holds the Oracle Certified Professional designation and the Hewlett-Packard UNIX System Administrator certification. He currently manages Oracle databases at the Boy Scouts of America's national headquarters in Los Colinas, Texas. Alapati has been dealing with databases for a long time, including the Ingres RDBMS in the mid-1980s. He is also well-versed in the Microsoft SQL Server, Sybase, and IBM DB2 database management systems.

Table of Contents

Part I The Background, Data Modeling and UNIX/Linux


Chapter 1. The Oracle Data Base Administrator's World
Chapter 2. Data Modeling and Designing Databases
Chapter 3. Essential UNIX/Linux Commands and UNIX/Linux System
Administration for the Oracle DBA

Part II The Oracle RDBMS, SQL and PL/SQL
Chapter 4. Installing the Oracle RDBMS software
Chapter 5. Introduction to the Oracle Architecture
Chapter 6. Essential SQL and PL/SQL for the Oracle DBA

Part III Creating Databases, Connectivity and User Management
Chapter 7. Creating Databases
Chapter 8. Connectivity and Networking
Chapter 9. User management and Oracle Security

Part IV Data Loading, Backing Up and Recovery of Databases
Chapter 10. Oracle Data Loading Techniques - the SQL Loader
Utility
Chapter 11. Oracle Export and Import Utilities
Chapter 12. Backing up Databases
Chapter 13. Recovering Databases

Part V Managing the operational Oracle Database
Chapter 14. Managing the Running Oracle Database
Chapter 15. Using the Oracle Enterprise Manager
Chapter 16. Using UNIX based Monitoring and Paging Scripts
Chapter 17. Managing the Oracle database on a Windows system

Part VI Performance Tuning and Troubleshooting the Production Database
Chapter 18. Performance Tuning and writing efficient SQL Queries
Chapter 19. Performance Tuning and Optimizing Oracle Memory and the Operating System
Chapter 20. The Oracle data Dictionary and Dynamic Performance Tables
Chapter 21. Using Oracle Supplied Packages
Chapter 22. DBA Troubleshooting tips

Customer Reviews

Most Helpful Customer Reviews

See All Customer Reviews

Expert Oracle9i Database Administration 5 out of 5 based on 0 ratings. 3 reviews.
Guest More than 1 year ago
While this book does not delve in depth into many of the more advanced features of the 9i release of the Oracle Database, 'Expert Oracle9i Database Administration' does a wonderful job of bringing the features to the level where the reader is. This is probably the books best feature. Not only does it introduce new DBAs to the concepts of Relational Databases, but also Linux, Unix and Windows as they apply to the database. Not only does the Alapati lead you through the architecture of the 9i database, but provides practical advice and tips that the reader will find himself relying on as he works every day with the database. The How-Tos are some of the most useful and practical that I have seen. I highly recommend this book to anyone interested in learning Oracle or anyone who is already working with it
Guest More than 1 year ago
You will find a lot of books that talks about oracle 9i DBA but you can't find a book that talks about oracle , linux,unix,Windows NT,SQL, SQL*plus and PL/SQL , 'Expert Oracle9i Database Administration' did it . You will find in this box a good introduction to the world of Oracle .first it takes you to the fundementals of RDBMS then you will find your self is involved with the world of DBA . The author didn't forget to give you the basic skills to use UNIX (or linux) machine - that every DBA will need to know - and after that he explain the Architecture of Oracle databases and how it works . After this introductional Chapters , the book dive in the using of SQL*PLUS to manipulate with oracle databases, The book put all you need to know to Create an Oracle Database in one chapter and anothe chapter to explain how to work with oracke and networking and other chapters to User Management, Loading and Transforming Data, how to Use the Export and Import Utilities in Oracle ,how to Back Up Databases and how to Use Oracle9i Enterprise Manager and more . finally ..... in my opinion if you are a beginner or intermediate level Oracle DBA you will need this book a lot to give you a lot of secrets to success in the DBA's world . Thank you Apress to publish this books and of course many thanks to Sam R. Alapati
Guest More than 1 year ago
This book does a great job of presenting the Oracle9i Release 2 DBA information. The author spares no effort to explain in detail, with the help of numerous examples, how the many new features of Oracle 9i work. You can't go wrong with this book if you are looking for a one volume Oracle 9i DBA handbook/text. Be far, the best book on Oracle 9i DBA in the market. Most other books are rewrites of older Oracle versions. this book promises and delivers real Oracle 9i content.