Pro Oracle Database 11g Administration / Edition 1

Paperback (Print)
Buy New
Buy New from
Used and New from Other Sellers
Used and New from Other Sellers
from $29.99
Usually ships in 1-2 business days
(Save 50%)
Other sellers (Paperback)
  • All (13) from $29.99   
  • New (9) from $38.23   
  • Used (4) from $29.99   


Pro Oracle Database 11g Administration is a book focused on results. Author Darl Kuhn draws from a well of experience over a decade deep to lay out real-world techniques that lead to success as an Oracle Database administrator. He gives clear explanations on how to perform critical tasks. He weaves in theory where necessary without bogging you down in unneeded detail. He is not afraid to take a stand on how things should be done. He won’t leave you adrift in a sea of choices, showing you three ways to do something and then walking away.

Database administration isn’t about passing a certified exam, or about pointing-and-clicking your way through a crisis. Database administration is about applying the right solution at the right time, about avoiding risk, about making robust choices that get you home each night in time for dinner with your family. If you have “buck stops here” responsibility for an Oracle database, then Pro Oracle Database 11g Administration is the book you need to help elevate yourself to the level of Professional Oracle Database Administrator.

  • Condenses and organizes the core job of a database administrator into one volume.
  • Takes a results-oriented approach to getting things done.
  • Lays a foundation upon which to build a senior level of expertise

What you’ll learn

  • Create a stable environment consistent across all databases that you manage
  • Take care of job #1: backing up, and then recovering when needed
  • Manage users and objects, and the security between them
  • Do battle with “large”—large databases and large objects
  • Move and distribute data using Data Pump, materialized views, external tables
  • Automate critical jobs and tackle database troubleshooting problems

Who this book is for

Pro Oracle Database 11g Administration is aimed at new database administrators who aspire to senior positions in which employers and customers trust you to work independently, and with a “buck stops here” attitude.

Table of Contents

  1. Installing the Oracle Binaries
  2. Implementing a Database
  3. Configuring an Efficient Environment
  4. Tablespaces and Datafiles
  5. Managing Control Files and Online Redo Logs
  6. Users and Basic Security
  7. Tables and Constraints
  8. Indexes
  9. Views, Synonyms, and Sequences
  10. Data Dictionary Basics
  11. Large Objects
  12. Partitioning: Divide and Conquer
  13. Data Pump
  14. External Tables
  15. Materialized Views
  16. User-Managed Backup and Recovery
  17. Configuring RMAN
  18. RMAN Backups and Reporting
  19. RMAN Restore and Recovery
  20. Oracle Secure Backup
  21. Automating Jobs
  22. Database Troubleshooting

Read More Show Less

Product Details

  • ISBN-13: 9781430229704
  • Publisher: Apress
  • Publication date: 12/29/2010
  • Edition description: 2010
  • Edition number: 1
  • Pages: 720
  • Sales rank: 1,548,527
  • Product dimensions: 7.40 (w) x 9.10 (h) x 1.70 (d)

Meet the Author

Darl Kuhn is a senior database administrator working for Oracle. He handles all facets of database administration from design and development to production support. He also teaches advanced database courses at Regis University in Colorado. Darl does volunteer DBA work for the Rocky Mountain Oracle Users Group. He has a graduate degree from Colorado State University and lives near Spanish Peaks, Colorado, with his wife, Heidi, and daughters, Brandi and Lisa.
Read More Show Less

Table of Contents

• Installing the Oracle Binaries
• Implementing a Database
• Configuring an Efficient Environment
• Tablespaces and Datafiles
• Managing Control Files and Online Redo Logs
• Users and Basic Security
• Tables and Constraints
• Indexes
• Views, Synonyms, and Sequences
• Data Dictionary Basics
• Large Objects
• Partitioning: Divide and Conquer
• Data Pump
• External Tables
• Materialized Views
• User-Managed Backup and Recovery
• Configuring RMAN
• RMAN Backups and Reporting
• RMAN Restore and Recovery
• Oracle Secure Backup
• Automating Jobs
• Database Troubleshooting

Read More Show Less

Customer Reviews

Average Rating 5
( 1 )
Rating Distribution

5 Star


4 Star


3 Star


2 Star


1 Star


Your Rating:

Your Name: Create a Pen Name or

Barnes & Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation


  • - By submitting a review, you grant to Barnes & and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Terms of Use.
  • - Barnes & reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously
Sort by: Showing 1 Customer Reviews
  • Posted January 31, 2011

    Pro Oracle Database 11g Administration is a great book

    On the back cover of this book it says "Pro Oracle Database 11g Administration is a task-oriented guide to managing complex database environments using Oracle Database11g".

    The thing I like most about this book is that it lives up to this promise. The book covers all aspects of Oracle Database 11g Administration. It starts with installation and implementation, goes through database management, understanding and managing users/security, architecture, etc. It has several great chapters on RMAN. I cannot think of any area that is not covered.

    I really like the "task-oriented" approach. For every topic, the author provides step-by-step instructions, complete with scripts for accomplishing each task. Something very nice is that he discusses alternatives for accomplishing tasks, the pros and cons of alternatives and then says how he likes to do it and why. For me, this approach provides a real-world practicality.

    If there is one thing I would have liked, that is not present, it would be a separate section devoted to 11g features. Although the author discusses what is specific to 11g, it is scattered throughout the book, within the relevant topic chapter. My style is that I would like a separate section, in addition to this, that summarizes new features.

    The last chapter of the book talks about troubleshooting and auditing. This is where a dba needs to act quickly and effectively. I think this is where most dba's can do better and where this book can help. The book addresses identifying the most common issues and identifying them quickly. Again, the author provides great step-by-step instructions in the sequence that they should be performed. He gives the exact commands (sql and os) that should be entered, why the command is used and how to view the results. There are also scripts that automate some of this. There is even a very nice script that lets you view the alert log from anywhere on the server. This script, like many of the provided scripts work on any server with no alterations (using functions, etc.). The author again tells you his personal methodology and approach to troubleshooting, which I think really adds a lot of substance to the material.

    Overall, I think this is a great book. By providing step-by-step approaches, the scripts, and the author's own methodology for addressing these tasks, I think this will be a valuable and unique addition to any library.

    Was this review helpful? Yes  No   Report this review
Sort by: Showing 1 Customer Reviews

If you find inappropriate content, please report it to Barnes & Noble
Why is this product inappropriate?
Comments (optional)