Oracle Database 10g DBA Manual: Managing Robust, Scalable, Highly Available Oracle Databases

Author: Zhu Jie Mei
Publisher:
Publishing Time: Not Available
Features:
- The main content of this book includes designing table spaces (including large files and multiple temporary table spaces) and the physical database structure.
- Managing disk space and CPU usage.
- Using automatic undo management to handle transaction processing.
- Using SQL Access Advisor to optimize queries.
- Using Automatic Workload Repository (AWR) and STATSPACK to monitor and tune the database.
- Implementing fine-grained security with authentication, authorization, and auditing techniques.
- Automating storage management.
- Using Oracle Real Application Clusters (RAC) to support high availability.
- Using Oracle Recovery Manager to perform backups and recovery.
- Using Oracle Data Guard and Flashback features for data protection and disaster recovery.
- Managing Very Large Databases (VLDBs) and distributed databases.