Oracle Database 11g DBA Handbook (Osborne ORACLE Press Series) by Bob Bryla and Kevin Loney (Dec 6, 2007)
The essential resource for Oracle DBA-Fully updated and expanded. Manage a flexible, Oracle database high availability with the help of experts from the information contained in this exclusive Oracle Press guide. A full review 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, safety and the use of bullets. You will learn to automate the backup and recovery, provide transparent failover capability, audit and tune performance, and distribute their databases for the company with the Oracle network.
The essential resource for Oracle DBA-Fully updated and expanded. Manage a flexible, Oracle database high availability with the help of experts from the information contained in this exclusive Oracle Press guide. A full review 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, safety and the use of bullets. You will learn to automate the backup and recovery, provide transparent failover capability, audit and tune performance, and distribute their databases for the company with the Oracle network.
- 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