Oracle Database 11g DBA Handbook

by Bryla, Bob; Loney, Kevin

• ISBN13: 9780071496636
• ISBN10: 0071496637
• Edition: 1st
• Format: Paperback
• Copyright: 2007-12-27
• Publisher: McGraw Hill

Summary

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 11 g tools to work--Oracle Total Recall, Oracle Flashback Data Archive, and more

Author Biography

Bob Bryla has more than 20 years of MIS experience as a database designer, systems analyst, and DBA. He currently handles the DBA activities on Lands' End's Oracle Internet databases. Bob is the coauthor, with Kevin Loney, of the previous edition of this book.

Kevin Loney is a veteran Oracle consultant, developer, and DBA. He is a regular presenter at Oracle User Group conferences and is the bestselling author of several Oracle Press titles.

Table of Contents

Database Architecture

Getting Started with the Oracle Architecture

Upgrading to Oracle Database 11g

Planning and Managing Tablespaces

Physical Database Layouts and Storage Management

Database Management

Developing and Implementing Applications

Monitoring Space Usage

Managing Transactions with Undo Tablespaces

Database Tuning

Database Security and Auditing

High Availability

Real Application Clusters

Backup and Recovery Options

Using Recovery Manager (RMAN)

Oracle Data Guard

Miscellaneous High Availability Features

Networked Oracle

Oracle Net

Managing Large Databases

Managing Distributed Databases

Appendix: Installation and Configuration

Index

Table of Contents provided by Publisher. All Rights Reserved.