CHAPTER
9
Table Joins and Other Advanced Tuning (Advanced DBA and Developer)
With Oracle Database 11g and available in 12c, 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 object or set of queries, 12c also offers the SQL Performance Analyzer (SPA). This tool provides the ...
Get Oracle Database 12c Release 2 Performance Tuning Tips & Techniques now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
