Oracle9i Administration and Management

by Michael R. Ault

Many databases are large and complex, making them very difficult to manage. In turn, data can become difficult to access, expensive to store, and even damaged or destroyed. Oracle 9i offers new functionality for the Oracle database system, ensuring that the database runs quickly, efficiently, and reliably. Shows the best techniques, tips, and tools for Oracle systems New edition focuses on the 9i version, but also covers releases 8 and 8i since many...

• Format: Paperback
• Language: English
• ISBN: 0471218863
• ISBN13: 9780471218869
• Release Date: July 2002
• Publisher: John Wiley & Sons
• Length: 1008 Pages
• Weight: 3.81 lbs.
• Dimensions: 2.2" x 7.5" x 9.2"

Customer Reviews

lot of integrity and commitment to his readers

I have 2 years full time experience on Ora 8i & 9i.2 on windows 2000 and winXP german (Admin & programming) plus 3y. of Sybase DBMS. To get the job done, Bought tons of those fat bulky Oracle books of all these gurus (Loney, Urmann, Trezzo, ...) including 9i reference books. A lot of money thrown out! example: [Oracle9i PL/SQL by Urmann] fully wrong (with Ora 9.2) description of DBMS_Job package. Advantages of Mike's book in focus here: 1.) If you are in trouble (as usual with Oracle even simple examples sometimes do not work) and you need help it is ONLY Mike Ault who will reply!!! Well to me, that shows a lot of integrity and commitment to his readers. It is exactly what a reader needs when he is looking for new source of knowledge. 2.) Well now for this book: definitely one of the RARE better fat books, improved over its 8i version. I can really recommend to buy this one (Oracle9i Administration and Management). Excellent coverage of multi disk layout/installation and honest Oracle DBA job interview stuff which is not found in other books at all. Disadvantages: Maybe too much scripts optionally on the cd-rom for some readers, maybe one needs an "oracle beginners guide" book as well. Finally, Oracle (9i) Universal Installer and OEM (enterprise mgr) got more foolproof (8i was just a joke), try to install very small systems w/o a book first.

Vey nice text

This is the book that I use the most because it explains the issues in a clear way. I am not technical, so having complete examples is important to me, and I enjoy seeing the code listings. The CD with the scripts is also very useful.

rebuttal to some of the comments

Unfortunately we all have to live with limits. In the case of this book, many pages had to be cut to fit it into the tome it has become. The DBA arena has expanded such that no one book can cover it all. I have tried in this book to cover the important aspects of DBA work and provide what insights I have garnered from my experiences. I wish they would have continued the practice of including CDs with the book but I had no say in the matter. You can download all of the scripts, and then some, as well as my more recent papers from www.....com in the downloads discusion area under free stuff. I hope the more extensive papers and scripts on www.....com will help fill in any gaps that you, the reader, may find. If not I am always available by email,....net, or on the ....com DBA pipeline. I can also be contacted through TUSC at www.....com. The TUSC website is also loaded with papers and presentations.

Great for Any Release

I've been a big fan of Mike Ault's over the years, but I've got to say I was impressed by how he's revised this new edition of his Oracle book on administration and management. To be honest, we've just started to plan for deploying 9i, so I wasn't sure I'd find enough in this new edition that I could use now. But Ault has updated this book with a lot of new techniques not in the earlier edition that work with the 8i release we're running. Plus he's revised and added to the more than 200 scripts for automating management tasks---probably the best reason to buy this book.

Something for Everyone

I'm a pretty experienced DBA, but this book taught me some new tricks on such basics as using Oracle's packaged procedures and utilities. And Ault's stuff on troubleshooting, backup and recovery is very useful. Would highly recommend this to any Oracle DBA--newbies and experienced.