Expert Oracle Database 10g Administration (Expert's Voice) Paperback – 5 Jun 2006
Enter your mobile number or email address below and we'll send you a link to download the free Kindle App. Then you can start reading Kindle books on your smartphone, tablet, or computer - no Kindle device required.
To get the free app, enter your mobile phone number.
Would you like to tell us about a lower price?
If you are a seller for this product, would you like to suggest updates through seller support?
About the Author
Sam R. Alapati is an experienced Oracle database administrator who holds the Oracle Certified Professional designation and the Hewlett-Packard UNIX System Administrator certification. He currently manages Oracle databases at the Boy Scouts of America's 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.
Top customer reviews
Most helpful customer reviews on Amazon.com
Is in need of some technical editing, e.g., (page 206) "Under this constraint state, all new inserts and updates will be checked for compliance. Because the existing data *won't* [emphasis mine] be checked for compliance, there's no assurance that ..." Much of what is written in chapter 6 (Schema Management) is from a data warehouse point of view. This fact is not made clear--heaven help the novice DBA wanting to implement materialized views in his/her 100 Mb database.
Oracle's powerful new version of OEM is given a spare (for a book of this size and scope) 25 pages. However, many of OEM's features are discussed separately under other topics. This may be a matter of taste, but I would have preferred a discussion of all the utilities in OEM in the OEM chapter, and not have to go hither and yon throughout the book for this info.
There is some very good information here. It is not, however, organized for utility. It could have used more diagrams in places. And, for a book whose introduction indicates that the audience is novice DBAs, there is emphasis on some esoteric details (materialized views, flashback tables, etc.), and thin on others.
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.
The book provides excellent coverage of all 10g features, such as the Automatic Workload Repository and the Automatic Database Diagnostic Monitor (ADDM). There is very good coverage of features such as the SQL Advisor and the Segment Advisor.
The book's great feature is that in addition to clearly explaining the various topics, it provdes useful examples or scripts to help implement/use the various features. This makes it a very useful and practical addition to any Oracle DBA either currently using or planning to implement Oracle Database 10g.
For those just starting out, the book also provides excellent tutorials on Oracle SQL/PLSQL and the UNIX operating system as well.
Part 1 can be considered as a refresher. In part 1 the author covered important topics such as Data modeling, Normalization, tools and utilities in UNIX/LINUX a DBA needs for his job. The rest of the book focused on Oracle database 10g. The following areas (Architecture, Installation, Connectivity and User Management, Backup and Recovery, Database Management, Performance Tuning etc..) were covered in great details. For almost every thing the author provides an example to back his writing. This style was very helpful and you can test the examples yourself to see the result.
The step by step instruction of installing Oracle 10g on Unix/Linux is well done in the book. I have used it many times and it works.
Even though much of the examples in the book are on Unix or Linux platform, there is a chapter that covers Oracle 10g on Windows.
Overall it is a good book to use as a reference. It provides a lot of information you can quickly use and get your database up and running. I highly recommend it.
Look for similar items by category
- Books > Computing & Internet > Certification > Subjects > Oracle
- Books > Computing & Internet > Computer Science > Operating Systems
- Books > Computing & Internet > Databases > Data Storage & Management > Database Management Systems
- Books > Computing & Internet > Databases > Oracle
- Books > Computing & Internet > Digital Lifestyle > Online Shopping > Amazon
- Books > Computing & Internet > Programming > Software Design, Testing & Engineering > Functional Programming
- Books > Computing & Internet > Programming > Software Design, Testing & Engineering > Software Architecture