---

Oracle Real Application Clusters

ISBN: 1555582885
EAN: 2147483647

Year: 2004
Pages: 174

Authors: Murali Vallath

BUY ON AMAZON

• Table of Contents
• BackCover
• Oracle Real Application Clusters
• Preface
• How to use this book
• Acknowledgments
• Part I: Concepts
• Chapter 1: Requirements Analysis
• 1.2 Modern business requirements
• 1.3 Conclusion
• Chapter 2: Hardware Concepts
• 2.2 Uniprocessor model
• 2.3 Multiprocessor model
• 2.4 Clustered systems
• 2.5 Clustered configuration
• 2.6 How clusters work
• 2.7 Disk configuration
• 2.8 Storage system architectures
• 2.9 Disk allocation
• 2.10 Conclusion
• Chapter 3: Oracle Database Concepts
• 3.2 Oracle components
• 3.3 Oracle data storage
• 3.4 Optimizer
• 3.5 Dynamic components
• 3.6 Changes between OPS and RAC
• 3.7 Conclusion
• Part II: Architecture
• Chapter 4: Real Application Cluster Architecture
• 4.2 RAC architecture
• 4.3 Clustering Linux systems
• 4.4 Background processes in RAC
• 4.5 Cache fusion
• 4.6 Global resource directory
• 4.7 Lock structure
• 4.8 Global cache management
• 4.9 Mastering of resources
• 4.10 Failover
• 4.11 Recovery
• 4.12 Database files in RAC
• 4.13 Maintaining read consistency in RAC
• 4.14 Conclusion
• Chapter 5: Transaction Management
• 5.2 ACID property of transactional requirements
• 5.3 Singleinstancetransaction behavior
• 5.4 Multi-instance transaction behavior
• 5.5 Conclusion
• Chapter 6: Parallel Processing
• 6.2 What is parallel processing?
• 6.3 Why parallel processing?
• 6.4 Oracle and parallel processing
• 6.5 Parallel query architecture
• 6.6 Parallel processing in RAC
• 6.7 Parallel load operations
• 6.8 Parallel recovery
• 6.9 Troubleshooting parallel processing
• 6.10 Tuning the parallel query
• Chapter 7: Designing Databases for RAC
• 7.2 Database design practices
• 7.3 Tablespace management
• 7.4 Selecting the right indexing method
• 7.5 Hash Clusters
• 7.6 Partitioning
• 7.7 Sequence number
• 7.8 Features for data warehouse design
• 7.9 Conclusion
• Chapter 8: Installation and Configuration
• 8.2 Optimal Flexible Architecture (OFA)
• 8.3 Installation
• 8.4 Database creation
• 8.5 Database configuration
• 8.6 Database administration
• 8.7 Adding nodes in RAC
• 8.8 Conclusion
• Chapter 9: Parameters and Views
• 9.2 Types of views
• 9.3 Parameters
• 9.4 Conclusion
• Part III: Operations
• Chapter 10: Availability and Scalability
• 10.2 Availability
• 10.3 Scalability
• 10.4 Maximum availability architecture
• 10.5 Conclusion
• Chapter 11: Migrating to RAC
• 11.2 Analysis process
• 11.3 Cost-benefit analysis
• 11.4 Preparation phase
• 11.5 Capacity planning
• 11.6 Oracle single instance vs. clustered configuration
• 11.7 Migrating from a single instance to RAC
• 11.8 Conclusion
• Chapter 12: Backup and Recovery
• 12.2 Backup
• 12.3 Backup and recovery strategy
• 12.4 Redo internals
• 12.5 Failure and recovery
• 12.6 Flashback queries
• 12.7 Oracle LogMiner
• 12.5 Conclusion
• Chapter 13: Performance Tuning -Tools and Utilities
• 13.2 UTLBSTATUTLESTAT
• 13.3 STATSPACK
• 13.4 Oracle Enterprise Manager
• 13.5 EXPLAIN PLAN
• 13.6 SQL Trace
• 13.7 Oracle event interface
• 13.8 Oracle s Wait interface
• 13.9 Conclusion
• Chapter 14: Tuning a Single Instance
• 14.2 Methodology
• 14.3 Application tuning
• 14.4 Instance tuning
• 14.5 Database tuning
• 14.6 Operating system tuning
• 14.7 Conclusion
• Chapter 15: Performance Tuning - Cluster
• 15.2 Storage subsystem
• 15.3 Cluster interconnect
• 15.4 Cluster instance tuning
• 15.5 Workload characteristics
• 15.5 Workload characteristics
• 15.6 Statistics affecting RAC
• 15.7 Monitoring Cache Transfers
• 15.7 Conclusion
• Chapter 16: Problem Diagnosis
• 16.2 RAC diagnostics
• 16.3 ORADEBUG utility
• 16.4 Critical ORA errors
• 16.5 Remote Diagnostic Agent (RDA)
• 16.6 Conclusion
• Chapter 17: RAC Implementations
• 17.2 Linux
• 17.3 Windows
• 17.4 Conclusion
• Part IV: Appendices
• Appendix 1: Utilities
• A1.2 SRVCTL: Server control
• A1.3 ORADEBUG: Oracle debugger
• Appendix 2: Scripts
• A2.2 Initialization parameter file
• A2.3 Oracle Net files
• A2.4 Capture session statistics
• Appendix 3: References
• Appendix 4: Work Plan
• A4.2 Certification matrix
• A4.3 Work plan RAC migration checklist
• Index
• Index_B
• Index_C
• Index_D
• Index_E
• Index_F
• Index_G
• Index_H
• Index_I
• Index_J
• Index_K
• Index_L
• Index_M
• Index_N
• Index_O
• Index_P
• Index_Q
• Index_R
• Index_S
• Index_T
• Index_U
• Index_V
• Index_W
• Index_X
• List of Figures
• List of Tables