Oracle Database 10g DBA Handbook

0.0

Maintain a high-performance Oracle enterprise database with help from this exclusive Oracle Press guide. Oracle Database 10g DBA Handbook explains how to install Oracle Database 10g, or upgrade from an earlier version, and take full advantage of all the new and improvedmanagement, scalability, availability, and security features. Written by Oracle experts, the book covers Automatic Undo Management, Oracle Real Application Clusters, Oracle Recovery Manager, Oracle Data Guard, and much more. Plan tablespaces--including bigfiles and multiple temporary tablespaces--and physical database layout Manage disk space and CPU usage Use Automatic Undo Management to manage transactions Tune queries using the SQL Access Advisor Monitor and tune your database with the Automated Workload Repository and STATSPACK Implement fine-grained security using authentication, authorization, and auditing techniques Automate the management of the memory areas Enable high availability using Oracle Real Application Clusters Perform backup and recovery with Oracle Recovery Manager Use Oracle Data Guard and the flashback features for data protection and disaster recovery Manage Very Large Databases (VLDB) and distributed databases About The Author Kevin Loney (Wilmington, DE) is a consultant for TUSC and a veteran Oracle developer and DBA. He is among the most renowned members of the Oracle Professional community and is a regular presenter at IOUG-A, Oracle OpenWorld, and regional User Group conferences. Kevin is the coauthor of several of our best-selling titles such as The Complete Reference and the DBA Handbook. Bob Bryla (Plattville, WI) has over 20 years of experience in MIS, ranging from database and data warehouse design to system administration on multiple hardware platforms. Bob is currently lead designer and data analyst for Lands? End?s online store database and handles the DBA activities on Lands? End Oracle Internet databases. Bob has also technically reviewed and authored or coauthored several well-reviewed Oracle certification titles for Sybex Table Of Contents PART I Database Architecture Chapter 1. Getting Started with the Oracle Architecture Chapter 2. Upgrading to 10g Chapter 3. Planning and Managing Tablespacesv Chapter 4. Physical Database Layouts PART II Database Management Chapter 5. Real Application Clusters Chapter 6. Managing the Development Process Chapter 7. Monitoring Space Usage Chapter 8. Managing Transactions Chapter 9. Database Tuning Chapter 10. Using STATSPACK Chapter 11. Database Security and Auditing Chapter 12. Backup and Recovery Options Chapter 13. Using Recovery Manager (RMAN) Chapter 14. High Availability PART III Networked Oracle Chapter 15. Oracle Net Chapter 16. Managing Large Databases Chapter 17. Managing Distributed Databases