Oracle9i Administration and Management [Paperback]

Michael R. Ault (Author), Michael Ault (Author)

Book Description

ISBN-10: 0471218863 | ISBN-13: 978-0471218869 | Publication Date: July 15, 2002 | Edition: 1st

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 organizations still support these versions
• Companion Web site includes all of the software scripts to manage a database, plus links to lite and demo versions of database management software and other DBA tools

Editorial Reviews

From the Back Cover

A complete guide to the best techniques, tips, and tools for managing Oracle databases

Oracle is the leading database worldwide, providing companies with fast access to critical business data. Oracle Administration and Management shows database administrators and managers how to keep Oracle databases running reliably and at peak performance. With the help of numerous real-world examples and scenarios, you'll gain valuable insight into all phases of Oracle database administration and management. From the initial installation and daily maintenance to backup and recovery procedures, you'll learn everything you need to know to become a successful Oracle DBA. Thoroughly updated for Oracle Release 9i, this book also provides complete coverage of Releases 8 and 8i, and shows you how to:
* Manage your Oracle database using best practices tested at operational Oracle sites
* Efficiently monitor and manage your Oracle8, 8i, or 9i database using more than 400 automated scripts
* Avoid pitfalls in the installation, upgrade, and migration to Oracle9i technology
* Utilize Oracle's undocumented parameters and events to more effectively manage your Oracle database
* Use Oracle Enterprise Manager to help monitor and manage your database
* Tune the database and troubleshoot problems using field-tested techniques
* Understand Oracle9i Real Application Clusters and their implementation

The companion Web site includes all the scripts from the book, plus links to demo and lite versions of database management software and other DBA tools.

About the Author

MICHAEL AULT is a Senior Technical Management Consultant for the Atlanta office of TUSC, Inc. He is also the systems operator for Quest-RevealNet Lab's DPAPipeline forum and writes articles regularly in Oracle Internals and Select. Previously, Ault was a senior consultant for the DBAGroup LLC and the corporate technical officer of DBMentors International, which he founded after four years as the associate director for the Oracle practice at DMR Consulting Group.

Product Details

• Paperback: 1024 pages
• Publisher: Wiley; 1st edition (July 15, 2002)
• Language: English
• ISBN-10: 0471218863
• ISBN-13: 978-0471218869
• Product Dimensions: 9.2 x 7.5 x 2.2 inches
• Shipping Weight: 3.8 pounds
• Average Customer Review: 3.9 out of 5 stars  See all reviews (9 customer reviews)
• Amazon Best Sellers Rank: #2,622,884 in Books (See Top 100 in Books)

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Most Helpful Customer Reviews

5 of 5 people found the following review helpful:

2.0 out of 5 stars Not for beginners and not for Learning Oracle, November 11, 2002

By A Customer

This review is from: Oracle9i Administration and Management (Paperback)

This book is not for beginners and is not suitable for learning Oracle either. Just an example you can sense the style of the book, it spends 15 pages to list all initialization parameters and over 20 pages on undocumented initialization parameters.

The explanation of the concepts is too much alike the on-line document. The book used many scripts but few can be found from the download on the book's website. The code you find on the website is what the author used in his work but may not be relevant to someone who uses the book to learn Oracle. The code is not well-organized either. The explanation of the examples and code is inconsistent and sketchy¡ªsometimes very detailed but other times missing major pieces.

The book is bulky but not very comprehensive. It has very week coverage on architectures, backup and recovery, and net services. It doesn't cover advanced security features either. It assumes the reader has pretty good knowledge of SQL and PL/SQL.

Given what is said, an experienced DBA may find some reference value in it.

1 of 1 people found the following review helpful:

5.0 out of 5 stars lot of integrity and commitment to his readers, September 16, 2004

By 

Nagel Rainer (Zurich, Switzerland) - See all my reviews
(REAL NAME)   

This review is from: Oracle9i Administration and Management (Paperback)

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.

3 of 4 people found the following review helpful:

5.0 out of 5 stars Great for Any Release, July 8, 2002

By A Customer

This review is from: Oracle9i Administration and Management (Paperback)

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.