Oracle Database 11g DBA Handbook

by Bob Bryla, Kevin Loney

Overview

The Essential Resource for Oracle DBAs--Fully Updated and Expanded

Manage a flexible, highly available Oracle database with help from the expert information contained in this exclusive Oracle Press guide. Fully revised to cover every new feature and utility, Oracle Database 11g DBA Handbook shows how to perform a new installation, upgrade from previous versions, configure hardware and software for maximum efficiency, and employ bulletproof security. You will learn to automate the backup and recovery process, provide transparent failover capability, audit and tune performance, and distribute your enterprise databases with Oracle Net.

• Plan and deploy permanent, temporary, and bigfile tablespaces
• Optimize disk allocation, CPU usage, I/O throughput, and SQL queries
• Develop powerful database management applications
• Guard against human errors using Oracle Flashback and Oracle Automatic Undo Management
• Diagnose and tune system performance using Oracle Automatic Workload Repository and SQL Tuning Sets
• Implement robust security using authentication, authorization, fine-grained auditing, and fine-grained access control
• Maintain high availability using Oracle Real Application Clusters and Oracle Active Data Guard
• Respond more efficiently to failure scenarios by leveraging the Oracle Automatic Diagnostic Repository and the Oracle Repair Advisor
• Back up and restore tables, tablespaces, and databases with Oracle Recovery Manager and Oracle Data Pump Export and Import
• Work with networked databases, data warehouses, and VLDBs
• Put the latest Oracle Database 11g tools to work--Oracle Total Recall, Oracle Flashback Data Archive, and more

Product Details

ISBN-13:	9780071595797
Publisher:	McGraw Hill LLC
Publication date:	12/27/2007
Series:	Oracle Press
Sold by:	Barnes & Noble
Format:	eBook
Pages:	670
File size:	20 MB
Note:	This product may take a few minutes to download.

About the Author

Bob Bryla (Plattville, WI) OCP, is an Oracle 8, 8i, 9i, 10g, and 11g 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. Bob is the co-author of the Oracle Database 11g DBA Handbook from Oracle Press (McGraw-Hill), and the OCA: Oracle 10g Administration I Study Guide (1Z0-042) and OCP: Oracle 10g Administration II Study Guide: Exam 1Z0-043 from Sybex/Wiley.

Kevin Loney (Wilmington, DE) is a veteran Oracle developer and DBA. He is the author of the best-selling Oracle8 DBA Handbook and co-author of Advanced Tuning and Administration and Oracle8i: The Complete Reference. He frequently makes presentations at Oracle conferences and contributes to Oracle Magazine

Table of Contents

Part I: Database Architecture Chapter 1. Getting Started with the Oracle Architecture Chapter 2. Upgrading to Oracle Database 11g Chapter 3. Planning and Managing Tablespaces Chapter 4. Physical Database Layouts and Storage Management Part II: Database Management Chapter 5. Developing and Implementing Applications Chapter 6. Monitoring Space Usage Chapter 7. Managing Transactions with Undo Tablespaces Chapter 8. Database Tuning Chapter 9. Database Security and Auditing Part III: High Availability Chapter 10. Real Application Clusters Chapter 11. Backup and Recovery Options Chapter 12. Using Recovery Manager (RMAN) Chapter 13. Oracle Data Guard Chapter 14. Miscellaneous High Availability Features Part IV: Networked Oracle Chapter 15. Oracle Net Chapter 16. Managing Large Databases Chapter 17. Managing Distributed Databases Appendix: Installation and Configuration Index