Oracle8i DBA Handbook with CDROM (Oracle Press) [Paperback]

Kevin Loney (Author), Marlene L. Theriault (Author)

Book Description

ISBN-10: 0072121882 | ISBN-13: 978-0072121889 | Publication Date: October 14, 1999

This is a thorough overhaul of the previous edition - widely considered the Oracle DBA "bible" - with full coverage of all the new Oracle8i features. This work covers everything the administrator needs to know to effectively manage a robust, peak-performance Oracle8i database. It explains how to configure Oracle to be accessed through a firewall from a DBA's perspective. "Solutions" sections illustrates - with annotations - how to implement the techniques described in each chapter.

Editorial Reviews

Amazon.com Review

All database administrators need a set of trusty resources to look to for guidance in managing systems as complex as Oracle8i. Oracle8i DBA Handbook is just one of these essential tools with an emphasis on the big picture--what the authors call "effective and efficient" management. This isn't a guide to troubleshooting daily disasters but rather a strategic look at setting up and rearchitecting databases wisely to perform well over the long haul.

Authors Kevin Loney and Marlene Theriault, both seasoned DBAs themselves, address all the major aspects of wise Oracle architecture design. They begin with an Oracle overview and a look at hardware configurations and considerations. While previous knowledge of Oracle will enable readers to put this material most quickly to use, the presentation is straightforward and appropriate to those moving from other relational DBMS's such as SQL Server.

The text includes excellent coverage of logical and physical database layouts, as well as great chapters on performance tuning, security auditing, and backup/restore strategies. Oracle Application Server is introduced, but only briefly; the focus of this book is the administration of the core Oracle product.

A large chunk of the book is devoted to the reprinted SQL language reference from the product's official documentation. Of all the Oracle tutorials and guides out there, this one should be a mandatory part of any Oracle DBA's arsenal. --Stephen W. Plain

Topics covered: Oracle architecture, hardware configurations, logical and physical database layouts, database monitoring, rollback segment management, performance tuning, security, backup and recovery, large database management, networking environments, configuring for Web environments, and Oracle8i SQL language.

From the Back Cover

The Essential Resource on Administering and Managing Oracle 8i.

Maintain a robust, mission-critical Oracle8i database--the most manageable Web-enabled enterprise database system available. Oracle8i DBA Handbook provides high-end administrative solutions for the day-to-day DBA. Inside, you'll learn to set up a database for maximum efficiency, monitor it, tune it, and maintain its security. The book also explains in detail how to use Oracle's distributed database and its client/server, Oracle8i, and all of its revolutionary new Web-based features.

This authoritative resource contains the most up-to-date information available on Oracle's latest release and shows you how to:

• Configure database architecture, including hardware and physical layout
• Manage the development process
• Support Oracle tools and packages, including Oracle Financials, Oracle Designer, and other utilities
• Handle database tuning, troubleshooting, backup, and recovery
• Implement SQL*Net V2 and Net8
• Manage distributed databases and configure client/server and Web-based environments

Ideal for new and experienced DBAs alike, Oracle8i DBA Handbook is the must-have resource on creating and administering a high-performance Oracle8i database for Internet computing.

See all Editorial Reviews

Product Details

• Paperback: 979 pages
• Publisher: Osborne Publishing (October 14, 1999)
• Language: English
• ISBN-10: 0072121882
• ISBN-13: 978-0072121889
• Product Dimensions: 9.1 x 7.3 x 2.2 inches
• Shipping Weight: 4.4 pounds
• Average Customer Review: 3.7 out of 5 stars  See all reviews (18 customer reviews)
• Amazon Best Sellers Rank: #2,386,433 in Books (See Top 100 in Books)

Customer Reviews

Most Helpful Customer Reviews

36 of 41 people found the following review helpful:

5.0 out of 5 stars The most useful and complete DBA book, February 21, 2000

By 

Gamal Abd El-Shafy Ebrahim (Cairo, Egypt) - See all my reviews

This review is from: Oracle8i DBA Handbook with CDROM (Oracle Press) (Paperback)

This book is a very useful book for both experienced DBA and Beginners as well as for an application developer. It gives a complete coverage of Oracle 8i DBA as well as Oracle 7.x

A large number of examples and tips that helps DBA to perfectly tune an Oracle database. Very usefel chapters about database tunning these help me to perfectly tune our Oracle databases. and to enhance its performance.

A very useful appendix of the most commonly used SQL commands in database administration.

I have read a large number of books in Oracle DBA, this book is the most useful one. I refer to this book every day in my work.

It is a very good investment. If you intend to buy a book in Oracle DBA buy this book now.

21 of 23 people found the following review helpful:

5.0 out of 5 stars ORACLE 8i DBA .............BEST BUY, February 11, 2000

By 

"mzahid" - See all my reviews

This review is from: Oracle8i DBA Handbook with CDROM (Oracle Press) (Paperback)

Very well explained and enough examples for you to get started if you are a beginning your career in ORACLE Database Administration or if you are an expert this book covers all the topics of Oracle DBA along with some Java. But this book does not cover ORACLE PL/SQL programming. Covers Oracle Networking on NT & Unix. Since Oracle 8i is web-enabled software for you to understand Oracle 8i programming better you will also need to buy "ORACLE 8i SQLJ PROGRAMMING" as well as "ORACLE8 PL/SQL PROGRAMMING" by Oracle press.

18 of 20 people found the following review helpful:

5.0 out of 5 stars Useful and complete, December 22, 1999

By A Customer

This review is from: Oracle8i DBA Handbook with CDROM (Oracle Press) (Paperback)

This book would be good both for beginners and for experienced DBAs. There are definite beginner parts, as well as tricks and scripts that more experienced DBAs should like to have. Skip the parts that don't apply to your level. Overall a good read, no errors yet.