1 Customer Case Study Real Application Testing Usage at Bank of America RAM Migration Challenge Challenge ? Complexity - 7500 nightly batch jobs requiring 24x6 support ? Scale - RAM production platform spread across 3 DB clusters and 18 separate Oracle databases ? Older Solaris Oracle 9i Platform was at or near CPU capacity – 700+ minutes of sustained DB utilization above 95% ? Critical business need: Upgrade for both support (since 9i) and capacity reasons ? Several hundred-thousand individual SQL Statements to potentially tune for 10g ? Minimal instrumentation to capture production SQL Statement and binds 2 Host CPU Utilization - %Busy3 Solution ? A combined dual migration involving ? Solaris ? Linux ? Oracle Database 9i ? 10.2.0.4 ? Phased migration plan: 1. Reporting, 2

Join for free to read