Table Joins and Other Advanced Tuning (Advanced DBA and Developer)
With Oracle Database 11g, Oracle introduced a new option called Real Application Testing. Real Application Testing allows you to capture a complete database workload on one database and replay it on another database. You can replay the exact workload and you even have the option to synchronize workload timing. This tool is very valuable for load testing on a new application release, database patch, or database upgrade. If you need to tune a specific objector set of queries, ...