- Shopping Bag ( 0 items )
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.
|About the Author|
|About the Technical Reviewer|
|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|
Posted February 11, 2004
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 itWas this review helpful? Yes NoThank you for your feedback. Report this reviewThank you, this review has been flagged.
Posted June 13, 2003
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. AlapatiWas this review helpful? Yes NoThank you for your feedback. Report this reviewThank you, this review has been flagged.
Posted April 26, 2003
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.Was this review helpful? Yes NoThank you for your feedback. Report this reviewThank you, this review has been flagged.