O'Reilly logo

Oracle Database 12c Release 2 Performance Tuning Tips & Techniques by Richard Niemiec

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Images

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required