文档介绍:Exploiting Oracle Tools and Utilities for
Monitoring and Testing Oracle RAC
OTN Tour - 2011
(Thailand, China, Philippines, New Zealand)
Murali Vallath
murali.******@
About me…
Independent Oracle Consultant - Summersky Enterprises
blog:
twitter/ym/skype: muralivallath
email: murali.******@
Test! Test! Test!
• Independent load testing using tools - Stability
• Test in house application on single instance
• Test across the cluster
– Failover Testing
– H/A testing with DR
– Performance Testing
• Simulate current production
– Scalability Testing
– Contention Testing
• Run burn out tests. 48, 68… 72 hour tests
Methodology
• Problem Statement
– What, When, Where
• Information Gathering (Significance)
• Area Identification
• Area Drill-down
• Problem Resolution
• Test Against Baseline
• Repeat the process
Load Testing Tools
• Third party tools
• Open source load generation tools
– Hammerora
• http://hammerora./
• Swingbench
–
–/apex/f?p=105:206:706
267422512372::NO
Start with one Instance
• Application Tuning
• Instance Tuning
• Database Tuning
• O/S Tuning
© Summersky Enterprises LLC | 2011 | Murali Vallath | Slide: 6
Tools & Utilities
• Enterprise Manager (EM)
– AWR (Automatic Workload Repository)
– ADDM (Automatic Database Diagnostics Monitoring)
– Advisors
• Oracle’s Wait Interface
• Oracle’s Event Interface
• Utilities from Metalink
Oracle Real Application Cluster | Murali Vallath | Slide: 7
Utilities from Metalink and OTN
• LTOM
• OSWATCHER
• RAC-DDT
• BLOATMASTER
• HANGFG
© Summersky Enterprises LLC | 2011 | Murali Vallath | Slide: 8
Lite Onboard Monitor (LTOM)
• Real-time diagnostic platform
• Proactive rather than reactive
• Real-time automatic problem detection and
data collection
• Reduces time to solve problems and