Discover how Oracle Real Application Clusters (RAC) scales demanding online transaction processing workloads in this 39-minute conference talk. Learn from PayPal's Pramod Garre as he shares experiences scaling complex database workloads. Explore new generation Oracle RAC scalability, high availability, and queue workload scaling. Understand PayPal's database requirements and Oracle RAC's innovative cache fusion technology. Delve into efficient resource management, adaptation to modern CPU architectures, and zero-downtime features. Examine Oracle RAC deployment patterns at PayPal, performance characteristics, and customization options. Gain insights into continuous improvements, database client load balancing, and failure handling without application changes. Conclude with a summary of zero-downtime grid infrastructure patching and cache fusion hardening techniques.
Scaling PayPal OLTP Workloads with Oracle Real Application Clusters
Overview
Syllabus
Intro
New Generation Oracle RAC Scalability and High Availability
New Generation Oracle RAC scales Queue workloads
PayPal Database Requirements
1 Innovative and Unique : Oracle RAC Cache Fusion
Oracle RAC Cache Fusion Optimizations Out of the box better Application Performance
Cache Fusion Optimizations on Exadata
2 Efficient and Adaptive Resource Management
Adapt to Modern CPU Architectures
Oracle RAC Optimized Priority for Critical Processes Leaner Threaded Processes benefit from current CPU architectures
ORACLE RAC-Zero Downtime
ORACLE RAC - Reconfiguration Customizations
Database Reliability Framework - Adapt to changing workloads
Oracle RAC High Availability Optimizations Continuous improvements in every release
Database Clients - Load Balancing and Failure Handling Requires no changes to the Application
Oracle RAC Deployment Pattern at PayPal
Oracle RAC Scalability Optimizations Continuous improvements in every release
Oracle RAC - Performance Characteristics
ORACLE RAC - Performance Customizations
Summary
Zero Downtime Grid Infrastructure Patching
Oracle RAC Cache Fusion Hardening
Taught by
Oracle
