11g_grid_oltp.pptVIP

RAC Optimized Cache Fusion protocols Improved performance for read-intensive workloads improves any read from disk (not cache) whether short random reads or large table scans Throughput improved up to 70% for internal read-only benchmark RAC Other Enhancements Fine tune performance, scaling, failover, management Seamless integration with XA and Microsoft Transaction Server Faster and more robust handling of instance crashes and hangs Most of this also in 10.2.0.3 Runtime Connection Load Balancing works with OCI Session Pools Database Control 11gTiled Instance Charts ADDM for RAC Performance expert in a box Identify the most “Globally Significant” performance problems for the entire RAC cluster database Database-wide analysis of: Global cache interconnect issues Global resource contention, e.g. IO bandwidth, hot blocks Globally high-load SQL Skew in instance response times Runs proactively every hour when taking AWR snapshots (default) ASM Fast Mirror Resync Fraction of time to establish redundancy Only changed blocks are resync’ed Benefits: Fast recovery from transient failures Enables pro-active maintenance ASM Preferred Mirror Read Allow local mirror read operations Eliminate network latencies in extended clusters ASM Rolling Upgrades and Patches Maximizes database availability in a cluster How it works: Place cluster in ‘Rolling Migration’ mode Bring down ASM on a cluster node Upgrade or patch software Re-start ASM Stop ‘Rolling Migration’ mode after upgrading all nodes ASM Scalability and Performance Enhancements Variable size extents grows automatically with file size Benefits Increase ASM file size Reduce memory utilization in SGA 100% automatic Multiple Allocation Unit Size support SYSASM Privilege SYSASM role to manage ASM instances separates duty of DBAs and storage administrators SYSDBA will be deprecated for ASM management: Oracle Database 11g Release 1 behaves as in 10g In future releases SYSDBA privileges restricted in ASM instances A