One of the most exciting new features of Oracle 11g is what they are calling "Real Application Testing" which includes a few new features, one of which is database replay. The database replay feature will allow you to capture a real production workload into "capture files". This includes all sessions and all activity unless filtered. When the capture process is complete, you then "play" the workload on a test environment and produce a report which will give you very exact information such as DB time, user calls, top events including wait events, and top SQL statements. This "replay" information is collected and compared with the "capture" information to give you an excellent indication of how a change will affect a production application. This is useful to determine behavior of a database upgrade or application of a patch, initialization parameter change, additional or different types of indexes, etc. and takes the mystery out of "how will this change affect my process"?
Get updates and IT job market news on Facebook
Receive quick news updates via Twitter
Connect your professional profile with us on LinkedIn
View course sample and more on YouTube