Oracle Real Application Clusters
Oracle Real Application Clusters
ISBN: 1555582885
EAN: 2147483647
EAN: 2147483647
Year: 2004
Pages: 174
Pages: 174
Authors: Murali Vallath
- 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
Oracle Real Application Clusters
ISBN: 1555582885
EAN: 2147483647
EAN: 2147483647
Year: 2004
Pages: 174
Pages: 174
Authors: Murali Vallath