Mastering Oracle8i [Paperback]

Mark D. Blomber (Author), Mark D. Blomberg (Author)

Book Description

Publication Date: December 13, 2001 | Series: Mastering

Oracle8i is Oracle's flagship database product and runs on Windows, Unix, and Linux. This text provides intermediate to advanced coverage of Oracle8i with a strong focus on Web issues. The companion CD-ROM includes the Oracle8i Enterprise Edition, a collection of Oracle DBA utilities, Oracle KnowledgeBase reference information from RevealNet, and a fully searchable electronic edition of the book.

Editorial Reviews

Amazon.com Review

Massive in size, comprehensive in scope, and unfortunately quite dry in tone, Mastering Oracle 8i has the answers you need if you're working with the Oracle 8i database management system. The authors, one of whom holds an Oracle certification, go into considerable detail on the procedures to be followed for administrative tasks like backing up data, rolling back transactions, and configuring monitoring schemes. They usually share their thoughts on when and why you'd want to put the procedures to use, as well. Better yet, they go beyond everyday administrative work to cover subjects like materialized views, advanced user management, and performance-tuning techniques. There's some discussion of hooks for software developers, as well.

The authors' approach is to take a feature of the Oracle 8i environment--locks, say--and explain what purpose it serves, then break it down into component types with more detailed explanations. From there, the authors provide the commands and codes for viewing and manipulation of the feature, often with extensive tables. The really useful information comes next, in the form of sections on how to deal with related problems. The section on locks, for example, shows how to zero in on blocking locks. Other excellent coverage deals with how to dimension hardware, while a commendable section explains the object-oriented features of Oracle 8i. --David Wall

Topics covered: How to design and run a tight Oracle 8i ship, with special attention to object orientation, network connectivity, tablespaces, Recover Manager, parallel processing, security, and the special demands of distributed databases.

From the Back Cover

See How Easy Life as an Oracle8i DBA Can Be

With the power of Oracle8i comes considerable complexity. Mastering Oracle8i guides you through this complexity so you can take full advantage of the product's power and newest features. Inside, you'll find everything you need to know to make your work as an Oracle DBA as headache-free as possible-including step-by-step coverage of common and not-so-common administrative tasks, plus expert advice on avoiding most problems and solving others as quickly as they arise. Coverage includes:

* Migrating, upgrading, and creating Oracle8i databases
* Understanding and setting up partitioning and parallel processing
* Backing up and recovering data
* Understanding and using the data dictionary
* Tuning your database and Oracle SQL statements
* Monitoring database activity and performance
* Detecting and solving database problems
* Securing your database with Virtual Private Database and other features
* Designing an Oracle object-oriented database
* Loading external data with Oracle SQL*Loader
* Managing replication tasks
* Using Oracle's high-availability features
* Moving data with transportable namespaces

See all Editorial Reviews

Product Details

• Paperback: 1200 pages
• Publisher: Sybex Inc (December 13, 2001)
• Language: English
• ISBN-10: 0782129293
• ISBN-13: 978-0782129298
• Product Dimensions: 9 x 7.5 x 2.7 inches
• Shipping Weight: 4.4 pounds (View shipping rates and policies)
• Average Customer Review: 5.0 out of 5 stars  See all reviews (1 customer review)
• Amazon Best Sellers Rank: #3,975,049 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

4 of 4 people found the following review helpful:

5.0 out of 5 stars Great book!, April 4, 2002

By 

"a_simkovsky" (Miami, FL USA) - See all my reviews

This review is from: Mastering Oracle8i (Paperback)

This is another one of Robert's (and others) great works! This book is written well, and is geared towards providing the DBA early in his/her career the information needed to master the Oracle database and take the next step to becoming a senior DBA, and then on to being an expert. Each section provides detail explanations on how each piece of the system works, why it's there, how to monitor/tune/administer it, and special things to look out for. The book goes beyond the "basic" architecture and gives outstanding explanations for many of the advanced features, such as replication and data warehousing, and explains them in plain language that is easy to digest. An excellent reference for any DBA!