Product Description

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

This book covers the new 10g 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 10g databases.

Product Details

• Amazon Sales Rank: #267688 in Books
• Published on: 2005-09-16
• Original language: English
• Number of items: 1
• Binding: Paperback
• 1304 pages

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.

Customer Reviews

massively comprehensive- for DBAs and developers
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.

Everything you want in a book this heavy
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.

read one month before taking the class, at lease
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