Synopses & Reviews
The Essential Resource for Oracle DBAs--Fully Updated and ExpandedManage 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
Synopsis
Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product.
The Essential Resource for Oracle DBAs--Fully Updated and ExpandedManage 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
Table of Contents
Part One: Database Architecture
Chapter 1 Getting Started with the Oracle Architecture
Chapter 2 Upgrading to Oracle Database 10g
Chapter 3 Planning and Managing Tablespaces
Chapter 4 Physical Database Layouts and Storage Management
Part Two: 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 UsingSTATSPACK
Chapter 10 Database Security and Auditing
Part 3: High Availability
Chapter 11 Real Application Clusters
Chapter 12 Backup and Recovery Options
Chapter 13 Using Recovery Manager (RMAN)
Chapter 14 Oracle Data Guard
Chapter 15 Miscellaneous High Availability Features
Part 4: Networked Oracle
Chapter 16 Oracle Net
Chapter 17 Managing Large Databases
Chapter 18 Managing Distributed Databases
Appendices
Password Verify Function