Oracle8 Administration and Management

By Michael R. Ault

In Oracle8 Administration and Management, Oracle pro Michael Ault arms you with all the tips, techniques, and software tools you need to keep your Oracle7 or 8 database running quickly, efficiently, and reliably. A completely updated and expanded version of its bestselling predecessor, this book covers all of Oracle8's new features, explains how the new release will impact on day-to-day database administration and management, and includes loads of new scripts and real- world examples. You get everything you need to: Install Oracle8 Administer your database using system features and third-party tools Administer database objects, including tables, indexes, clusters, sequences, views, triggers, procedures, and the new Oracle8 features Set up and administer users Use Oracle packages, procedures, methods, and utilities Monitor your system, troubleshoot problems, recovery and backup Fine-tune your database for optimum efficiency Manage distributed databases Use Oracle object extensions. The CD-ROM gives you: All the scripts from the book Products like Savant's Q Diagnostic CenterTM, which allows you to monitor and analyze your database All code from the book in Visual Dictionary Lite, which you can use to transfer code to SQL*Plus.

• Format: Paperback
• Language: English
• ISBN: 0471192341
• ISBN13: 9780471192343
• Release Date: December 1997
• Publisher: Wiley
• Length: 880 Pages
• Weight: 3.25 lbs.
• Dimensions: 1.8" x 7.5" x 9.3"

Customer Reviews

Mike knows his stuff . . .

This book remains one of the foremost Oracle reference books in the market. Mike is a GREAT script writer, and he has always had a reputation for digging into the bowels of Oracle.

Thorough coverage with a few flaws

Once you get past the author's ego (all the wonderful applications he's created or the tests he's created), the book is extremely thorough. But when I gave his test of what a DBA should know to the other seven "full charge" DBAs in my office, none of them passed (which also shows he believes he is the smartest DBA in the world).He might be smart, but he's not organized. When I read the chapter on table administration, he started with railroad diagrams of the syntax. This was followed by a jumble of clauses in no particular order (not even in the same order as shown in the railroad diagrams). I would have preferred to see clauses grouped at least by the type of table being created (partition table, index table, etc).There are minor errors in the code printed in the book (like NVL() changing to NIL()). That's to be expected. But when you go to the CD-ROM to get the "real" source code (supposedly without the errors), you find that the source code ! is in PDF (Adobe Acrobat) format rather than in editable ASCII text. That means you have to manually type the scripts in yourself. In fact, the only value in the CD is that it contains demo versions of software (which the author helped write) that you are expected to purchase.However, in spite of its downside, the book is chock full of useful information ... if you want to spend the time organizing it yourself. It's obvious the author simply patched in Oracle8 changes to an Oracle7 book.