Oracle Database 12c DBA Handbook

The Most Complete, Current Oracle DBA Resource

Maintain a high-performance Oracle Database using the best practices and expert techniques in this Oracle Press guide. Oracle Database 12c DBA Handbook is thoroughly updated to cover the new features and utilities, including the multitenant architecture, Oracle Database In-Memory option, and cloud enhancements. Real-world examples for every major configuration are included. You’ll learn how to successfully manage a highly available, robust, secure, and extensible Oracle enterprise database environment.

• Upgrade to Oracle Database 12c
• Plan and manage tablespaces
• Maximize database performance using effective physical database layouts and storage management methods
• Monitor disk space used by database objects
• Manage transactions with undo tablespaces
• Implement expert performance-tuning techniques
• Increase query speed using the new Oracle Database In-Memory option
• Manage database security through authentication, authorization, and auditing
• Take full advantage of the multitenant database architecture
• Enable high availability and scalability with Oracle Real Application Clusters and Oracle Active Data Guard
• Perform backup and recovery with Oracle Recovery Manager
• Manage distributed databases and VLDBs

Table of Contents

Chapter PART I Database Architecture
Chapter 1 Getting Started with the Oracle Architecture
Chapter 2 Upgrading to Oracle Database 12c
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 In-Memory Option
Chapter 10 Database Security and Auditing
Chapter 11 Multitenant Database Architecture

PART III High Availability
Chapter 12 Real Application Clusters
Chapter 13 Backup and Recovery Options
Chapter 14 Using Recovery Manager (RMAN)
Chapter 15 Oracle Data Guard
Chapter 16 Miscellaneous High Availability Features

PART IV Networked Oracle
Chapter 17 Oracle Net
Chapter 18 Managing Large Databases
Chapter 19 Managing Distributed Databases