Oracle Database 11g DBA Handbook

Viac o knihe

Manage a flexible, highly available Oracle database with expert guidance from this comprehensive Oracle Press resource. Fully updated, it covers new features and utilities, detailing how to perform installations, upgrades, and configurations for optimal efficiency and security. Learn to automate backup and recovery, ensure transparent failover, and audit and tune performance while distributing enterprise databases using Oracle Net. The guide includes planning and deploying various tablespaces, optimizing disk allocation, CPU usage, I/O throughput, and SQL queries. Develop robust database management applications and mitigate human errors with Oracle Flashback and Automatic Undo Management. Diagnose and tune system performance through Automatic Workload Repository and SQL Tuning Sets, while implementing security measures like authentication, authorization, and fine-grained auditing. Maintain high availability with Real Application Clusters and Active Data Guard, and respond efficiently to failures using the Automatic Diagnostic Repository and Repair Advisor. Backup and restore data with Recovery Manager and Data Pump, and work with networked databases, data warehouses, and VLDBs. Utilize the latest tools, including Total Recall and Flashback Data Archive, to enhance your database management capabilities.