- Taschenbuch: 1248 Seiten
- Verlag: Apress; Auflage: Softcover reprint of the original 1st ed. (25. April 2003)
- Sprache: Englisch
- ISBN-10: 1590590228
- ISBN-13: 978-1590590225
- Größe und/oder Gewicht: 17,1 x 5,7 x 22,9 cm
- Durchschnittliche Kundenbewertung: 1 Kundenrezension
- Amazon Bestseller-Rang: Nr. 3.796.663 in Fremdsprachige Bücher (Siehe Top 100 in Fremdsprachige Bücher)
- Komplettes Inhaltsverzeichnis ansehen
Expert Oracle9i Database Administration (Englisch) Taschenbuch – 25. April 2003
Dieses Buch gibt es in einer neuen Auflage:
Es wird kein Kindle Gerät benötigt. Laden Sie eine der kostenlosen Kindle Apps herunter und beginnen Sie, Kindle-Bücher auf Ihrem Smartphone, Tablet und Computer zu lesen.
Geben Sie Ihre Mobiltelefonnummer ein, um die kostenfreie App zu beziehen.
Wenn Sie dieses Produkt verkaufen, möchten Sie über Seller Support Updates vorschlagen?
This is the only real Oracle 9i Database Administration book on 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.
Über den Autor und weitere Mitwirkende
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.
Derzeit tritt ein Problem beim Filtern der Rezensionen auf. Bitte versuchen Sie es später noch einmal.
Das Buch glänzt dadurch, alle wesentlichen Punkte der Datenbankadministration anzusprechen und vertiefend auf neue 9i Funktionalitäten einzugehen und gleichzeitug Praxistips zu liefern.
Gleichzeitig nimmt es Abstand von den in der OraclePress häufiger vorkommenden "Lobhudeleien" und dem Drucken von Screenshots, obwohl auch in diesem Buch für neue Funktionalitäten einige vorkommen - aber nicht überladend.
Dass ein Werk von über 1K+ Seiten nicht frei ist von Typos macht den Gebrauchswert nicht schmaler.
Die hilfreichsten Kundenrezensionen auf Amazon.com
1)This book is definitely not for the beginners. I highly recommend you start with a more basic book that gives you an overview of Oracle. Oracle tools are highly unintuitive and using them can be a frustrating experience especially for MS SQL DBAs *smirk*. Learning to just to connect to an Oracle database is a learning experience that will take knowledge on how Oracle's network and security function.
2)If you already have a working knowledge on how to operate an Oracle database, this book will no doubt provide a more solid foundation for your knowledge (except RAC). I particularly found its chapters on RMAN and IMPORT/EXPORT utilties particularly helpful.
3)Perhaps the best part of this book is that it encompasses what the author believes is the most essential knowledge to becoming a highly competent Oracle DBA. The book does not try to be a reference for every Oracle topic. Instead, the author has smartly picked the most important information needed and presented them in a readable format.
4)My only issue with this book is that it is wordy. The book is 1200 pages long and it could easily have been 1000 pages or fewer.
I feel the author made a very good attempt to write a comprehensive useful reference on Oracle 9, but the information is very often: a) too cursory, b) rife with mistakes or typos that are serious.
What is needed is very simple: the author must sit down with a novice Oracle user/developer such as myself and observe the user try to apply the information in the book to actual tasks. Then the book should be rewritten to clarify / correct the information in the book.
In the few areas I have tried to apply the information in the book, I have inevitably had problems where key information was missing, confusing, or wrong.
In setting up tables for gathering statistics for the optimizer, the author seems to confuse the concept of the actual data dictionary statistics table with a holding table that is not immediately applied.
In describing the imp and exp import and export utilities, try to find where the author tells you how to export data from one database and import it into another database on the same server. Where do you specify the database?
Here's another one I am editing into this review based on recent experience:
In chapter 18 "Improving Database Performance: SQL Query Optimization", the author discusses the "Explain Plan" facility to reveal the plan that the optimizer has chosen for your query. The plan should be a vital tool to help you tune your query and troubleshoot performance problems.
However, the examples the author gives us are woefully inadequate because the plan information does not include the filter (WHERE clause) information for each index scan, table scan, etc. operation. If your query is at all complicated, you will be immediately lost as to which part of your query the operation pertains to or what it is doing.
However, the filter information is indeed available in the "plan_table" (in the ACCESS_PREDICATES and FILTER_PREDICATES columns) -- Alapati simply neglects to tell us about it or use it.
Even worse, he fails to point out the supplied utility which provides the best presentation of the plan and also the simplest and easiest way to get it -- the "utlxpls.sql" script in the "$ORACLE_HOME/rdbms/admin" directory. Run that and you are home free.
These are the gems that an author should steer you to, but time and again he misses them. A great book should cut to the chase and save you time and effort. Perhaps in his 10g book he has improved things. In this 9i book he repeatedly falls short.
I would never rely on this book to get a job done. But it probably makes a good "survey" read to identify topics and issues to explore further. However, given that, the book should either be 1/3 as long (survey) or 3 times a long (thorough reference) to be useful.
Some areas I like the most were the discussions of optimization (which seemed to cover more than expected, but I haven't gone too deeply into it. Note my critique of "Explain Plan") and operating system specific advice, such as uninstalling under Windows. But the OS advice should probably be a separate book, there are so many gotchas and hidden rules as to how Oracle decides where certain files are, etc.
This book is just not enough for actual use. But I think it could be if the author sat down with real users and really understood the problems encountered and discussed all the pertinent cases that arise. Again, you might end up with three volumes.
usable from a practical point of view.
I found the chapter on data loading very interesting,
and found out several new innovations in the 9i database concerning the new ways to load data, like external tables etc.
The book provides a good explanation of the msot important DBA dynamic performance views and Oracle supplied packages. These sections can be used as an introduction to several new packages and so on, before you try to hit the bulky Oracle manuals.
All in all,
a must have book for any Oracle9i DBA. I've been an Oracle DBA for several years now, and although I know or have herd of several of the 9i topics discussed in this book, haven't
seen any other book atttempt to bring all the key
9i DBA topics under one cover.
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 .
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