Expert Oracle Database 10g Administration (Expert's Voice) (Paperback)

by Sam R. Alapati (Author)

Editorial Reviews

Product Description
<p>This is a unique, one-volume guide to the administration and management of the Oracle database. Fully revised and updated from its best-selling 9<i>i</i> predecessor, this edition covers all new features, with fully field-tested examples&emdash;not just "showcase" examples.</p>

<p>This book covers the new 10<i>g</i> management and performance tools and provides essential primers on Unix, Linux and Windows NT administration and on core SQL and PL/SQL programming techniques. And it provides everything the new and aspring Oracle DBA needs to build and admisiter complex Oracle 10<i>g</i> databases.</p>

About the Author
Sam R. Alapati is an experienced Oracle database administrator who holds the Oracle OCP DBA and the Hewlett-Packard UNIX System Administrator certifications. He currently manages Oracle databases at the Boy Scouts of America National Headquarters in Los Colinas, Texas. Alapati has been dealing with databases for a long time, including the Ingres RDBMS in the mid 1980s. He is also well versed in the Microsoft SQL Server, Sybase, and IBM DB2 database management systems.

Product Details

• Paperback: 1304 pages
• Publisher: Apress; 1 edition (September 16, 2005)
• Language: English
• ISBN-10: 1590594517
• ISBN-13: 978-1590594513
• Product Dimensions: 9.2 x 7 x 2 inches
• Shipping Weight: 4 pounds
• Average Customer Review: 4.0 out of 5 stars See all reviews (13 customer reviews)
• Amazon.com Sales Rank: #520,214 in Books (See Bestsellers in Books)

Customer Reviews

Most Helpful Customer Reviews

6 of 7 people found the following review helpful:

5.0 out of 5 stars massively comprehensive- for DBAs and developers, October 10, 2005

By	W Boudville (Terra, Sol 3) - See all my reviews (TOP 50 REVIEWER)    (REAL NAME)

This comprehensive tome spans some 1200 pages. Divided into 8 parts, each being some broad topic revolving around 10g. The first Part is just background, on data modelling and what it means to run 10g under a unix or linux operating system. This Part should be easy review for most experienced readers.

Part 2 describes the architecture and schema management used under 10g. And by the way, the book is focused on 10g; not on earlier versions. This Part is well worth understanding. It is here that the basic design information for laying out your database is to be found. You also find numerous utilities provided by Oracle, like the System Monitor, that help your management of the database.

Some later Parts are straightforward but somewhat mundane. Specifically about installing 10g and making databases, and about loading data and backing up your data. To a DBA, this are vital tasks; don't get me wrong. But there's nothing too complicated here. And if you are a developer, these Parts can be safely skipped.

Part 7, on performance tuning, is also where a developer should profitably check out. In tandem with understanding the basic layout of your tables, this Part may let you overcome bottlenecks.

Given the size of the book, perhaps the best way to approach it is to focus on a single suitable Part at a time. Each Part is long enough to ensure a serious commitment of your attention, but still not be overwhelming.

13 of 17 people found the following review helpful:

5.0 out of 5 stars Everything you want in a book this heavy, October 4, 2005

By	Jack D. Herrington "engineer and author" (Silicon Valley, CA) - See all my reviews (TOP 500 REVIEWER)    (REAL NAME)

I usually avoid the tomes, unless they are from APress. Where other publishers will put out 1200 page tomes that are all screenshots, with APress it's mainly text. Well written, well organized, well presented text that is informative and straight to the point.

Seriously, there is a lot to know about Oracle administration. And Sam does a great job laying it all out. From the basics of schema maintenance, to some background on unix and linux (possibly the only fat in the book), to advanced topics like database monitoring, materialized views, and performance tuning. This is a master work.

I stronly recommend it.

1 of 1 people found the following review helpful:

5.0 out of 5 stars read one month before taking the class, at lease, August 9, 2007

By	Zhuohuali "John Li" (San Francisco, CA) - See all my reviews (REAL NAME)

read one month before taking the class, at lease, because it's not a 1200 pages book full of snapshot, but full of characters. good for students who never touch the Unix/Linux subject