Oracle8i Administration and Management [Paperback]

Michael R. Ault (Author)

Book Description

ISBN-10: 0471354538 | ISBN-13: 978-0471354536 | Publication Date: October 20, 1999

If you rely on instant access to critical information on an Oracle database, then you must become familiar with every aspect of this system. From the initial installation and day-to-day maintenance to critical backup, recovery, and disaster recovery procedures, this completely updated book and CD-ROM provide you with the necessary tools to run a fast, efficient, and reliable Oracle database. The book is loaded with practical case examples and real-world scenarios. With its in-depth coverage of Oracle8i, you'll discover new object-oriented extensions that allow real-world modeling using the power of the relational engine. The book covers all new Oracle8i commands, packages, and database features, including the management of resource plans, temporary tables, locally managed tablespaces, and row-level security, along with from-the-trenches coverage of earlier versions of Oracle.

Packed with tips and techniques, this book will help you:
* Administer the Oracle database using system features and third-party tools
* Administer database subjects
* Setup and administer users
* Use racle-provided packages, procedures, and utilities
* Monitor the database and fix any problems
* Tune the database for optimum efficiency
* Manage distributed databases
* Use the latest Oracle8i object extensions

The CD-ROM includes:
* All of the scripts from the book
* Lite and demo versions of administration software
* Useful management aids

Michael Ault (Alpharetta, GA) is a senior consultant for DMR Consulting Group, where he is the Associate Director for the Oracle Practice. He is also the systems operator for RevealNet's DBAPipeline forum. His articles appear regularly in Oracle Internals and Select.

Editorial Reviews

Amazon.com Review

Oracle database administrators always have plenty on their plate. Oracle8i Administration and Management comes to the rescue with lots of guidance in creating and maintaining Oracle databases and keeping them running at top performance.

This is the latest revision of the DBA guide that has previously covered Oracle7 and, more recently, Oracle8. This update adds full coverage of Oracle 8i and includes an integrated discussion of the new version's object-oriented additions to the popular SQL database product. Author Michael R. Ault meticulously goes through the topics administrators care about most, presenting a detailed discussion of the underlying architectural details.

By organizing chapters according to administrative functions, such as "Tuning Oracle Applications" and "Database Internals Tuning," Ault has created a text that is quite handy for on-the-spot reference. A number of useful appendices on the companion CD-ROM offer plenty of useful management tidbits, as well as all of the code scripts used in the book and demonstration versions of management utilities.

This book uses an easy-to-read style and presents the information in a practical context--for example, this frank tip about installation under SCO Unix: "The server should be configured as an application server and not a file server or performance will not be acceptable." Oracle8i Administration and Management cuts no corners, offering comprehensive coverage of all of the important administrative topics. With its mature content and useful layout, this title is quite a fine DBA companion. --Stephen W. Plain

Topics covered: Installation, administration of tablespaces, tables, indexes and other objects, security, performance tuning, database monitoring, distributed configurations, and backup and recovery.

From the Back Cover

The best methods, tools, and techniques to keep your Oracle(r) database running at peak performance Oraclesi(TM) Administration and Management In this update to his bestselling Oracle book, author Michael Ault provides you with all the necessary tools to run a fast, efficient, and reliable Oracle database. Loaded with practical case examples and real-world scenarios, this book will give you the best methods, tools, and techniques for working with Oracle database versions 8i and earlier. With its in-depth coverage of Oracle8i, you'll discover new objectoriented extensions that allow realworld modeling using the power of the relational engine. All new Oracle8i commands, packages, and database features are covered, including the management of resource plans, temporary tables, locally managed tablespaces, and row-level security. Packed with tips and techniques, this book will help you:
* Administer the Oracle database using system features and third-party tools
* Administer database objects
* Set up and administer users
* Use Oracle-provided packages, procedures, and utilities
* Monitor the database and fix any problems
* Tune the database for optimum efficiency
* Manage distributed databases
* Use the latest Oracle8i object extensions
* Use the new space and security Oracle8i extensions
The CD-ROM includes:
* More than 200 software scripts for Oracle administration
* Lite and demo versions of administration software
* Useful management aids

See all Editorial Reviews

Product Details

• Paperback: 1024 pages
• Publisher: Wiley (October 20, 1999)
• Language: English
• ISBN-10: 0471354538
• ISBN-13: 978-0471354536
• Product Dimensions: 9.2 x 7.4 x 2.2 inches
• Shipping Weight: 3.9 pounds
• Average Customer Review: 4.6 out of 5 stars  See all reviews (7 customer reviews)
• Amazon Best Sellers Rank: #3,502,993 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

10 of 10 people found the following review helpful:

5.0 out of 5 stars When in doubt, look here first..., March 30, 2000

By 

Christopher J. Gait (Nokesville, VA USA) - See all my reviews
(REAL NAME)   

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

This is a great book if you are using 8i features and want to avoid some of the 'bumpies'. Example: Mike Ault's book is the only one I know of which warns you about putting an error-handler in your database-wide login trigger. If you don't do that (as I found out before I bought the book) you're going to be climbing in the back window by way of Server Manager to get your database functioning again.

It's a good book with a huge number of good scripts. You should buy it.

2 of 2 people found the following review helpful:

5.0 out of 5 stars Good database monitoring section, February 19, 2001

By 

hamconsulting "hamconsulting" (El Segundo, CA, USA) - See all my reviews

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

I bought the book because of the "monitoring database tables, indexes, clusters, snapshots, and objects" chapter. Lots of good SQL scripts on how to get the information you need to monitor your database. In addition, each script has a corresponding sample output section. This helps you see what output the script is going to generate.

2 of 2 people found the following review helpful:

5.0 out of 5 stars A very good book for Unix or NT, August 11, 2000

By 

Lee Collins (Marietta, Georgia USA) - See all my reviews

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

I found this book to be very helpful, especially as we are migrating from various 8.0.X versions. Much of the information and the scripts were useful with our exisitng systems but the real benefit will come when we convert all of our servers to 8.1.6. I think the book is clear and easy to follow - no errors so far. Even though some of the information is geared toward Unix (all of our boxes, except one is NT 4), the information is presented well enough that NT and Unix users alike will benefit.