Time-HOBI: Index for optimizing star queries
Information Systems
| Hi-index | 0.00 |
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 tablespacesOptimize disk allocation, CPU usage, I/O throughput, and SQL queriesDevelop powerful database management applicationsGuard against human errors using Oracle Flashback and Oracle Automatic Undo ManagementDiagnose and tune system performance using Oracle Automatic Workload Repository and SQL Tuning SetsImplement robust security using authentication, authorization, fine-grained auditing, and fine-grained access controlMaintain high availability using Oracle Real Application Clusters and Oracle Active Data GuardRespond more efficiently to failure scenarios by leveraging the Oracle Automatic Diagnostic Repository and the Oracle Repair AdvisorBack up and restore tables, tablespaces, and databases with Oracle Recovery Manager and Oracle Data Pump Export and ImportWork 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 contentsPart I: Database ArchitectureChapter 1. Getting Started with the Oracle ArchitectureChapter 2. Upgrading to Oracle Database 11gChapter 3. Planning and Managing TablespacesChapter 4. Physical Database Layouts and Storage ManagementPart II: Database ManagementChapter 5. Developing and Implementing ApplicationsChapter 6. Monitoring Space UsageChapter 7. Managing Transactions with Undo TablespacesChapter 8. Database TuningChapter 9. Database Security and AuditingPart III: High AvailabilityChapter 10. Real Application ClustersChapter 11. Backup and Recovery OptionsChapter 12. Using Recovery Manager (RMAN)Chapter 13. Oracle Data GuardChapter 14. Miscellaneous High Availability FeaturesPart IV: Networked OracleChapter 15. Oracle NetChapter 16. Managing Large DatabasesChapter 17. Managing Distributed DatabasesAppendix: Installation and ConfigurationIndex