Apress Access

Pro Oracle Database 12c Administration

2nd Edition

By Darl Kuhn

  • eBook Price: $41.99
Buy eBook Buy Print Book
Pro Oracle Database 12c Administration is a task-oriented, best-practices approach to database administration using Oracle’s industry-leading database management system, Oracle Database 12c.

Full Description

  • Add to Wishlist
  • ISBN13: 978-1-4302-5728-8
  • 756 Pages
  • User Level: Intermediate to Advanced
  • Publication Date: July 23, 2013
  • Available eBook Formats: EPUB, MOBI, PDF

Related Titles

  • Pro Oracle Identity and Access Management Suite
  • Mastering Oracle GoldenGate
  • Oracle Application Express Administration
  • Expert Oracle Indexing and Access Paths, 2nd Edition
  • Pro Oracle GoldenGate for the DBA
Full Description

Pro Oracle Database 12c 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 12c Administration is the book you need to help elevate yourself to the level of Professional Oracle Database Administrator.

  • Covers multi-tenant container and pluggable database implementation and management
  • 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
  • Manage pluggable and multi-tenant databases
  • 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 12c 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

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 Fundamentals
  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
  23. Pluggable Databases
Source Code/Downloads

Downloads are available to accompany this book.

Your operating system can likely extract zipped downloads automatically, but you may require software such as WinZip for PC, or StuffIt on a Mac.


If you think that you've found an error in this book, please let us know by emailing to editorial@apress.com . You will find any confirmed erratum below, so you can check if your concern has already been addressed.
No errata are currently published


    1. Practical Oracle Database Appliance


      View Book

    2. Protecting Oracle Database 12c


      View Book

    3. Expert Oracle Exadata


      View Book

    4. Oracle RMAN Database Duplication


      View Book