Oracle Database 10g DBA Handbook [Paperback]

Kevin Loney (Author), Bob Bryla (Author)

Book Description

Publication Date: March 24, 2005 | ISBN-10: 0072231459 | ISBN-13: 978-0072231458 | Edition: 1st

Everything a DBA needs to know in one volume--this is the must-have reference for anyone working with the Oracle database, and it’s been fully revised and updated for Oracle Database 10g. Co-author Kevin Loney is the all-time, best-selling Oracle Press author.

Editorial Reviews

Review

If you are a new or established DBA or developer then this book will give you an excellent grounding on how the Oracle 10g Database works and how to upgrade your current database to 10g. Oraclehome.co.uk 20050805

From the Back Cover

The Essential Resource for All Oracle Database Administrators

Maintain a high-performance Oracle enterprise database with help from this exclusive Oracle Press guide. Oracle Database 10g DBA Handbook explains how to install Oracle Database 10g, or upgrade from an earlier version, and take full advantage of all the new and improved management, scalability, availability, and security features. Written by Oracle experts, the book covers Automatic Undo Management, Oracle Real Application Clusters, Oracle Recovery Manager, Oracle Data Guard, and much more.

• Plan tablespaces--including bigfiles and multiple temporary tablespaces--and physical database layout
• Manage disk space and CPU usage
• Use Automatic Undo Management to manage transactions
• Tune queries using the SQL Access Advisor
• Monitor and tune your database with the Automated Workload Repository and STATSPACK
• Implement fine-grained security using authentication, authorization, and auditing techniques
• Automate the management of the memory areas
• Enable high availability using Oracle Real Application Clusters
• Perform backup and recovery with Oracle Recovery Manager
• Use Oracle Data Guard and the flashback features for data protection and disaster recovery
• Manage Very Large Databases (VLDB) and distributed databases

About the Authors: Kevin Loney is a senior technical management consultant with TUSC, a Chicago-based consultancy providing Oracle solutions. He has been an Oracle developer and DBA since 1987, and has written for Oracle Magazine and Oracle Press since 1990. In 2002, he was named Oracle Magazine’s Editors’ Choice as Consultant of the Year. He is a frequent and highly rated speaker at local and international Oracle user groups. Bob Bryla is an Oracle 8, 8i, 9 and 10g Certified Professional with more than 15 years of experience in database design, database application development, training, and Oracle database administration. He is the primary Internet database designer and an Oracle DBA at Lands’ End in Dodgeville, Wisconsin.

See all Editorial Reviews

Product Details

• Paperback: 736 pages
• Publisher: McGraw-Hill Osborne Media; 1st edition (March 24, 2005)
• Language: English
• ISBN-10: 0072231459
• ISBN-13: 978-0072231458
• Product Dimensions: 9 x 7.4 x 1.5 inches
• Shipping Weight: 2.7 pounds (View shipping rates and policies)
• Average Customer Review: 3.5 out of 5 stars  See all reviews (11 customer reviews)
• Amazon Best Sellers Rank: #265,783 in Books (See Top 100 in Books)
  • #24 in Books > Computers & Technology > Databases > Oracle
  • #51 in Books > Computers & Technology > Databases > Relational Databases

Customer Reviews

Most Helpful Customer Reviews

17 of 17 people found the following review helpful:

5.0 out of 5 stars Great Book. Not for Beginners, September 15, 2005

By 

Daniel (SF, CA USA) - See all my reviews

This review is from: Oracle Database 10g DBA Handbook (Paperback)

This book is definitely not for beginners. If you already have a working knowledge of how to operate an Oracle database, this book will provide a more solid foundation for your knowledge. I particularly found its chapters on RAC and High Availability helpful. The best part of this book is that it covers the most essential knowledge to becoming a highly competent Oracle DBA without trying to be a reference for every Oracle topic. I highly recommend this book.

14 of 14 people found the following review helpful:

5.0 out of 5 stars It is an excellent DBA Handbook, November 19, 2005

By 

TLAW_DBA "OCP Oracle 6i/9i/10g, SCSA Solaris ... (Montreal, QC Canada) - See all my reviews

This review is from: Oracle Database 10g DBA Handbook (Paperback)

The book is excellent in the sense that it went straight to the essential and important topics. I am surprised that they did cover a lot of topic in a few pages. The book does help if you have some experience with oracle and especially with 10g. If you are new to oracle I am pretty sure you pick up the wrong book and you will be shaken by the concepts in the book. Overall I recommend this book if you are already familiar with 10g.

9 of 10 people found the following review helpful:

1.0 out of 5 stars Forget it - RTFM, March 13, 2007

By 

P. Gallagher (Singapore) - See all my reviews
(REAL NAME)   

This review is from: Oracle Database 10g DBA Handbook (Paperback)

This book unfortunately does nothing to expand the body of knowledge beyond putting on paper what you can just as easily find in the standard documentation. I'm sorry I put my money down for this when I have the docs just a click away as I type.

I have tried a few times to use this as a reference, but each time it takes me about 3 pages to hit a deadend because of some question or situation that the book fails to address. In each case I have had to figuring it out for myself from the standard documentation/google etc.

The authors consistently fail to deliver the two things I look for in technical books:

(1) provide the insights on "why is it so?" - the explanation, mental models, frameworks that help readers move from just learning syntax to a deeper level of understanding. I want to read and learn from authors who are sufficiently skilled in their field with the powers of introspection and communication, who have put the time and effort to deeply consider a subject before turning their learnings into a book.

(2) supplement the existing body of knowledge with new knowledge or at least a new organisation of knowledge that facilitates learning or understanding.

I have had the same reaction to other titles in the Osborne Oracle Press series; I thought I'd give this a go but now sorry I did. In future there is no place for these books in my shopping cart!